APPS.ZX_ON_FLY_TRX_UPGRADE_AR_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 56: ra_customer_trx_all custtrx

52: SELECT xle_etb.establishment_id
53: INTO l_estb_id
54: FROM zx_party_tax_profile ptp,
55: xle_etb_profiles xle_etb,
56: ra_customer_trx_all custtrx
57: WHERE custtrx.customer_trx_id = p_upg_trx_info_rec.trx_id
58: AND ptp.party_id = xle_etb.party_id
59: AND ptp.party_type_code = 'LEGAL_ESTABLISHMENT'
60: AND xle_etb.legal_entity_id = custtrx.legal_entity_id

Line 1788: FROM RA_CUSTOMER_TRX_ALL custtrx,

1784: DECODE(vat.tax_type,
1785: 'LOCATION', NULL,
1786: custtrxl.vat_tax_id) ACCOUNT_SOURCE_TAX_RATE_ID,
1787: custtrxl.autotax AUTOTAX
1788: FROM RA_CUSTOMER_TRX_ALL custtrx,
1789: AR_SYSTEM_PARAMETERS_ALL arsysparam,
1790: RA_CUST_TRX_TYPES_ALL types,
1791: FND_CURRENCIES fndcurr,
1792: FND_DOCUMENT_SEQUENCES fds,

Line 1795: RA_CUSTOMER_TRX_ALL custtrx_prev,

1791: FND_CURRENCIES fndcurr,
1792: FND_DOCUMENT_SEQUENCES fds,
1793: ZX_PARTY_TAX_PROFILE ptp,
1794: RA_BATCH_SOURCES_ALL rbs,
1795: RA_CUSTOMER_TRX_ALL custtrx_prev,
1796: RA_CUSTOMER_TRX_LINES_ALL custtrxl_prev, -- 6705409
1797: RA_CUSTOMER_TRX_LINES_ALL custtrxl,
1798: AR_VAT_TAX_ALL_B vat,
1799: ZX_RATES_B rates ,

Line 3625: RA_CUSTOMER_TRX_ALL custtrx,

3621: 'Y', '111111111111111',
3622: '000000000000000') LEGAL_REPORTING_STATUS,
3623: custtrxl.autotax AUTOTAX
3624: FROM ( select distinct other_doc_application_id,other_doc_trx_id from ZX_VALIDATION_ERRORS_GT ) zxvalerr, --Bug 5187701
3625: RA_CUSTOMER_TRX_ALL custtrx,
3626: AR_SYSTEM_PARAMETERS_ALL arsysparam,
3627: RA_CUST_TRX_TYPES_ALL types,
3628: FND_CURRENCIES fndcurr,
3629: FND_DOCUMENT_SEQUENCES fds,

Line 3632: RA_CUSTOMER_TRX_ALL custtrx_prev,

3628: FND_CURRENCIES fndcurr,
3629: FND_DOCUMENT_SEQUENCES fds,
3630: ZX_PARTY_TAX_PROFILE ptp,
3631: RA_BATCH_SOURCES_ALL rbs,
3632: RA_CUSTOMER_TRX_ALL custtrx_prev,
3633: RA_CUSTOMER_TRX_LINES_ALL custtrxl_prev, -- 6705409
3634: RA_CUSTOMER_TRX_LINES_ALL custtrxl,
3635: AR_VAT_TAX_ALL_B vat,
3636: ZX_RATES_B rates ,