APPS.GMF_AR_GET_INVOICE_HEADER dependencies on RA_CUST_TRX_TYPES_ALL

Line 41: RA_CUST_TRX_TYPES_ALL racust,

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
45: AND (arp.CUSTOMER_TRX_ID = arc.customer_trx_id)

Line 53: FROM RA_CUST_TRX_TYPES_ALL t

49: AND nvl(art.language,apps_base_language) = apps_base_language
50: AND (arc.CUST_TRX_TYPE_ID = racust.CUST_TRX_TYPE_ID)
51: AND (racust.CUST_TRX_TYPE_ID, racust.ORG_ID) =
52: ( SELECT t.CUST_TRX_TYPE_ID, t.ORG_ID
53: FROM RA_CUST_TRX_TYPES_ALL t
54: WHERE t.CUST_TRX_TYPE_ID = racust.CUST_TRX_TYPE_ID
55: AND rownum=1)
56: group by
57: arc.CUSTOMER_TRX_ID, arc.LAST_UPDATED_BY, arc.LAST_UPDATE_DATE,

Line 117: RA_CUST_TRX_TYPES_ALL racust,

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
121: AND (arp.CUSTOMER_TRX_ID = arc.customer_trx_id)

Line 129: FROM RA_CUST_TRX_TYPES_ALL t

125: AND nvl(art.language,apps_base_language) = apps_base_language
126: AND (arc.CUST_TRX_TYPE_ID = racust.CUST_TRX_TYPE_ID)
127: AND (racust.CUST_TRX_TYPE_ID, racust.ORG_ID) =
128: ( SELECT t.CUST_TRX_TYPE_ID, t.ORG_ID
129: FROM RA_CUST_TRX_TYPES_ALL t
130: WHERE t.CUST_TRX_TYPE_ID = racust.CUST_TRX_TYPE_ID
131: AND rownum=1)
132: group by
133: arc.CUSTOMER_TRX_ID, arc.LAST_UPDATED_BY, arc.LAST_UPDATE_DATE,