APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on JAI_AR_TRXS

Line 1548: ,jai_ar_trxs jrct

1544: ,jrct.organization_id organization_id
1545: ,jrct.location_id location_id
1546: from ra_customer_trx_all rct
1547: ,ra_customer_trx_lines_all rctl
1548: ,jai_ar_trxs jrct
1549: ,hz_parties hzp
1550: ,hz_cust_accounts hzca
1551: ,mtl_system_items msi
1552: where rct.customer_trx_id = p_document_id

Line 1695: FROM jai_ar_trxs

1691: FROM jai_ar_trx_lines
1692: WHERE customer_trx_id = cp_customer_trx_id
1693: AND customer_trx_line_id = cp_cust_trx_line_id)/
1694: (SELECT line_amount
1695: FROM jai_ar_trxs
1696: WHERE customer_trx_id = cp_customer_trx_id
1697: )))
1698: FROM AR_RECEIVABLE_APPLICATIONS_ALL araa,jai_rgm_trx_records jrtr
1699: WHERE araa.APPLIED_CUSTOMER_TRX_ID = cp_customer_trx_id

Line 3370: cursor c_get_loc_from_invoice (cp_customer_trx_id jai_ar_trxs.customer_trx_id%type)

3366: where pod.po_distribution_id = apd.po_distribution_id
3367: and apd.invoice_id = cp_invoice_id
3368: and apd.invoice_distribution_id = cp_distribution_id;
3369:
3370: cursor c_get_loc_from_invoice (cp_customer_trx_id jai_ar_trxs.customer_trx_id%type)
3371: is
3372: select location_id
3373: from jai_ar_trxs
3374: where customer_trx_id = cp_customer_trx_id ;

Line 3373: from jai_ar_trxs

3369:
3370: cursor c_get_loc_from_invoice (cp_customer_trx_id jai_ar_trxs.customer_trx_id%type)
3371: is
3372: select location_id
3373: from jai_ar_trxs
3374: where customer_trx_id = cp_customer_trx_id ;
3375:
3376: -- Begin 5876390, 6012570
3377: cursor c_get_jai_pa_details (cp_project_number pa_projects_all.segment1%type