隨手筆記

create table select * from bkp_ra_cust_trx_184210
as select * from ra_customer_trx_all where customer_trx_id=184210
and org_id=202;

create table select * from bkp_ps_184210
as select * from AR_PAYMENT_SCHEDULES_ALL
where CUSTOMER_TRX_ID=184210
and org_id=202;

create table select * from  bkp_xla_entities_184210
as select * from xla.XLA_TRANSACTION_ENTITIES
where nvl(source_id_int_1,-99)=184210;

update ra_customer_trx_all
set trx_number='&ID'
where customer_trx_id=184210
and org_id=202;

update AR_PAYMENT_SCHEDULES_ALL
set TRX_NUMBER='&ID'
where CUSTOMER_TRX_ID=184210
and org_id=202;

update xla.XLA_TRANSACTION_ENTITIES
set transaction_number='&ID'
where nvl(source_id_int_1,-99)=184210
and entity_id=16835974
and application_id=222;

Update wsh_new_deliveries
   set name = to_char(delivery_id)
 where delivery_id = &ID;