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_CMN_TAXES_ALL

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 1016: CP_RGM_TAX_TYPE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE,

1012: LN_THRESHOLD_SLAB_ID JAI_AP_TDS_THHOLD_SLABS.THRESHOLD_SLAB_ID%TYPE;
1013: LN_THRESHOLD_TAX_CAT_ID JAI_AP_TDS_THHOLD_TAXES.TAX_CATEGORY_ID%TYPE;
1014:
1015: CURSOR GC_CHK_RGM_TAX_EXISTS(CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE,
1016: CP_RGM_TAX_TYPE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE,
1017: CP_TAX_CATEGORY_ID JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_ID%TYPE) IS
1018: SELECT COUNT(1)
1019: FROM JAI_CMN_TAX_CTG_LINES CATL,
1020: JAI_CMN_TAXES_ALL CODES,

Line 1020: JAI_CMN_TAXES_ALL CODES,

1016: CP_RGM_TAX_TYPE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE,
1017: CP_TAX_CATEGORY_ID JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_ID%TYPE) IS
1018: SELECT COUNT(1)
1019: FROM JAI_CMN_TAX_CTG_LINES CATL,
1020: JAI_CMN_TAXES_ALL CODES,
1021: JAI_REGIME_TAX_TYPES_V JRTTV
1022: WHERE CATL.TAX_CATEGORY_ID = CP_TAX_CATEGORY_ID
1023: AND CATL.TAX_ID = CODES.TAX_ID
1024: AND CODES.TAX_TYPE = JRTTV.TAX_TYPE

Line 1397: from JAI_CMN_TAXES_ALL

1393: (select customer_trx_line_id
1394: from JAI_AR_TRX_LINES
1395: where customer_trx_id = pr_new.customer_trx_id)
1396: and tax_id in (select tax_id
1397: from JAI_CMN_TAXES_ALL
1398: where vat_flag = 'Y'
1399: and org_id = pr_new.org_id);
1400:
1401: CURSOR transaction_type_cur IS

Line 1595: JAI_CMN_TAXES_ALL jtc,

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
1598: AND jctl.customer_trx_id = pr_new.customer_trx_id
1599: AND jcttl.tax_id = jtc.tax_id

Line 1616: CURSOR c_chk_vat_reversal(cp_tax_type jai_cmn_taxes_all.tax_type%TYPE) IS

1612: SELECT vat_invoice_no
1613: FROM JAI_AR_TRXS
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

Line 1620: JAI_CMN_TAXES_ALL jtc

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
1623: AND jcttl.tax_id = jtc.tax_id
1624: AND jtc.org_id = pr_new.org_id

Line 1964: JAI_CMN_TAXES_ALL B,

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,
1968: jai_constants.tax_type_exc_additional,

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 2070: JAI_CMN_TAXES_ALL jtc,

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
2074: AND jrtl.link_to_cust_trx_line_id = jtl.customer_trx_line_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 2132: JAI_CMN_TAXES_ALL jtc,

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
2135: AND jctl.customer_trx_id = pr_new.customer_trx_id
2136: AND jcttl.tax_id = jtc.tax_id

Line 2141: CURSOR c_chk_vat_reversal(cp_tax_type jai_cmn_taxes_all.tax_type%TYPE) IS

2137: AND jtc.tax_type = jrttv.tax_type
2138: AND regime_code = jai_constants.vat_regime
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

Line 2145: JAI_CMN_TAXES_ALL jtc

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
2148: AND jcttl.tax_id = jtc.tax_id
2149: AND jtc.org_id = pr_new.org_id