DBA Data[Home] [Help]

APPS.ZX_AR_ACTG_POPULATE_PKG dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 664: AR_RECEIVABLE_APPLICATIONS_ALL APP,

660: SELECT SUM(NVL(ARDTAX.AMOUNT_CR,0) - NVL(ARDTAX.AMOUNT_DR,0)),
661: SUM(NVL(ARDTAX.TAXABLE_ENTERED_CR,0) -
662: NVL(ARDTAX.TAXABLE_ENTERED_DR,0))
663: FROM AR_DISTRIBUTIONS_ALL ARDTAX,
664: AR_RECEIVABLE_APPLICATIONS_ALL APP,
665: RA_CUSTOMER_TRX_ALL TRXCM
666: WHERE TRXCM.CUSTOMER_TRX_ID = C_TRX_ID
667: AND APP.APPLIED_CUSTOMER_TRX_ID = TRXCM.CUSTOMER_TRX_ID
668: AND APP.RECEIVABLE_APPLICATION_ID = ARDTAX.SOURCE_ID