DBA Data[Home] [Help]

APPS.ZX_ON_FLY_TRX_UPGRADE_AR_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 1710: FROM RA_CUSTOMER_TRX_ALL custtrx,

1706: DECODE(vat.tax_type,
1707: 'LOCATION', NULL,
1708: custtrxl.vat_tax_id) ACCOUNT_SOURCE_TAX_RATE_ID
1709:
1710: FROM RA_CUSTOMER_TRX_ALL custtrx,
1711: AR_SYSTEM_PARAMETERS_ALL arsysparam,
1712: RA_CUST_TRX_TYPES_ALL types,
1713: FND_CURRENCIES fndcurr,
1714: FND_DOCUMENT_SEQUENCES fds,

Line 1717: RA_CUSTOMER_TRX_ALL custtrx_prev,

1713: FND_CURRENCIES fndcurr,
1714: FND_DOCUMENT_SEQUENCES fds,
1715: ZX_PARTY_TAX_PROFILE ptp,
1716: RA_BATCH_SOURCES_ALL rbs,
1717: RA_CUSTOMER_TRX_ALL custtrx_prev,
1718: RA_CUSTOMER_TRX_LINES_ALL custtrxl,
1719: AR_VAT_TAX_ALL_B vat,
1720: ZX_RATES_B rates ,
1721: RA_CUSTOMER_TRX_LINES_ALL custtrxll, -- retrieve the trx line for tax lines

Line 3490: RA_CUSTOMER_TRX_ALL custtrx,

3486: 'Y', '111111111111111',
3487: '000000000000000') LEGAL_REPORTING_STATUS
3488:
3489: FROM ( select distinct other_doc_application_id,other_doc_trx_id from ZX_VALIDATION_ERRORS_GT ) zxvalerr, --Bug 5187701
3490: RA_CUSTOMER_TRX_ALL custtrx,
3491: AR_SYSTEM_PARAMETERS_ALL arsysparam,
3492: RA_CUST_TRX_TYPES_ALL types,
3493: FND_CURRENCIES fndcurr,
3494: FND_DOCUMENT_SEQUENCES fds,

Line 3497: RA_CUSTOMER_TRX_ALL custtrx_prev,

3493: FND_CURRENCIES fndcurr,
3494: FND_DOCUMENT_SEQUENCES fds,
3495: ZX_PARTY_TAX_PROFILE ptp,
3496: RA_BATCH_SOURCES_ALL rbs,
3497: RA_CUSTOMER_TRX_ALL custtrx_prev,
3498: RA_CUSTOMER_TRX_LINES_ALL custtrxl,
3499: AR_VAT_TAX_ALL_B vat,
3500: ZX_RATES_B rates ,
3501: RA_CUSTOMER_TRX_LINES_ALL custtrxll, -- retrieve the line for tax lines