eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AR_RGM_PROCESSING_PKG dependencies on JAI_AR_TRXS

Line 349: FROM jai_ar_trxs

345: --------------------------------------------------------------
346: /*CURSOR c_get_org_loc
347: IS
348: SELECT organization_id, location_id
349: FROM jai_ar_trxs
350: WHERE customer_trx_id IN(SELECT customer_trx_id
351: FROM ra_customer_trx_lines
352: WHERE customer_trx_line_id IN pn_customer_trx_line_id);*/
353: --------------------------------------------------------------

Line 360: FROM jai_ar_trxs

356: --------------------------------------------------------------
357: CURSOR c_get_org_loc
358: IS
359: SELECT organization_id, location_id
360: FROM jai_ar_trxs
361: WHERE customer_trx_id IN(
362: SELECT customer_trx_id
363: FROM ra_customer_trx_lines
364: WHERE customer_trx_line_id IN

Line 805: JAI_AR_TRXS jtrx ,

801: jtrxtl.link_to_cust_trx_line_id,
802: nvl(jtc.reverse_charge_flag,'N') reverse_charge_flag --Added by Qiong for reverse charge bug#16001407
803: FROM
804: ra_customer_trx_all trx ,
805: JAI_AR_TRXS jtrx ,
806: ra_cust_trx_types_all trx_types ,
807: JAI_AR_TRX_LINES jtrxl ,
808: JAI_AR_TRX_TAX_LINES jtrxtl ,
809: ra_customer_trx_lines_all rctla , /*14121914*/

Line 1768: JAI_AR_TRXS inv_jtrx ,

1764: ar_receivable_applications_all aral ,
1765: ra_customer_trx_all cm_trx ,
1766: ra_customer_trx_all inv_trx ,
1767: ra_cust_trx_types_all trx_types ,
1768: JAI_AR_TRXS inv_jtrx ,
1769: JAI_AR_TRXS cm_jtrx
1770: WHERE
1771: aral.customer_trx_id = cm_trx.customer_trx_id AND
1772: cm_trx.customer_trx_id = cm_jtrx.customer_trx_id AND

Line 1769: JAI_AR_TRXS cm_jtrx

1765: ra_customer_trx_all cm_trx ,
1766: ra_customer_trx_all inv_trx ,
1767: ra_cust_trx_types_all trx_types ,
1768: JAI_AR_TRXS inv_jtrx ,
1769: JAI_AR_TRXS cm_jtrx
1770: WHERE
1771: aral.customer_trx_id = cm_trx.customer_trx_id AND
1772: cm_trx.customer_trx_id = cm_jtrx.customer_trx_id AND
1773: aral.applied_customer_trx_id = inv_trx.customer_trx_id AND

Line 1822: CURSOR cur_get_inv_tottax_amt (cp_inv_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE)

1818:
1819: /*
1820: || Get the Total transactional tax amount for the invoice
1821: */
1822: CURSOR cur_get_inv_tottax_amt (cp_inv_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE)
1823: IS
1824: SELECT
1825: nvl(sum(jrttl.tax_amount),0) inv_tot_tax_amount
1826: FROM

Line 1852: ( pn_cm_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE

1848: --added by walton for inclusive tax 29-Nov-07
1849: -----------------------------------------------------
1850: --Get the Total CM inclusive tax amount for the cm,
1851: CURSOR cur_get_cm_inclusive_tax_amt
1852: ( pn_cm_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE
1853: )
1854: IS
1855: SELECT
1856: nvl(sum(jrttl.tax_amount),0) inv_tot_inclusive_tax_amt

Line 1868: ( pn_cm_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE

1864: AND NVL(tax.inclusive_tax_flag,'N') = 'Y' ;
1865:
1866: --Get the Total CM line amount,
1867: CURSOR cur_get_cm_line_amt
1868: ( pn_cm_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE
1869: )
1870: IS
1871: SELECT
1872: nvl(sum(jrtl.line_amount),0) inv_tot_line_amt

Line 2632: JAI_AR_TRXS jtrx

2628: ar_receivable_applications_all aral ,
2629: ar_cash_receipts_all acrl ,
2630: ra_customer_trx_all trx ,
2631: ra_cust_trx_types_all trx_types ,
2632: JAI_AR_TRXS jtrx
2633: WHERE
2634: aral.cash_receipt_id = acrl.cash_receipt_id AND
2635: aral.applied_customer_trx_id = trx.customer_trx_id AND
2636: trunc(aral.creation_date) BETWEEN trunc(p_from_date) and trunc(p_to_date) AND

Line 2690: CURSOR cur_get_inv_tottax_amt (cp_inv_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE,

2686: /*
2687: || Get the Total transactional tax amount for the invoice
2688: */
2689: /*Bug 11932841 - Modified cursor to get only Exclusive Tax amounts, Added parameter cp_inv_cus_trx_line_id and cp_inv_tax_trx_line_id*/
2690: CURSOR cur_get_inv_tottax_amt (cp_inv_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE,
2691: cp_inv_cus_trx_line_id NUMBER,
2692: cp_inv_tax_trx_line_id NUMBER)
2693: IS
2694: SELECT

Line 2713: ( pn_inv_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE,

2709: ---------------------------------------------------------------
2710: --Get the Total inclusive tax amount for the invoice,
2711: /*Bug 11932841 - Added parameter pn_inv_cus_trx_line_id and pn_inv_tax_trx_line_id*/
2712: CURSOR cur_get_inv_inclusive_tax_amt
2713: ( pn_inv_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE,
2714: pn_inv_cus_trx_line_id NUMBER,
2715: pn_inv_tax_trx_line_id NUMBER
2716: )
2717: IS

Line 2734: ( pn_inv_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE,

2730:
2731: --Get the Total AR transaction line amount,
2732: /*Bug 11932841 - Added parameter pn_inv_cus_trx_line_id*/
2733: CURSOR cur_get_inv_line_amt
2734: ( pn_inv_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE,
2735: pn_inv_cus_trx_line_id NUMBER
2736: )
2737: IS
2738: SELECT

Line 3409: JAI_AR_TRXS jtrx

3405:
3406: FROM
3407: ra_customer_trx_all trx ,
3408: ra_cust_trx_types_all trx_types ,
3409: JAI_AR_TRXS jtrx
3410: WHERE
3411: trx_types.cust_trx_type_id = trx.cust_trx_type_id AND
3412: jtrx.organization_id = p_organization_id AND
3413: trx.org_id = nvl(p_org_id,trx.org_id) AND

Line 3450: , jai_ar_trxs jtrx

3446: FROM jai_ar_trx_tax_lines jattl
3447: , ra_customer_trx_lines_all trxl
3448: , ra_customer_trx_all trx
3449: , ra_cust_trx_types_all trx_types
3450: , jai_ar_trxs jtrx
3451: , ra_cust_trx_line_gl_dist_all gd --Added by Qiong for bug13540741
3452: WHERE jattl.link_to_cust_trx_line_id = trxl.customer_trx_line_id
3453: AND trxl.customer_trx_id = trx.customer_trx_id
3454: /*14121914 - Start*/

Line 3856: jai_ar_trxs trx,

3852: trx.organization_id,
3853: trx.location_id,
3854: line.service_type_code
3855: from jai_rgm_trx_refs refs,
3856: jai_ar_trxs trx,
3857: jai_ar_trx_tax_lines tax,
3858: jai_ar_trx_lines line
3859: where refs.reference_id = cp_reference_id--r_ar_ref_records.reference_id
3860: and refs.line_id = tax.customer_trx_line_id