eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_MERGE_PVT dependencies on ARP_STANDARD

Line 190: , last_updated_by=arp_standard.profile.user_id

186: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
187: ,INVOICE_TO_CUST_ACCOUNT_ID=NUM_COL2_NEW_LIST(I)
188: ,END_CUSTOMER_CUST_ACCOUNT_ID=NUM_COL3_NEW_LIST(I)
189: , LAST_UPDATE_DATE=SYSDATE
190: , last_updated_by=arp_standard.profile.user_id
191: , last_update_login=arp_standard.profile.last_update_login
192: , REQUEST_ID=req_id
193: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
194: , PROGRAM_ID=arp_standard.profile.program_id

Line 191: , last_update_login=arp_standard.profile.last_update_login

187: ,INVOICE_TO_CUST_ACCOUNT_ID=NUM_COL2_NEW_LIST(I)
188: ,END_CUSTOMER_CUST_ACCOUNT_ID=NUM_COL3_NEW_LIST(I)
189: , LAST_UPDATE_DATE=SYSDATE
190: , last_updated_by=arp_standard.profile.user_id
191: , last_update_login=arp_standard.profile.last_update_login
192: , REQUEST_ID=req_id
193: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
194: , PROGRAM_ID=arp_standard.profile.program_id
195: , PROGRAM_UPDATE_DATE=SYSDATE

Line 193: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

189: , LAST_UPDATE_DATE=SYSDATE
190: , last_updated_by=arp_standard.profile.user_id
191: , last_update_login=arp_standard.profile.last_update_login
192: , REQUEST_ID=req_id
193: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
194: , PROGRAM_ID=arp_standard.profile.program_id
195: , PROGRAM_UPDATE_DATE=SYSDATE
196: WHERE QUOTE_HEADER_ID=PRIMARY_KEY_ID_LIST(I)
197: ;

Line 194: , PROGRAM_ID=arp_standard.profile.program_id

190: , last_updated_by=arp_standard.profile.user_id
191: , last_update_login=arp_standard.profile.last_update_login
192: , REQUEST_ID=req_id
193: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
194: , PROGRAM_ID=arp_standard.profile.program_id
195: , PROGRAM_UPDATE_DATE=SYSDATE
196: WHERE QUOTE_HEADER_ID=PRIMARY_KEY_ID_LIST(I)
197: ;
198:

Line 380: , last_updated_by=arp_standard.profile.user_id

376: UPDATE ASO_QUOTE_LINES yt SET
377: INVOICE_TO_CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
378: , END_CUSTOMER_CUST_ACCOUNT_ID=NUM_COL2_NEW_LIST(I)
379: , LAST_UPDATE_DATE=SYSDATE
380: , last_updated_by=arp_standard.profile.user_id
381: , last_update_login=arp_standard.profile.last_update_login
382: , REQUEST_ID=req_id
383: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
384: , PROGRAM_ID=arp_standard.profile.program_id

Line 381: , last_update_login=arp_standard.profile.last_update_login

377: INVOICE_TO_CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
378: , END_CUSTOMER_CUST_ACCOUNT_ID=NUM_COL2_NEW_LIST(I)
379: , LAST_UPDATE_DATE=SYSDATE
380: , last_updated_by=arp_standard.profile.user_id
381: , last_update_login=arp_standard.profile.last_update_login
382: , REQUEST_ID=req_id
383: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
384: , PROGRAM_ID=arp_standard.profile.program_id
385: , PROGRAM_UPDATE_DATE=SYSDATE

Line 383: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

379: , LAST_UPDATE_DATE=SYSDATE
380: , last_updated_by=arp_standard.profile.user_id
381: , last_update_login=arp_standard.profile.last_update_login
382: , REQUEST_ID=req_id
383: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
384: , PROGRAM_ID=arp_standard.profile.program_id
385: , PROGRAM_UPDATE_DATE=SYSDATE
386: WHERE QUOTE_LINE_ID=PRIMARY_KEY_ID_LIST(I)
387: ;

Line 384: , PROGRAM_ID=arp_standard.profile.program_id

380: , last_updated_by=arp_standard.profile.user_id
381: , last_update_login=arp_standard.profile.last_update_login
382: , REQUEST_ID=req_id
383: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
384: , PROGRAM_ID=arp_standard.profile.program_id
385: , PROGRAM_UPDATE_DATE=SYSDATE
386: WHERE QUOTE_LINE_ID=PRIMARY_KEY_ID_LIST(I)
387: ;
388:

Line 541: , last_updated_by=arp_standard.profile.user_id

537: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
538: UPDATE ASO_SHIPMENTS yt SET
539: SHIP_TO_CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
540: , LAST_UPDATE_DATE=SYSDATE
541: , last_updated_by=arp_standard.profile.user_id
542: , last_update_login=arp_standard.profile.last_update_login
543: , REQUEST_ID=req_id
544: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
545: , PROGRAM_ID=arp_standard.profile.program_id

Line 542: , last_update_login=arp_standard.profile.last_update_login

538: UPDATE ASO_SHIPMENTS yt SET
539: SHIP_TO_CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
540: , LAST_UPDATE_DATE=SYSDATE
541: , last_updated_by=arp_standard.profile.user_id
542: , last_update_login=arp_standard.profile.last_update_login
543: , REQUEST_ID=req_id
544: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
545: , PROGRAM_ID=arp_standard.profile.program_id
546: , PROGRAM_UPDATE_DATE=SYSDATE

Line 544: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

540: , LAST_UPDATE_DATE=SYSDATE
541: , last_updated_by=arp_standard.profile.user_id
542: , last_update_login=arp_standard.profile.last_update_login
543: , REQUEST_ID=req_id
544: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
545: , PROGRAM_ID=arp_standard.profile.program_id
546: , PROGRAM_UPDATE_DATE=SYSDATE
547: WHERE SHIPMENT_ID=PRIMARY_KEY_ID_LIST(I)
548: ;

Line 545: , PROGRAM_ID=arp_standard.profile.program_id

541: , last_updated_by=arp_standard.profile.user_id
542: , last_update_login=arp_standard.profile.last_update_login
543: , REQUEST_ID=req_id
544: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
545: , PROGRAM_ID=arp_standard.profile.program_id
546: , PROGRAM_UPDATE_DATE=SYSDATE
547: WHERE SHIPMENT_ID=PRIMARY_KEY_ID_LIST(I)
548: ;
549: l_count := l_count + SQL%ROWCOUNT;