APPS.GMF_AR_GET_INVOICE_HEADER dependencies on RA_TERMS_TL

Line 40: from RA_TERMS_TL art,

36: arc.DOC_SEQUENCE_VALUE, arc.PAYING_CUSTOMER_ID, arc.PAYING_SITE_USE_ID,
37: arc.RELATED_BATCH_SOURCE_ID, arc.DEFAULT_TAX_EXEMPT_FLAG,
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

Line 116: from RA_TERMS_TL art,

112: arc.DOC_SEQUENCE_VALUE, arc.PAYING_CUSTOMER_ID, arc.PAYING_SITE_USE_ID,
113: arc.RELATED_BATCH_SOURCE_ID, arc.DEFAULT_TAX_EXEMPT_FLAG,
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