API to update the attribute in AR invoice:
Please find the below script for update the attribute in AR Invoice:
DECLARE
CURSOR c_ers_num is select trx_number,interface_header_attribute15 from ra_customer_trx_all where trx_number in(select distinct trx_number from XX_AR_CM_APPLY);
BEGIN
for i in c_ers_num loop
update ra_customer_trx_all set interface_header_attribute15=i.interface_header_attribute15 where (trx_number=i.trx_number||'A'
OR trx_number=i.trx_number||'B' OR trx_number=i.trx_number||'C')
and interface_header_attribute15='Y' and org_id=396;
DBMS_OUTPUT.PUT_LINE('Cursor Invoice#, '||i.trx_number||'A'||' ,Base Invoice Updated Count#, '||sql%rowcount||' ,Cursor DFF val'||i.interface_header_attribute15);
end loop;
COMMIT;
END;
Please find the below script for update the attribute in AR Invoice:
DECLARE
CURSOR c_ers_num is select trx_number,interface_header_attribute15 from ra_customer_trx_all where trx_number in(select distinct trx_number from XX_AR_CM_APPLY);
BEGIN
for i in c_ers_num loop
update ra_customer_trx_all set interface_header_attribute15=i.interface_header_attribute15 where (trx_number=i.trx_number||'A'
OR trx_number=i.trx_number||'B' OR trx_number=i.trx_number||'C')
and interface_header_attribute15='Y' and org_id=396;
DBMS_OUTPUT.PUT_LINE('Cursor Invoice#, '||i.trx_number||'A'||' ,Base Invoice Updated Count#, '||sql%rowcount||' ,Cursor DFF val'||i.interface_header_attribute15);
end loop;
COMMIT;
END;
No comments:
Post a Comment