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.ARP_CMERGE_ARTRX dependencies on STANDARD

Line 118: , last_updated_by=arp_standard.profile.user_id

114: UPDATE AR_CASH_RECEIPTS yt SET
115: pay_from_customer=NUM_COL1_NEW_LIST(I)
116: ,customer_site_use_id=NUM_COL2_NEW_LIST(I)
117: , LAST_UPDATE_DATE=SYSDATE
118: , last_updated_by=arp_standard.profile.user_id
119: , last_update_login=arp_standard.profile.last_update_login
120: , REQUEST_ID=req_id
121: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
122: , PROGRAM_ID=arp_standard.profile.program_id

Line 119: , last_update_login=arp_standard.profile.last_update_login

115: pay_from_customer=NUM_COL1_NEW_LIST(I)
116: ,customer_site_use_id=NUM_COL2_NEW_LIST(I)
117: , LAST_UPDATE_DATE=SYSDATE
118: , last_updated_by=arp_standard.profile.user_id
119: , last_update_login=arp_standard.profile.last_update_login
120: , REQUEST_ID=req_id
121: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
122: , PROGRAM_ID=arp_standard.profile.program_id
123: , PROGRAM_UPDATE_DATE=SYSDATE

Line 121: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

117: , LAST_UPDATE_DATE=SYSDATE
118: , last_updated_by=arp_standard.profile.user_id
119: , last_update_login=arp_standard.profile.last_update_login
120: , REQUEST_ID=req_id
121: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
122: , PROGRAM_ID=arp_standard.profile.program_id
123: , PROGRAM_UPDATE_DATE=SYSDATE
124: WHERE cash_receipt_id=PRIMARY_KEY_ID_LIST(I)
125: ;

Line 122: , PROGRAM_ID=arp_standard.profile.program_id

118: , last_updated_by=arp_standard.profile.user_id
119: , last_update_login=arp_standard.profile.last_update_login
120: , REQUEST_ID=req_id
121: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
122: , PROGRAM_ID=arp_standard.profile.program_id
123: , PROGRAM_UPDATE_DATE=SYSDATE
124: WHERE cash_receipt_id=PRIMARY_KEY_ID_LIST(I)
125: ;
126: l_count := l_count + SQL%ROWCOUNT;

Line 249: , last_updated_by=arp_standard.profile.user_id

245: UPDATE AR_PAYMENT_SCHEDULES yt SET
246: customer_id=NUM_COL1_NEW_LIST(I)
247: ,customer_site_use_id=NUM_COL2_NEW_LIST(I)
248: , LAST_UPDATE_DATE=SYSDATE
249: , last_updated_by=arp_standard.profile.user_id
250: , last_update_login=arp_standard.profile.last_update_login
251: , REQUEST_ID=req_id
252: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
253: , PROGRAM_ID=arp_standard.profile.program_id

Line 250: , last_update_login=arp_standard.profile.last_update_login

246: customer_id=NUM_COL1_NEW_LIST(I)
247: ,customer_site_use_id=NUM_COL2_NEW_LIST(I)
248: , LAST_UPDATE_DATE=SYSDATE
249: , last_updated_by=arp_standard.profile.user_id
250: , last_update_login=arp_standard.profile.last_update_login
251: , REQUEST_ID=req_id
252: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
253: , PROGRAM_ID=arp_standard.profile.program_id
254: , PROGRAM_UPDATE_DATE=SYSDATE

Line 252: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

248: , LAST_UPDATE_DATE=SYSDATE
249: , last_updated_by=arp_standard.profile.user_id
250: , last_update_login=arp_standard.profile.last_update_login
251: , REQUEST_ID=req_id
252: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
253: , PROGRAM_ID=arp_standard.profile.program_id
254: , PROGRAM_UPDATE_DATE=SYSDATE
255: WHERE payment_schedule_id=PRIMARY_KEY_ID_LIST(I)
256: ;

Line 253: , PROGRAM_ID=arp_standard.profile.program_id

249: , last_updated_by=arp_standard.profile.user_id
250: , last_update_login=arp_standard.profile.last_update_login
251: , REQUEST_ID=req_id
252: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
253: , PROGRAM_ID=arp_standard.profile.program_id
254: , PROGRAM_UPDATE_DATE=SYSDATE
255: WHERE payment_schedule_id=PRIMARY_KEY_ID_LIST(I)
256: ;
257: l_count := l_count + SQL%ROWCOUNT;

Line 469: , last_updated_by=arp_standard.profile.user_id

465: ,ship_to_site_use_id=NUM_COL6_NEW_LIST(I)
466: ,sold_to_customer_id=NUM_COL7_NEW_LIST(I)
467: ,sold_to_site_use_id=NUM_COL8_NEW_LIST(I)
468: , LAST_UPDATE_DATE=SYSDATE
469: , last_updated_by=arp_standard.profile.user_id
470: , last_update_login=arp_standard.profile.last_update_login
471: , REQUEST_ID=req_id
472: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
473: , PROGRAM_ID=arp_standard.profile.program_id

Line 470: , last_update_login=arp_standard.profile.last_update_login

466: ,sold_to_customer_id=NUM_COL7_NEW_LIST(I)
467: ,sold_to_site_use_id=NUM_COL8_NEW_LIST(I)
468: , LAST_UPDATE_DATE=SYSDATE
469: , last_updated_by=arp_standard.profile.user_id
470: , last_update_login=arp_standard.profile.last_update_login
471: , REQUEST_ID=req_id
472: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
473: , PROGRAM_ID=arp_standard.profile.program_id
474: , PROGRAM_UPDATE_DATE=SYSDATE

Line 472: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id

468: , LAST_UPDATE_DATE=SYSDATE
469: , last_updated_by=arp_standard.profile.user_id
470: , last_update_login=arp_standard.profile.last_update_login
471: , REQUEST_ID=req_id
472: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
473: , PROGRAM_ID=arp_standard.profile.program_id
474: , PROGRAM_UPDATE_DATE=SYSDATE
475: WHERE customer_trx_id=PRIMARY_KEY_ID_LIST(I)
476: ;

Line 473: , PROGRAM_ID=arp_standard.profile.program_id

469: , last_updated_by=arp_standard.profile.user_id
470: , last_update_login=arp_standard.profile.last_update_login
471: , REQUEST_ID=req_id
472: , PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
473: , PROGRAM_ID=arp_standard.profile.program_id
474: , PROGRAM_UPDATE_DATE=SYSDATE
475: WHERE customer_trx_id=PRIMARY_KEY_ID_LIST(I)
476: ;
477: l_count := l_count + SQL%ROWCOUNT;

Line 782: , last_updated_by=arp_standard.profile.user_id

778: ,ORIG_SYSTEM_SOLD_CUSTOMER_REF=VCHAR_COL3_NEW_LIST(I)
779: ,ORIG_SYSTEM_BILL_ADDRESS_REF=VCHAR_COL4_NEW_LIST(I)
780: ,ORIG_SYSTEM_SHIP_ADDRESS_REF=VCHAR_COL5_NEW_LIST(I)
781: , LAST_UPDATE_DATE=SYSDATE
782: , last_updated_by=arp_standard.profile.user_id
783: , last_update_login=arp_standard.profile.last_update_login
784: WHERE ROWID=PRIMARY_KEY1_LIST(I)
785: ;
786: l_count := l_count + SQL%ROWCOUNT;

Line 783: , last_update_login=arp_standard.profile.last_update_login

779: ,ORIG_SYSTEM_BILL_ADDRESS_REF=VCHAR_COL4_NEW_LIST(I)
780: ,ORIG_SYSTEM_SHIP_ADDRESS_REF=VCHAR_COL5_NEW_LIST(I)
781: , LAST_UPDATE_DATE=SYSDATE
782: , last_updated_by=arp_standard.profile.user_id
783: , last_update_login=arp_standard.profile.last_update_login
784: WHERE ROWID=PRIMARY_KEY1_LIST(I)
785: ;
786: l_count := l_count + SQL%ROWCOUNT;
787: IF l_last_fetch THEN

Line 909: , last_updated_by=arp_standard.profile.user_id

905: UPDATE AR_DISTRIBUTIONS yt SET
906: third_party_id=NUM_COL1_NEW_LIST(I)
907: ,third_party_sub_id=NUM_COL2_NEW_LIST(I)
908: , LAST_UPDATE_DATE=SYSDATE
909: , last_updated_by=arp_standard.profile.user_id
910: , last_update_login=arp_standard.profile.last_update_login
911: WHERE line_id=PRIMARY_KEY_ID_LIST(I)
912: ;
913: l_count := l_count + SQL%ROWCOUNT;

Line 910: , last_update_login=arp_standard.profile.last_update_login

906: third_party_id=NUM_COL1_NEW_LIST(I)
907: ,third_party_sub_id=NUM_COL2_NEW_LIST(I)
908: , LAST_UPDATE_DATE=SYSDATE
909: , last_updated_by=arp_standard.profile.user_id
910: , last_update_login=arp_standard.profile.last_update_login
911: WHERE line_id=PRIMARY_KEY_ID_LIST(I)
912: ;
913: l_count := l_count + SQL%ROWCOUNT;
914: IF l_last_fetch THEN