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_TRX_HEADERS_PKG dependencies on JAI_AR_TRX_TAX_LINES

Line 472: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b

468: a.base_tax_amount,
469: a.func_tax_amount,
470: b.end_date valid_date,
471: b.tax_type
472: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b
473: WHERE a.link_to_cust_trx_line_id = p_parent_line_id
474: AND a.tax_id = b.tax_id
475: ORDER BY a.tax_line_no;
476:

Line 657: INSERT INTO JAI_AR_TRX_TAX_LINES

653: rec1.tax_amount := 0;
654: rec1.base_tax_amount := 0;
655: rec1.func_tax_amount := 0;
656: END IF;
657: INSERT INTO JAI_AR_TRX_TAX_LINES
658: (customer_trx_line_id,
659: link_to_cust_trx_line_id,
660: tax_line_no,
661: precedence_1,

Line 1124: DELETE JAI_AR_TRX_TAX_LINES

1120: v_price_list_val := '';
1121: v_converted_rate := '';
1122: v_line_tax_amount := 0;
1123:
1124: DELETE JAI_AR_TRX_TAX_LINES
1125: WHERE LINK_TO_CUST_TRX_LINE_ID = Rec.CUSTOMER_TRX_LINE_ID;
1126:
1127: IF v_customer_id IS NOT NULL AND v_address_id IS NOT NULL THEN
1128: jai_cmn_tax_defaultation_pkg.ja_in_cust_default_taxes(v_organization_id,

Line 1391: from JAI_AR_TRX_TAX_LINES

1387: WHERE Customer_Trx_Id = pr_new.customer_trx_id;
1388:
1389: cursor c_vat_taxes_exist is
1390: select 1
1391: from JAI_AR_TRX_TAX_LINES
1392: where link_to_cust_trx_line_id in
1393: (select customer_trx_line_id
1394: from JAI_AR_TRX_LINES
1395: where customer_trx_id = pr_new.customer_trx_id)

Line 1593: FROM JAI_AR_TRX_TAX_LINES jcttl,

1589: AND NVL(org_id, 0) = NVL(pr_new.org_id, 0);
1590:
1591: CURSOR cur_vat_taxes_exist IS
1592: SELECT regime_id, regime_code
1593: FROM JAI_AR_TRX_TAX_LINES jcttl,
1594: JAI_AR_TRX_LINES jctl,
1595: JAI_CMN_TAXES_ALL jtc,
1596: jai_regime_tax_types_v jrttv
1597: WHERE jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id

Line 1618: FROM JAI_AR_TRX_TAX_LINES jcttl,

1614: WHERE customer_trx_id = pr_new.previous_customer_trx_id;
1615:
1616: CURSOR c_chk_vat_reversal(cp_tax_type jai_cmn_taxes_all.tax_type%TYPE) IS
1617: SELECT 1
1618: FROM JAI_AR_TRX_TAX_LINES jcttl,
1619: JAI_AR_TRX_LINES jctl,
1620: JAI_CMN_TAXES_ALL jtc
1621: WHERE jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id
1622: AND jctl.customer_trx_id = pr_new.customer_trx_id

Line 1963: FROM JAI_AR_TRX_TAX_LINES A,

1959: A.func_tax_amount func_amt,
1960: b.tax_type t_type,
1961: b.stform_type,
1962: A.tax_line_no
1963: FROM JAI_AR_TRX_TAX_LINES A,
1964: JAI_CMN_TAXES_ALL B,
1965: JAI_INV_ITM_SETUPS C
1966: WHERE link_to_cust_trx_line_id = p_line_id
1967: AND b.tax_type IN (jai_constants.tax_type_excise,

Line 2043: FROM JAI_AR_TRX_TAX_LINES A, JAI_CMN_TAXES_ALL b

2039: AND (location_id = v_location_id OR
2040: (location_id is NULL and v_location_id is NULL));
2041: CURSOR for_modvat_tax_rate(p_cust_trx_line_id NUMBER) IS
2042: SELECT A.tax_rate
2043: FROM JAI_AR_TRX_TAX_LINES A, JAI_CMN_TAXES_ALL b
2044: WHERE A.tax_id = b.tax_id
2045: AND A.link_to_cust_trx_line_id = p_cust_trx_line_id
2046: AND b.tax_type = jai_constants.tax_type_modvat_recovery;
2047:

Line 2069: JAI_AR_TRX_TAX_LINES jrtl,

2065: CURSOR c_total_Excise_amt IS
2066: SELECT nvl(sum(jrtl.func_tax_amount), 0)
2067: FROM JAI_AR_TRXS jtrx,
2068: JAI_AR_TRX_LINES jtl,
2069: JAI_AR_TRX_TAX_LINES jrtl,
2070: JAI_CMN_TAXES_ALL jtc,
2071: JAI_INV_ITM_SETUPS jmtl
2072: WHERE jrtl.tax_id = jtc.tax_id
2073: AND jtrx.customer_trx_id = jtl.customer_Trx_id

Line 2094: FROM JAI_AR_TRX_TAX_LINES jrctl, JAI_CMN_TAXES_ALL jtc

2090: v_total_excise_amt NUMBER := 0;
2091:
2092: CURSOR c_cess_amount is
2093: SELECT NVL(SUM(jrctl.func_tax_amount), 0) tax_amount
2094: FROM JAI_AR_TRX_TAX_LINES jrctl, JAI_CMN_TAXES_ALL jtc
2095: WHERE jtc.tax_id = jrctl.tax_id
2096: AND link_to_cust_trx_line_id IN
2097: (SELECT customer_trx_line_id
2098: FROM JAI_AR_TRX_LINES

Line 2130: FROM JAI_AR_TRX_TAX_LINES jcttl,

2126: WHERE customer_trx_id = pr_new.customer_trx_id;
2127:
2128: CURSOR cur_vat_taxes_exist IS
2129: SELECT regime_id, regime_code
2130: FROM JAI_AR_TRX_TAX_LINES jcttl,
2131: JAI_AR_TRX_LINES jctl,
2132: JAI_CMN_TAXES_ALL jtc,
2133: jai_regime_tax_types_v jrttv
2134: WHERE jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id

Line 2143: FROM JAI_AR_TRX_TAX_LINES jcttl,

2139: AND jtc.org_id = pr_new.org_id;
2140:
2141: CURSOR c_chk_vat_reversal(cp_tax_type jai_cmn_taxes_all.tax_type%TYPE) IS
2142: SELECT 1
2143: FROM JAI_AR_TRX_TAX_LINES jcttl,
2144: JAI_AR_TRX_LINES jctl,
2145: JAI_CMN_TAXES_ALL jtc
2146: WHERE jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id
2147: AND jctl.customer_trx_id = pr_new.customer_trx_id