DBA Data[Home] [Help]

APPS.GMF_AR_GET_INVOICE_HEADER dependencies on RA_CUSTOMER_TRX_ALL

Line 43: RA_CUSTOMER_TRX_ALL arc

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)
47: AND nvl(t_end_date, arc.last_update_date))

Line 119: RA_CUSTOMER_TRX_ALL arc

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)
123: AND nvl(t_end_date, arc.last_update_date))