DBA Data[Home] [Help]

APPS.ARP_ETAX_AUTOINV_UTIL dependencies on RA_CUST_TRX_TYPES

Line 143: RA_CUST_TRX_TYPES TT,

139: DECODE(REL_TT.TYPE,'DEP' , NULL, REL_T.customer_trx_id), /* Bug 9117334 */
140: DECODE(REL_T.customer_trx_id, NULL, NULL, REL_T.trx_number),
141: DECODE(REL_T.customer_trx_id, NULL, NULL, REL_T.trx_date)
142: FROM RA_CUSTOMER_TRX T,
143: RA_CUST_TRX_TYPES TT,
144: RA_BATCH_SOURCES TB,
145: FND_CURRENCIES C,
146: FND_DOCUMENT_SEQUENCES SEQ,
147: AR_SYSTEM_PARAMETERS AR,

Line 153: RA_CUST_TRX_TYPES REL_TT

149: HZ_CUST_SITE_USES BTCSU,
150: HZ_CUST_ACCT_SITES BTPS,
151: HR_ORGANIZATION_UNITS HR,
152: RA_CUSTOMER_TRX REL_T,
153: RA_CUST_TRX_TYPES REL_TT
154: WHERE T.request_id = p_request_id
155: AND NVL(T.previous_customer_trx_id, -99) =
156: DECODE(p_phase, 'INV', -99, T.previous_customer_trx_id)
157: AND T.invoice_currency_code = C.currency_code

Line 418: RA_CUST_TRX_TYPES ITT,

414: HZ_CUST_ACCOUNTS STCA,
415: HZ_CUST_ACCT_SITES STPS,
416: HZ_CUST_SITE_USES STCSU,
417: RA_CUSTOMER_TRX IT,
418: RA_CUST_TRX_TYPES ITT,
419: RA_CUSTOMER_TRX_LINES ITL,
420: RA_CUST_TRX_LINE_GL_DIST REC,
421: HZ_PARTY_SITES STPSU,
422: HZ_PARTY_SITES BTPSU,