DBA Data[Home] [Help]

APPS.ZX_CORE_REP_EXTRACT_PKG dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 811: FROM AR_RECEIVABLE_APPLICATIONS_ALL

807:
808: BEGIN
809: SELECT SUM(nvl(amount_applied,0)) ,sum(nvl(tax_applied,0))
810: INTO l_amount_recvd_tbl(p_trx_id_tbl(i)),l_tax_amount_rcvd_tbl(p_trx_id_tbl(i))
811: FROM AR_RECEIVABLE_APPLICATIONS_ALL
812: WHERE applied_customer_trx_id = p_trx_id_tbl(i)
813: AND org_id = p_org_id_tbl(i);
814: EXCEPTION
815: WHEN OTHERS THEN

Line 1462: ar_receivable_applications_all cash

1458: l_detail_tax_line_id_tbl,
1459: l_trx_id_tbl,
1460: l_org_id_tbl
1461: FROM zx_rep_trx_detail_t dtl ,
1462: ar_receivable_applications_all cash
1463: WHERE
1464: dtl.trx_id = cash.applied_customer_trx_id
1465: AND dtl.request_id = p_request_id ;
1466: