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.GMF_AR_GET_INVOICE_HEADER dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 42: AR_PAYMENT_SCHEDULES_ALL arp,

38: arc.CREATED_FROM, sum(arp.AMOUNT_DUE_ORIGINAL), sum(arp.AMOUNT_DUE_REMAINING),
39: art.NAME, racust.NAME, racust.TYPE
40: from RA_TERMS_TL art,
41: RA_CUST_TRX_TYPES_ALL racust,
42: AR_PAYMENT_SCHEDULES_ALL arp,
43: RA_CUSTOMER_TRX_ALL arc
44: where arc.CUSTOMER_TRX_ID = invoice_id
45: AND (arp.CUSTOMER_TRX_ID = arc.customer_trx_id)
46: AND (arc.last_update_date between nvl(t_start_date, arc.last_update_date)

Line 118: AR_PAYMENT_SCHEDULES_ALL arp,

114: arc.CREATED_FROM, sum(arp.AMOUNT_DUE_ORIGINAL), sum(arp.AMOUNT_DUE_REMAINING),
115: art.NAME, racust.NAME, racust.TYPE
116: from RA_TERMS_TL art,
117: RA_CUST_TRX_TYPES_ALL racust,
118: AR_PAYMENT_SCHEDULES_ALL arp,
119: RA_CUSTOMER_TRX_ALL arc
120: where arc.previous_customer_trx_id = invoice_id
121: AND (arp.CUSTOMER_TRX_ID = arc.customer_trx_id)
122: AND (arc.last_update_date between nvl(t_start_date, arc.last_update_date)