DBA Data[Home] [Help]

APPS.ZX_AR_POPULATE_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 1691: RA_CUSTOMER_TRX_ALL TRXCM

1687: SUM(NVL(ARDTAX.TAXABLE_ENTERED_CR,0) -
1688: NVL(ARDTAX.TAXABLE_ENTERED_DR,0))
1689: FROM AR_DISTRIBUTIONS_ALL ARDTAX,
1690: AR_RECEIVABLE_APPLICATIONS_ALL APP,
1691: RA_CUSTOMER_TRX_ALL TRXCM
1692: WHERE APP.CASH_RECEIPT_ID = C_TRX_ID
1693: AND APP.APPLIED_CUSTOMER_TRX_ID = TRXCM.CUSTOMER_TRX_ID
1694: AND APP.RECEIVABLE_APPLICATION_ID = ARDTAX.SOURCE_ID
1695: AND ARDTAX.SOURCE_TABLE = 'RA'