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

Line 111: FROM JAI_AR_TRX_TAX_LINES A , JAI_CMN_TAXES_ALL B

107: v_once_completed_flag Varchar2(1);
108:
109: CURSOR excise_cal_cur IS
110: SELECT A.tax_id, A.tax_rate, A.tax_amount tax_amt,b.tax_type t_type
111: FROM JAI_AR_TRX_TAX_LINES A , JAI_CMN_TAXES_ALL B
112: WHERE link_to_cust_trx_line_id = v_customer_trx_line_id
113: and A.tax_id = B.tax_id
114: order by 1;
115:

Line 376: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b

372: a.precedence_9 p_9, a.precedence_10 p_10,
373: a.tax_rate, a.tax_amount, a.uom uom_code, a.qty_rate,
374: decode(upper(b.tax_type),'EXCISE', 1, 'ADDL. EXCISE', 1, 'OTHER EXCISE', 1, 'CVD',1, 'TDS', 2, 0) tax_type_val,
375: b.tax_type
376: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b
377: WHERE a.customer_trx_line_id = v_prev_customer_trx_line_id
378: AND a.tax_id = b.tax_id;
379:
380:

Line 935: JAI_CMN_TAXES_ALL c, wsh_new_deliveries D

931: A.precedence_1, A.precedence_2, A.precedence_3, A.precedence_4, A.precedence_5,
932: A.precedence_6, A.precedence_7, A.precedence_8, A.precedence_9, A.precedence_10,
933: b.vat_invoice_no,b.vat_invoice_date
934: FROM JAI_OM_WSH_LINE_TAXES A,JAI_OM_WSH_LINES_ALL b,
935: JAI_CMN_TAXES_ALL c, wsh_new_deliveries D
936: WHERE A.delivery_detail_id = b.delivery_detail_id
937: AND A.tax_id=c.tax_id
938: and c.tax_type <> 'Modvat Recovery'/*Bug 4881426 bduvarag*/
939: AND b.delivery_id = D.delivery_id

Line 978: JAI_CMN_TAXES_ALL t

974: FROM JAI_AR_SUP_TAXES A,
975: JAI_AR_SUP_LINES b,
976: ra_customer_trx_all C,
977: ra_cust_trx_types_all D,
978: JAI_CMN_TAXES_ALL t
979: WHERE A.link_to_cust_trx_line_id = b.customer_trx_line_id
980: AND A.sup_inv_type = b.sup_inv_type
981: AND b.customer_Trx_line_id = TO_NUMBER(pr_new.interface_line_attribute3)
982: AND pr_new.customer_trx_id = c.customer_trx_id

Line 1003: JAI_CMN_TAXES_ALL t

999: JAI_AR_SUP_LINES b,
1000: JAI_AR_SUP_HDRS_ALL c,
1001: ra_customer_trx_all D,
1002: ra_cust_trx_types_all e,
1003: JAI_CMN_TAXES_ALL t
1004: WHERE pr_new.customer_trx_id = D.customer_trx_id
1005: AND D.trx_number = TO_CHAR(c.SUPPLEMENTARY_NUM)
1006: AND c.customer_trx_id = b.customer_trx_id
1007: AND b.customer_trx_line_id = A.link_to_cust_trx_line_id

Line 1136: FROM JAI_OM_OE_SO_TAXES A, JAI_OM_OE_SO_LINES b, JAI_CMN_TAXES_ALL c

1132: A.func_tax_amount,
1133: A.precedence_1, A.precedence_2, A.precedence_3, A.precedence_4, A.precedence_5,
1134: A.precedence_6, A.precedence_7, A.precedence_8, A.precedence_9, A.precedence_10,
1135: c.tax_type
1136: FROM JAI_OM_OE_SO_TAXES A, JAI_OM_OE_SO_LINES b, JAI_CMN_TAXES_ALL c
1137: WHERE A.line_id = b.line_id
1138: AND b.line_id = TO_NUMBER(v_interface_line_attribute6)
1139: AND A.tax_id = c.tax_id
1140: and c.tax_type <> lc_modvat_tax/*Bug 4881426 bduvarag*/

Line 1474: FROM JAI_CMN_TAXES_ALL

1470: A.order_line_id = TO_NUMBER(v_ato_line_id);
1471:
1472: CURSOR c_get_tax_info(p_tax_id Number) is
1473: SELECT tax_type
1474: FROM JAI_CMN_TAXES_ALL
1475: WHERE tax_id = p_tax_id;
1476:
1477: v_tax_type JAI_CMN_TAXES_ALL.tax_type%type;
1478: v_tax_amount Number; --File.Sql.35 Cbabu :=0;

Line 1477: v_tax_type JAI_CMN_TAXES_ALL.tax_type%type;

1473: SELECT tax_type
1474: FROM JAI_CMN_TAXES_ALL
1475: WHERE tax_id = p_tax_id;
1476:
1477: v_tax_type JAI_CMN_TAXES_ALL.tax_type%type;
1478: v_tax_amount Number; --File.Sql.35 Cbabu :=0;
1479:
1480: ln_legal_entity_id NUMBER ; /* rallamse bug#4510143 */
1481: /* Added by JMEENA for bug#6391684 (FP 6061010 )*/

Line 2078: , JAI_CMN_TAXES_ALL jtc

2074: is
2075: select count(1)
2076: from jai_regime_tax_types_v jrttv
2077: , JAI_AR_TRX_TAX_LINES jrctt
2078: , JAI_CMN_TAXES_ALL jtc
2079: where jtc.tax_id = jrctt.tax_id
2080: and jtc.tax_type = jrttv.tax_type
2081: and regime_code = cp_regime_code
2082: and jrctt.link_to_cust_trx_line_id = cp_cust_trx_line_id;

Line 2471: , JAI_CMN_TAXES_ALL jtc

2467: /* Get line number of the base tax (tax_type=TCS) for calculating the surcharge basically to set a precedence */
2468: select max(tax_line_no)
2469: into ln_base_line_no
2470: from JAI_AR_TRX_TAX_LINES jrctt
2471: , JAI_CMN_TAXES_ALL jtc
2472: where jrctt.link_to_cust_trx_line_id = v_customer_trx_line_id
2473: and jrctt.tax_id = jtc.tax_id
2474: and jtc.tax_type = jai_constants.tax_type_tcs;
2475: /*

Line 4611: FROM JAI_OM_OE_RMA_TAXES A, JAI_CMN_TAXES_ALL b

4607: SELECT A.tax_line_no, A.uom, A.tax_id, A.tax_rate, A.qty_rate, A.base_tax_amount, A.tax_amount, b.tax_type,
4608: A.func_tax_amount,
4609: A.precedence_1, A.precedence_2, A.precedence_3, A.precedence_4, A.precedence_5 ,
4610: A.precedence_6, A.precedence_7, A.precedence_8, A.precedence_9, A.precedence_10
4611: FROM JAI_OM_OE_RMA_TAXES A, JAI_CMN_TAXES_ALL b
4612: WHERE A.rma_line_id = v_interface_line_attribute7
4613: AND A.tax_id = b.tax_id
4614: and b.tax_type <> lc_modvat_tax/*Bug 4881426 bduvarag*/
4615: ORDER BY tax_line_no;

Line 4758: FROM JAI_OM_OE_RMA_TAXES A, JAI_CMN_TAXES_ALL b

4754: SELECT A.tax_line_no, A.uom, A.tax_id, A.tax_rate, A.qty_rate, A.base_tax_amount, A.tax_amount, b.tax_type,
4755: A.func_tax_amount,
4756: A.precedence_1, A.precedence_2, A.precedence_3, A.precedence_4, A.precedence_5 ,
4757: A.precedence_6, A.precedence_7, A.precedence_8, A.precedence_9, A.precedence_10
4758: FROM JAI_OM_OE_RMA_TAXES A, JAI_CMN_TAXES_ALL b
4759: WHERE A.rma_line_id = TO_NUMBER(v_interface_line_attribute7)
4760: AND A.tax_id = b.tax_id
4761: and b.tax_type <> lc_modvat_tax
4762: ORDER BY tax_line_no;

Line 4809: , JAI_CMN_TAXES_ALL jtc

4805: is
4806: select count(1)
4807: from jai_regime_tax_types_v jrttv
4808: , JAI_AR_TRX_TAX_LINES jrctt
4809: , JAI_CMN_TAXES_ALL jtc
4810: where jtc.tax_id = jrctt.tax_id
4811: and jtc.tax_type = jrttv.tax_type
4812: and regime_code = cp_regime_code
4813: and jrctt.link_to_cust_trx_line_id = cp_cust_trx_line_id;

Line 5199: , JAI_CMN_TAXES_ALL jtc

5195: /* Get line number of the base tax (tax_type=TCS) for calculating the surcharge basically to set a precedence */
5196: select max(tax_line_no)
5197: into ln_base_line_no
5198: from JAI_AR_TRX_TAX_LINES jrctt
5199: , JAI_CMN_TAXES_ALL jtc
5200: where jrctt.link_to_cust_trx_line_id = v_customer_trx_line_id
5201: and jrctt.tax_id = jtc.tax_id
5202: and jtc.tax_type = jai_constants.tax_type_tcs;
5203: /*

Line 6282: , CP_RGM_TAX_TYPE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE

6278: SELECT REGIME_ID
6279: FROM JAI_RGM_DEFINITIONS
6280: WHERE REGIME_CODE = CP_REGIME_CODE;
6281: CURSOR GC_CHK_RGM_TAX_EXISTS ( CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE
6282: , CP_RGM_TAX_TYPE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE
6283: , CP_TAX_CATEGORY_ID JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_ID%TYPE
6284: )
6285: IS
6286: SELECT COUNT(1)

Line 6288: ,JAI_CMN_TAXES_ALL CODES

6284: )
6285: IS
6286: SELECT COUNT(1)
6287: FROM JAI_CMN_TAX_CTG_LINES CATL
6288: ,JAI_CMN_TAXES_ALL CODES
6289: ,JAI_REGIME_TAX_TYPES_V JRTTV
6290: WHERE CATL.TAX_CATEGORY_ID = CP_TAX_CATEGORY_ID
6291: AND CATL.TAX_ID = CODES.TAX_ID
6292: AND CODES.TAX_TYPE = JRTTV.TAX_TYPE

Line 6350: FROM JAI_AR_TRX_TAX_LINES A , JAI_CMN_TAXES_ALL B

6346: WHERE A.site_use_id = NVL(p_ship_to_site_use_id,0);
6347:
6348: CURSOR excise_cal_cur IS
6349: SELECT A.tax_id, A.tax_rate, A.tax_amount tax_amt,b.tax_type t_type
6350: FROM JAI_AR_TRX_TAX_LINES A , JAI_CMN_TAXES_ALL B
6351: WHERE link_to_cust_trx_line_id = v_customer_trx_line_id
6352: AND A.tax_id = B.tax_id
6353: ORDER BY 1;
6354:

Line 7061: JAI_CMN_TAXES_ALL B

7057:
7058: CURSOR excise_cal_cur IS
7059: select A.tax_id, A.tax_rate, A.tax_amount tax_amt,b.tax_type t_type
7060: from JAI_AR_TRX_TAX_LINES A ,
7061: JAI_CMN_TAXES_ALL B
7062: where link_to_cust_trx_line_id = pr_old.customer_trx_line_id
7063: and A.tax_id = B.tax_id
7064: order by 1;
7065:

Line 7396: from JAI_AR_TRX_TAX_LINES A , JAI_CMN_TAXES_ALL B

7392: -- WHERE A.site_use_id = NVL(p_ship_to_site_use_id,0);
7393:
7394: CURSOR excise_cal_cur IS
7395: select A.tax_id, A.tax_rate, A.tax_amount tax_amt,b.tax_type t_type
7396: from JAI_AR_TRX_TAX_LINES A , JAI_CMN_TAXES_ALL B
7397: where link_to_cust_trx_line_id = pr_old.customer_trx_line_id
7398: and A.tax_id = B.tax_id
7399: order by 1;
7400: