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 92: FROM JAI_AR_TRX_TAX_LINES A , JAI_CMN_TAXES_ALL B

88: v_once_completed_flag Varchar2(1);
89:
90: CURSOR excise_cal_cur IS
91: SELECT A.tax_id, A.tax_rate, A.tax_amount tax_amt,b.tax_type t_type
92: FROM JAI_AR_TRX_TAX_LINES A , JAI_CMN_TAXES_ALL B
93: WHERE link_to_cust_trx_line_id = v_customer_trx_line_id
94: and A.tax_id = B.tax_id
95: order by 1;
96:

Line 350: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b

346: a.precedence_9 p_9, a.precedence_10 p_10,
347: a.tax_rate, a.tax_amount, a.uom uom_code, a.qty_rate,
348: decode(upper(b.tax_type),'EXCISE', 1, 'ADDL. EXCISE', 1, 'OTHER EXCISE', 1, 'CVD',1, 'TDS', 2, 0) tax_type_val,
349: b.tax_type
350: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b
351: WHERE a.customer_trx_line_id = v_prev_customer_trx_line_id
352: AND a.tax_id = b.tax_id;
353:
354:

Line 867: JAI_CMN_TAXES_ALL c, wsh_new_deliveries D

863: A.precedence_1, A.precedence_2, A.precedence_3, A.precedence_4, A.precedence_5,
864: A.precedence_6, A.precedence_7, A.precedence_8, A.precedence_9, A.precedence_10,
865: b.vat_invoice_no,b.vat_invoice_date
866: FROM JAI_OM_WSH_LINE_TAXES A,JAI_OM_WSH_LINES_ALL b,
867: JAI_CMN_TAXES_ALL c, wsh_new_deliveries D
868: WHERE A.delivery_detail_id = b.delivery_detail_id
869: AND A.tax_id=c.tax_id
870: and c.tax_type <> 'Modvat Recovery'/*Bug 4881426 bduvarag*/
871: AND b.delivery_id = D.delivery_id

Line 910: JAI_CMN_TAXES_ALL t

906: FROM JAI_AR_SUP_TAXES A,
907: JAI_AR_SUP_LINES b,
908: ra_customer_trx_all C,
909: ra_cust_trx_types_all D,
910: JAI_CMN_TAXES_ALL t
911: WHERE A.link_to_cust_trx_line_id = b.customer_trx_line_id
912: AND A.sup_inv_type = b.sup_inv_type
913: AND b.customer_Trx_line_id = TO_NUMBER(pr_new.interface_line_attribute3)
914: AND pr_new.customer_trx_id = c.customer_trx_id

Line 935: JAI_CMN_TAXES_ALL t

931: JAI_AR_SUP_LINES b,
932: JAI_AR_SUP_HDRS_ALL c,
933: ra_customer_trx_all D,
934: ra_cust_trx_types_all e,
935: JAI_CMN_TAXES_ALL t
936: WHERE pr_new.customer_trx_id = D.customer_trx_id
937: AND D.trx_number = TO_CHAR(c.SUPPLEMENTARY_NUM)
938: AND c.customer_trx_id = b.customer_trx_id
939: AND b.customer_trx_line_id = A.link_to_cust_trx_line_id

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

1063: A.func_tax_amount,
1064: A.precedence_1, A.precedence_2, A.precedence_3, A.precedence_4, A.precedence_5,
1065: A.precedence_6, A.precedence_7, A.precedence_8, A.precedence_9, A.precedence_10,
1066: c.tax_type
1067: FROM JAI_OM_OE_SO_TAXES A, JAI_OM_OE_SO_LINES b, JAI_CMN_TAXES_ALL c
1068: WHERE A.line_id = b.line_id
1069: AND b.line_id = TO_NUMBER(v_interface_line_attribute6)
1070: AND A.tax_id = c.tax_id
1071: and c.tax_type <> lc_modvat_tax/*Bug 4881426 bduvarag*/

Line 1389: FROM JAI_CMN_TAXES_ALL

1385: A.order_line_id = TO_NUMBER(v_ato_line_id);
1386:
1387: CURSOR c_get_tax_info(p_tax_id Number) is
1388: SELECT tax_type
1389: FROM JAI_CMN_TAXES_ALL
1390: WHERE tax_id = p_tax_id;
1391:
1392: v_tax_type JAI_CMN_TAXES_ALL.tax_type%type;
1393: v_tax_amount Number; --File.Sql.35 Cbabu :=0;

Line 1392: v_tax_type JAI_CMN_TAXES_ALL.tax_type%type;

1388: SELECT tax_type
1389: FROM JAI_CMN_TAXES_ALL
1390: WHERE tax_id = p_tax_id;
1391:
1392: v_tax_type JAI_CMN_TAXES_ALL.tax_type%type;
1393: v_tax_amount Number; --File.Sql.35 Cbabu :=0;
1394:
1395: ln_legal_entity_id NUMBER ; /* rallamse bug#4510143 */
1396:

Line 1868: , JAI_CMN_TAXES_ALL jtc

1864: is
1865: select count(1)
1866: from jai_regime_tax_types_v jrttv
1867: , JAI_AR_TRX_TAX_LINES jrctt
1868: , JAI_CMN_TAXES_ALL jtc
1869: where jtc.tax_id = jrctt.tax_id
1870: and jtc.tax_type = jrttv.tax_type
1871: and regime_code = cp_regime_code
1872: and jrctt.link_to_cust_trx_line_id = cp_cust_trx_line_id;

Line 2261: , JAI_CMN_TAXES_ALL jtc

2257: /* Get line number of the base tax (tax_type=TCS) for calculating the surcharge basically to set a precedence */
2258: select max(tax_line_no)
2259: into ln_base_line_no
2260: from JAI_AR_TRX_TAX_LINES jrctt
2261: , JAI_CMN_TAXES_ALL jtc
2262: where jrctt.link_to_cust_trx_line_id = v_customer_trx_line_id
2263: and jrctt.tax_id = jtc.tax_id
2264: and jtc.tax_type = jai_constants.tax_type_tcs;
2265: /*

Line 4280: FROM JAI_OM_OE_RMA_TAXES A, JAI_CMN_TAXES_ALL b

4276: 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,
4277: A.func_tax_amount,
4278: A.precedence_1, A.precedence_2, A.precedence_3, A.precedence_4, A.precedence_5 ,
4279: A.precedence_6, A.precedence_7, A.precedence_8, A.precedence_9, A.precedence_10
4280: FROM JAI_OM_OE_RMA_TAXES A, JAI_CMN_TAXES_ALL b
4281: WHERE A.rma_line_id = v_interface_line_attribute7
4282: AND A.tax_id = b.tax_id
4283: and b.tax_type <> lc_modvat_tax/*Bug 4881426 bduvarag*/
4284: ORDER BY tax_line_no;

Line 4910: , CP_RGM_TAX_TYPE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE

4906: SELECT REGIME_ID
4907: FROM JAI_RGM_DEFINITIONS
4908: WHERE REGIME_CODE = CP_REGIME_CODE;
4909: CURSOR GC_CHK_RGM_TAX_EXISTS ( CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE
4910: , CP_RGM_TAX_TYPE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE
4911: , CP_TAX_CATEGORY_ID JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_ID%TYPE
4912: )
4913: IS
4914: SELECT COUNT(1)

Line 4916: ,JAI_CMN_TAXES_ALL CODES

4912: )
4913: IS
4914: SELECT COUNT(1)
4915: FROM JAI_CMN_TAX_CTG_LINES CATL
4916: ,JAI_CMN_TAXES_ALL CODES
4917: ,JAI_REGIME_TAX_TYPES_V JRTTV
4918: WHERE CATL.TAX_CATEGORY_ID = CP_TAX_CATEGORY_ID
4919: AND CATL.TAX_ID = CODES.TAX_ID
4920: AND CODES.TAX_TYPE = JRTTV.TAX_TYPE

Line 4970: FROM JAI_AR_TRX_TAX_LINES A , JAI_CMN_TAXES_ALL B

4966: WHERE A.site_use_id = NVL(p_ship_to_site_use_id,0);
4967:
4968: CURSOR excise_cal_cur IS
4969: SELECT A.tax_id, A.tax_rate, A.tax_amount tax_amt,b.tax_type t_type
4970: FROM JAI_AR_TRX_TAX_LINES A , JAI_CMN_TAXES_ALL B
4971: WHERE link_to_cust_trx_line_id = v_customer_trx_line_id
4972: AND A.tax_id = B.tax_id
4973: ORDER BY 1;
4974:

Line 5605: JAI_CMN_TAXES_ALL B

5601:
5602: CURSOR excise_cal_cur IS
5603: select A.tax_id, A.tax_rate, A.tax_amount tax_amt,b.tax_type t_type
5604: from JAI_AR_TRX_TAX_LINES A ,
5605: JAI_CMN_TAXES_ALL B
5606: where link_to_cust_trx_line_id = pr_old.customer_trx_line_id
5607: and A.tax_id = B.tax_id
5608: order by 1;
5609:

Line 5938: from JAI_AR_TRX_TAX_LINES A , JAI_CMN_TAXES_ALL B

5934: -- WHERE A.site_use_id = NVL(p_ship_to_site_use_id,0);
5935:
5936: CURSOR excise_cal_cur IS
5937: select A.tax_id, A.tax_rate, A.tax_amount tax_amt,b.tax_type t_type
5938: from JAI_AR_TRX_TAX_LINES A , JAI_CMN_TAXES_ALL B
5939: where link_to_cust_trx_line_id = pr_old.customer_trx_line_id
5940: and A.tax_id = B.tax_id
5941: order by 1;
5942: