DBA Data[Home] [Help]

APPS.ZX_AR_POPULATE_PKG dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 1416: AR_RECEIVABLE_APPLICATIONS_ALL APP,

1412: SELECT SUM(NVL(ARDTAX.AMOUNT_CR,0) - NVL(ARDTAX.AMOUNT_DR,0)),
1413: SUM(NVL(ARDTAX.TAXABLE_ENTERED_CR,0) -
1414: NVL(ARDTAX.TAXABLE_ENTERED_DR,0))
1415: FROM AR_DISTRIBUTIONS_ALL ARDTAX,
1416: AR_RECEIVABLE_APPLICATIONS_ALL APP,
1417: RA_CUSTOMER_TRX_ALL TRXCM
1418: WHERE TRXCM.CUSTOMER_TRX_ID = C_TRX_ID
1419: AND APP.APPLIED_CUSTOMER_TRX_ID = TRXCM.CUSTOMER_TRX_ID
1420: AND APP.RECEIVABLE_APPLICATION_ID = ARDTAX.SOURCE_ID