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_OPEN_API_PKG dependencies on JAI_CMN_TAXES_ALL

Line 1738: FROM JAI_CMN_TAXES_ALL

1734: CURSOR get_tax_inclu_flag_cur(cn_tax_id IN NUMBER) IS
1735: SELECT inclusive_tax_flag
1736: , start_date
1737: , end_date
1738: FROM JAI_CMN_TAXES_ALL
1739: WHERE TAX_ID = cn_tax_id
1740: AND ORG_ID = pr_interface_lines.ORG_ID;
1741:
1742: CURSOR get_use_flag IS

Line 1749: cn_tax_id IN JAI_CMN_TAXES_ALL.TAX_NAME%TYPE) IS

1745: WHERE org_id = pr_interface_lines.ORG_ID
1746: AND taxable_event = pr_interface_lines.taxable_event;
1747:
1748: CURSOR get_tax_id_rec(
1749: cn_tax_id IN JAI_CMN_TAXES_ALL.TAX_NAME%TYPE) IS
1750: SELECT tax_id, tax_name
1751: FROM JAI_CMN_TAXES_ALL
1752: WHERE tax_id = cn_tax_id;
1753:

Line 1751: FROM JAI_CMN_TAXES_ALL

1747:
1748: CURSOR get_tax_id_rec(
1749: cn_tax_id IN JAI_CMN_TAXES_ALL.TAX_NAME%TYPE) IS
1750: SELECT tax_id, tax_name
1751: FROM JAI_CMN_TAXES_ALL
1752: WHERE tax_id = cn_tax_id;
1753:
1754: --Variable define here
1755: rec_tax_id get_tax_id_from_mapping_cur%ROWTYPE;

Line 1757: lv_tax_name JAI_CMN_TAXES_ALL.tax_name%TYPE;

1753:
1754: --Variable define here
1755: rec_tax_id get_tax_id_from_mapping_cur%ROWTYPE;
1756: ln_tax_id NUMBER;
1757: lv_tax_name JAI_CMN_TAXES_ALL.tax_name%TYPE;
1758: rec_tax_detail get_tax_inclu_flag_cur%ROWTYPE;
1759:
1760: ln_cmn_inclusive_flag JAI_CMN_TAXES_ALL.INCLUSIVE_TAX_FLAG%TYPE;
1761: ld_start_date JAI_CMN_TAXES_ALL.START_DATE%TYPE;

Line 1760: ln_cmn_inclusive_flag JAI_CMN_TAXES_ALL.INCLUSIVE_TAX_FLAG%TYPE;

1756: ln_tax_id NUMBER;
1757: lv_tax_name JAI_CMN_TAXES_ALL.tax_name%TYPE;
1758: rec_tax_detail get_tax_inclu_flag_cur%ROWTYPE;
1759:
1760: ln_cmn_inclusive_flag JAI_CMN_TAXES_ALL.INCLUSIVE_TAX_FLAG%TYPE;
1761: ld_start_date JAI_CMN_TAXES_ALL.START_DATE%TYPE;
1762: ld_end_date JAI_CMN_TAXES_ALL.END_DATE%TYPE;
1763:
1764: lv_return_mess VARCHAR2(1000);

Line 1761: ld_start_date JAI_CMN_TAXES_ALL.START_DATE%TYPE;

1757: lv_tax_name JAI_CMN_TAXES_ALL.tax_name%TYPE;
1758: rec_tax_detail get_tax_inclu_flag_cur%ROWTYPE;
1759:
1760: ln_cmn_inclusive_flag JAI_CMN_TAXES_ALL.INCLUSIVE_TAX_FLAG%TYPE;
1761: ld_start_date JAI_CMN_TAXES_ALL.START_DATE%TYPE;
1762: ld_end_date JAI_CMN_TAXES_ALL.END_DATE%TYPE;
1763:
1764: lv_return_mess VARCHAR2(1000);
1765: lv_error_mess VARCHAR2(1000);

Line 1762: ld_end_date JAI_CMN_TAXES_ALL.END_DATE%TYPE;

1758: rec_tax_detail get_tax_inclu_flag_cur%ROWTYPE;
1759:
1760: ln_cmn_inclusive_flag JAI_CMN_TAXES_ALL.INCLUSIVE_TAX_FLAG%TYPE;
1761: ld_start_date JAI_CMN_TAXES_ALL.START_DATE%TYPE;
1762: ld_end_date JAI_CMN_TAXES_ALL.END_DATE%TYPE;
1763:
1764: lv_return_mess VARCHAR2(1000);
1765: lv_error_mess VARCHAR2(1000);
1766:

Line 2093: from JAI_CMN_TAXES_ALL

2089: CURSOR chk_ap_tax_type_cur
2090: IS
2091: SELECT
2092: COUNT(TAX_ID)
2093: from JAI_CMN_TAXES_ALL
2094: WHERE org_id = pr_interface_lines.ORG_ID
2095: --Commented by zhiwei for Bug#12561573 begin
2096: ----------------------------------------------------
2097: --and (end_date >= trunc(sysdate) or end_date is null)

Line 2120: from JAI_CMN_TAXES_ALL

2116: CURSOR chk_ar_tax_type_cur
2117: IS
2118: SELECT
2119: COUNT(TAX_ID)
2120: from JAI_CMN_TAXES_ALL
2121: WHERE org_id = pr_interface_lines.ORG_ID
2122: --Commented by zhiwei for Bug#12561573 begin
2123: ---------------------------------------------------------------
2124: --and (end_date >= trunc(sysdate) or end_date is null)

Line 2450: FROM JAI_CMN_TAXES_ALL

2446: CURSOR chk_qty_rate_cur
2447: IS
2448: SELECT
2449: COUNT(1)
2450: FROM JAI_CMN_TAXES_ALL
2451: WHERE TAX_ID = pn_tax_id
2452: AND ADHOC_FLAG = 'Y'
2453: AND VAT_FLAG = 'Q';
2454:

Line 2709: FROM jai_cmn_taxes_all jcta,

2705: CURSOR get_vat_tax_exists_cur(cn_trx_id IN NUMBER) IS
2706: SELECT 'Y'
2707: FROM dual
2708: WHERE EXISTS (SELECT 1
2709: FROM jai_cmn_taxes_all jcta,
2710: jai_interface_tax_lines_all jitla,
2711: jai_interface_lines_all jila
2712: WHERE jitla.tax_id = jcta.tax_id
2713: AND jila.interface_line_id = jitla.interface_line_id

Line 2727: FROM jai_cmn_taxes_all jcta,

2723: CURSOR get_excise_tax_exists_cur(cn_trx_id IN NUMBER) IS
2724: SELECT 'Y'
2725: FROM dual
2726: WHERE EXISTS (SELECT 1
2727: FROM jai_cmn_taxes_all jcta,
2728: jai_interface_tax_lines_all jitla,
2729: jai_interface_lines_all jila
2730: WHERE jitla.tax_id = jcta.tax_id
2731: AND jila.interface_line_id = jitla.interface_line_id

Line 2826: FROM jai_cmn_taxes_all jcta,

2822: CURSOR get_service_tax_exists_cur(cn_trx_id IN NUMBER) IS
2823: SELECT 'Y'
2824: FROM dual
2825: WHERE EXISTS (SELECT 1
2826: FROM jai_cmn_taxes_all jcta,
2827: jai_interface_tax_lines_all jitla,
2828: jai_interface_lines_all jila
2829: WHERE jitla.tax_id = jcta.tax_id
2830: AND jila.interface_line_id = jitla.interface_line_id

Line 3968: FROM jai_cmn_taxes_all

3964: IS
3965: --Cursor define here
3966: CURSOR c_get_tax_type_code(pn_tax_id IN NUMBER) IS
3967: SELECT tax_type
3968: FROM jai_cmn_taxes_all
3969: WHERE tax_id = pn_tax_id;
3970:
3971: --Variable define here
3972: ln_tax_type_code jai_cmn_taxes_all.tax_type%TYPE;

Line 3972: ln_tax_type_code jai_cmn_taxes_all.tax_type%TYPE;

3968: FROM jai_cmn_taxes_all
3969: WHERE tax_id = pn_tax_id;
3970:
3971: --Variable define here
3972: ln_tax_type_code jai_cmn_taxes_all.tax_type%TYPE;
3973: v_debug char(1);
3974:
3975: --Main block
3976: BEGIN

Line 4467: FROM JAI_CMN_TAXES_ALL tax,

4463: CURSOR chk_service_exist_cur
4464: IS
4465: SELECT
4466: count(tax.tax_id)
4467: FROM JAI_CMN_TAXES_ALL tax,
4468: JAI_INTERFACE_TAX_LINES_ALL intf
4469: WHERE intf.tax_id = tax.tax_id
4470: and intf.interface_line_id = pn_interface_line_id
4471: and (

Line 4505: FROM JAI_CMN_TAXES_ALL tax,

4501: CURSOR chk_tax_category_cur(cn_tax_category_id JAI_CMN_TAX_CTG_LINES.tax_category_id%type)
4502: IS
4503: SELECT
4504: count(tax.tax_id)
4505: FROM JAI_CMN_TAXES_ALL tax,
4506: JAI_CMN_TAX_CTG_LINES cate
4507: WHERE cate.tax_id = tax.tax_id
4508: and cate.tax_category_id = cn_tax_category_id
4509: and (

Line 5591: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b

5587: a.tax_amount tax_amt,
5588: b.tax_type t_type,
5589: a.customer_trx_line_id line_id,
5590: a.tax_line_no tax_line_no
5591: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b
5592: WHERE link_to_cust_trx_line_id = pn_customer_trx_line_id
5593: and a.tax_id = b.tax_id
5594: AND NVL(b.inclusive_tax_flag, 'N') = 'N' --Added by Jia Li for Tax inclusive Computations on 2007/11/22
5595: ORDER BY 1;

Line 5622: FROM JAI_CMN_TAXES_ALL B

5618: ln_tax_rate_id zx_rates_b.tax_rate_id%type;
5619:
5620: CURSOR TAX_CCID_CUR(p_tax_id IN NUMBER) IS
5621: SELECT tax_account_id
5622: FROM JAI_CMN_TAXES_ALL B
5623: WHERE B.tax_id = p_tax_id;
5624:
5625: CURSOR GL_DATE_CUR IS
5626: SELECT gl_date

Line 5657: CURSOR cur_chk_rgm(cp_tax_type JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS

5653: FROM JAI_OM_OE_BOND_REG_DTLS
5654: WHERE order_type_id = p_batch_source_id
5655: AND order_flag = 'N');
5656:
5657: CURSOR cur_chk_rgm(cp_tax_type JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS
5658: SELECT regime_id, regime_code
5659: FROM jai_regime_tax_types_v jrttv
5660: WHERE upper(jrttv.tax_type) = upper(cp_tax_type);
5661:

Line 6666: JAI_CMN_TAXES_ALL define

6662: is
6663: select 1
6664: from
6665: JAI_AR_TRX_TAX_LINES taxes ,
6666: JAI_CMN_TAXES_ALL define
6667: where taxes.tax_id = define.tax_id
6668: and taxes.customer_trx_line_id = pn_customer_trx_line_id
6669: and upper(define.tax_type) IN ( upper(jai_constants.tax_type_service),
6670: jai_constants.tax_type_service_edu_cess ,

Line 6916: from JAI_OM_OE_RMA_TAXES a, JAI_CMN_TAXES_ALL b

6912: FROM RA_CUSTOMER_TRX_ALL
6913: WHERE CUSTOMER_TRX_ID = pn_customer_trx_id)
6914: AND Rma_line_id in
6915: (Select RMA_LINE_ID
6916: from JAI_OM_OE_RMA_TAXES a, JAI_CMN_TAXES_ALL b
6917: Where a.tax_id = b.tax_id
6918: AND b.tax_type = jai_constants.tax_type_freight);
6919:
6920:

Line 6924: FROM JAI_AR_TRX_TAX_LINES A, JAI_CMN_TAXES_ALL B

6920:
6921: --added 12-Mar-2002
6922: CURSOR tax_type IS
6923: SELECT b.tax_type t_type, a.customer_trx_line_id line_id
6924: FROM JAI_AR_TRX_TAX_LINES A, JAI_CMN_TAXES_ALL B
6925: WHERE link_to_cust_trx_line_id = pn_customer_trx_line_id
6926: and A.tax_id = B.tax_id;
6927:
6928:

Line 8046: FROM jai_cmn_taxes_all jcta,

8042: CURSOR get_vat_tax_exists_cur IS
8043: SELECT 'Y'
8044: FROM dual
8045: WHERE EXISTS (SELECT 1
8046: FROM jai_cmn_taxes_all jcta,
8047: jai_interface_tax_lines_all jitla,
8048: jai_interface_lines_all jila
8049: WHERE jitla.tax_id = jcta.tax_id
8050: AND jila.interface_line_id = jitla.interface_line_id

Line 8074: FROM jai_cmn_taxes_all jcta,

8070: CURSOR get_excise_tax_exists_cur IS
8071: SELECT 'Y'
8072: FROM dual
8073: WHERE EXISTS (SELECT 1
8074: FROM jai_cmn_taxes_all jcta,
8075: jai_interface_tax_lines_all jitla,
8076: jai_interface_lines_all jila
8077: WHERE jitla.tax_id = jcta.tax_id
8078: AND jila.interface_line_id = jitla.interface_line_id

Line 8135: FROM jai_cmn_taxes_all jcta,

8131: CURSOR get_service_tax_exists_cur IS
8132: SELECT 'Y'
8133: FROM dual
8134: WHERE EXISTS (SELECT 1
8135: FROM jai_cmn_taxes_all jcta,
8136: jai_interface_tax_lines_all jitla,
8137: jai_interface_lines_all jila
8138: WHERE jitla.tax_id = jcta.tax_id
8139: AND jila.interface_line_id = jitla.interface_line_id

Line 8604: , p_thhold_cat_base_tax_typ JAI_CMN_TAXES_ALL.tax_type%TYPE DEFAULT NULL -- tax type to be considered as base when calculating threshold taxes

8600: p_last_update_login NUMBER,
8601: p_operation_flag NUMBER DEFAULT NULL , -- for CRM this is used to hold aso_shipments.shipment_id
8602: p_vat_assessable_value NUMBER DEFAULT 0
8603: /** bgowrava for forward porting bug#5631784,Following parameters are added for TCS enh.*/
8604: , p_thhold_cat_base_tax_typ JAI_CMN_TAXES_ALL.tax_type%TYPE DEFAULT NULL -- tax type to be considered as base when calculating threshold taxes
8605: , p_threshold_tax_cat_id JAI_AP_TDS_THHOLD_TAXES.tax_category_id%TYPE DEFAULT NULL
8606: , p_source_trx_type jai_cmn_document_taxes.source_doc_type%TYPE DEFAULT NULL
8607: , p_source_table_name jai_cmn_document_taxes.source_table_name%TYPE DEFAULT NULL
8608: , p_action VARCHAR2 DEFAULT NULL

Line 8824: , JAI_CMN_TAXES_ALL b

8820: ,b.inclusive_tax_flag --added by walton for inclusive tax on 08-Dev-07,--Added inclusive_tax_flag in end as it is last column in record type. by JMEENA for bug#9489492
8821: ,a.qty_rate --Added by zhiwei for Bug#12604133 on 20110623
8822: ,b.vat_flag --Added by zhiwei for Bug#12604133 on 20110623
8823: from $$TAX_SOURCE_TABLE$$ a
8824: , JAI_CMN_TAXES_ALL b
8825: , jai_regime_tax_types_v rttv
8826: where $$SOURCE_TABLE_FILTER$$
8827: and rttv.tax_type (+) = b.tax_type
8828: and a.tax_id = b.tax_id $$ADDITIONAL_WHERE_CLAUSE$$

Line 10703: , JAI_CMN_TAXES_ALL b

10699: $$QTY_RATE_FIELD$$
10700:
10701: $$EXTRA_SELECT_COLUMN_LIST$$
10702: FROM $$TAX_SOURCE_TABLE$$ a
10703: , JAI_CMN_TAXES_ALL b
10704: , jai_interface_lines_all c
10705: WHERE $$SOURCE_TABLE_FILTER$$
10706: AND a.tax_id = b.tax_id
10707: $$ADDITIONAL_WHERE_CLAUSE$$