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_OM_TAX_PKG dependencies on JAI_CONSTANTS

Line 207: DECODE(rgm_tax_types.regime_Code,jai_constants.vat_regime, 4, \* added by ssumaith - bug# 4245053*\

203: c.precedence_1 p_1, c.precedence_2 p_2, c.precedence_3 p_3,c.precedence_4 p_4, c.precedence_5 p_5,
204: c.precedence_6 p_6, c.precedence_7 p_7, c.precedence_8 p_8,c.precedence_9 p_9, c.precedence_10 p_10, -- Date 01/11/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
205: c.tax_amount, d.tax_type, d.end_date valid_date, d.rounding_factor,
206:
207: DECODE(rgm_tax_types.regime_Code,jai_constants.vat_regime, 4, \* added by ssumaith - bug# 4245053*\
208: decode(upper(d.tax_type),
209: 'EXCISE', 1,
210: 'ADDL. EXCISE', 1,
211: 'OTHER EXCISE', 1,

Line 262: , jai_constants.vat_regime ,4 /* added by ssumaith - bug# 4245053*/

258: , d.tax_type
259: , d.end_date valid_date
260: , nvl(d.rounding_factor,0) rounding_factor
261: , DECODE( rgm_tax_types.regime_Code
262: , jai_constants.vat_regime ,4 /* added by ssumaith - bug# 4245053*/
263: --, jai_constants.cgst_regime ,7 --Added by zhiwei for bug10043656 GST enhancement 2010/09/14 /*Commented by mmurtuza for removing GST Changes*/
264: --, jai_constants.sgst_regime ,7 --Added by zhiwei for bug10043656 GST enhancement 2010/09/14 /*Commented by mmurtuza for removing GST Changes*/
265: , decode( upper(d.tax_type)
266: , 'EXCISE' ,1

Line 263: --, jai_constants.cgst_regime ,7 --Added by zhiwei for bug10043656 GST enhancement 2010/09/14 /Commented by mmurtuza for removing GST Changes/

259: , d.end_date valid_date
260: , nvl(d.rounding_factor,0) rounding_factor
261: , DECODE( rgm_tax_types.regime_Code
262: , jai_constants.vat_regime ,4 /* added by ssumaith - bug# 4245053*/
263: --, jai_constants.cgst_regime ,7 --Added by zhiwei for bug10043656 GST enhancement 2010/09/14 /*Commented by mmurtuza for removing GST Changes*/
264: --, jai_constants.sgst_regime ,7 --Added by zhiwei for bug10043656 GST enhancement 2010/09/14 /*Commented by mmurtuza for removing GST Changes*/
265: , decode( upper(d.tax_type)
266: , 'EXCISE' ,1
267: , 'ADDL. EXCISE' ,1

Line 264: --, jai_constants.sgst_regime ,7 --Added by zhiwei for bug10043656 GST enhancement 2010/09/14 /Commented by mmurtuza for removing GST Changes/

260: , nvl(d.rounding_factor,0) rounding_factor
261: , DECODE( rgm_tax_types.regime_Code
262: , jai_constants.vat_regime ,4 /* added by ssumaith - bug# 4245053*/
263: --, jai_constants.cgst_regime ,7 --Added by zhiwei for bug10043656 GST enhancement 2010/09/14 /*Commented by mmurtuza for removing GST Changes*/
264: --, jai_constants.sgst_regime ,7 --Added by zhiwei for bug10043656 GST enhancement 2010/09/14 /*Commented by mmurtuza for removing GST Changes*/
265: , decode( upper(d.tax_type)
266: , 'EXCISE' ,1
267: , 'ADDL. EXCISE' ,1
268: , 'OTHER EXCISE' ,1

Line 269: , jai_constants.tax_type_cvd ,1

265: , decode( upper(d.tax_type)
266: , 'EXCISE' ,1
267: , 'ADDL. EXCISE' ,1
268: , 'OTHER EXCISE' ,1
269: , jai_constants.tax_type_cvd ,1
270: , jai_constants.tax_type_tds ,2
271: , jai_constants.tax_type_exc_edu_cess ,6
272: , jai_constants.tax_type_cvd_edu_cess ,6
273: , jai_constants.tax_type_sh_exc_edu_cess ,6

Line 270: , jai_constants.tax_type_tds ,2

266: , 'EXCISE' ,1
267: , 'ADDL. EXCISE' ,1
268: , 'OTHER EXCISE' ,1
269: , jai_constants.tax_type_cvd ,1
270: , jai_constants.tax_type_tds ,2
271: , jai_constants.tax_type_exc_edu_cess ,6
272: , jai_constants.tax_type_cvd_edu_cess ,6
273: , jai_constants.tax_type_sh_exc_edu_cess ,6
274: , jai_constants.tax_type_sh_cvd_edu_cess ,6

Line 271: , jai_constants.tax_type_exc_edu_cess ,6

267: , 'ADDL. EXCISE' ,1
268: , 'OTHER EXCISE' ,1
269: , jai_constants.tax_type_cvd ,1
270: , jai_constants.tax_type_tds ,2
271: , jai_constants.tax_type_exc_edu_cess ,6
272: , jai_constants.tax_type_cvd_edu_cess ,6
273: , jai_constants.tax_type_sh_exc_edu_cess ,6
274: , jai_constants.tax_type_sh_cvd_edu_cess ,6
275: , 'VAT REVERSAL' ,5/*Bug#6072461, bduvarag*/

Line 272: , jai_constants.tax_type_cvd_edu_cess ,6

268: , 'OTHER EXCISE' ,1
269: , jai_constants.tax_type_cvd ,1
270: , jai_constants.tax_type_tds ,2
271: , jai_constants.tax_type_exc_edu_cess ,6
272: , jai_constants.tax_type_cvd_edu_cess ,6
273: , jai_constants.tax_type_sh_exc_edu_cess ,6
274: , jai_constants.tax_type_sh_cvd_edu_cess ,6
275: , 'VAT REVERSAL' ,5/*Bug#6072461, bduvarag*/
276: , 0

Line 273: , jai_constants.tax_type_sh_exc_edu_cess ,6

269: , jai_constants.tax_type_cvd ,1
270: , jai_constants.tax_type_tds ,2
271: , jai_constants.tax_type_exc_edu_cess ,6
272: , jai_constants.tax_type_cvd_edu_cess ,6
273: , jai_constants.tax_type_sh_exc_edu_cess ,6
274: , jai_constants.tax_type_sh_cvd_edu_cess ,6
275: , 'VAT REVERSAL' ,5/*Bug#6072461, bduvarag*/
276: , 0
277: )

Line 274: , jai_constants.tax_type_sh_cvd_edu_cess ,6

270: , jai_constants.tax_type_tds ,2
271: , jai_constants.tax_type_exc_edu_cess ,6
272: , jai_constants.tax_type_cvd_edu_cess ,6
273: , jai_constants.tax_type_sh_exc_edu_cess ,6
274: , jai_constants.tax_type_sh_cvd_edu_cess ,6
275: , 'VAT REVERSAL' ,5/*Bug#6072461, bduvarag*/
276: , 0
277: )
278: ) tax_type_val

Line 308: DECODE(rgm_tax_types.regime_Code,jai_constants.vat_regime, 4, \* added by ssumaith - bug# 4245053*\

304: SELECT c.tax_line_no lno, c.tax_id, c.tax_rate, c.qty_rate, c.uom uom_code, c.func_tax_amount, c.base_tax_amount,
305: c.precedence_1 p_1, c.precedence_2 p_2, c.precedence_3 p_3,c.precedence_4 p_4, c.precedence_5 p_5,
306: c.precedence_6 p_6, c.precedence_7 p_7, c.precedence_8 p_8,c.precedence_9 p_9, c.precedence_10 p_10, -- Date 01/11/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
307: c.tax_amount, d.tax_type, d.end_date valid_date, d.rounding_factor,
308: DECODE(rgm_tax_types.regime_Code,jai_constants.vat_regime, 4, \* added by ssumaith - bug# 4245053*\
309: decode(upper(d.tax_type),'EXCISE', 1, 'ADDL. EXCISE', 1, 'OTHER EXCISE', 1, 'CVD',1, 'TDS', 2, 0
310: )
311: ) tax_type_val,
312: d.adhoc_flag

Line 348: , jai_constants.vat_regime, 4 /* added by ssumaith - bug# 4245053*/

344: , d.tax_type
345: , d.end_date valid_date
346: , nvl(d.rounding_factor,0) rounding_factor
347: , DECODE( rgm_tax_types.regime_Code
348: , jai_constants.vat_regime, 4 /* added by ssumaith - bug# 4245053*/
349: --, jai_constants.cgst_regime ,7 --Added by zhiwei for bug10043656 GST enhancement 2010/09/14 /*Commented by mmurtuza for removing GST Changes*/
350: --, jai_constants.sgst_regime ,7 --Added by zhiwei for bug10043656 GST enhancement 2010/09/14 /*Commented by mmurtuza for removing GST Changes*/
351: , decode( upper(d.tax_type)
352: , 'EXCISE' ,1

Line 349: --, jai_constants.cgst_regime ,7 --Added by zhiwei for bug10043656 GST enhancement 2010/09/14 /Commented by mmurtuza for removing GST Changes/

345: , d.end_date valid_date
346: , nvl(d.rounding_factor,0) rounding_factor
347: , DECODE( rgm_tax_types.regime_Code
348: , jai_constants.vat_regime, 4 /* added by ssumaith - bug# 4245053*/
349: --, jai_constants.cgst_regime ,7 --Added by zhiwei for bug10043656 GST enhancement 2010/09/14 /*Commented by mmurtuza for removing GST Changes*/
350: --, jai_constants.sgst_regime ,7 --Added by zhiwei for bug10043656 GST enhancement 2010/09/14 /*Commented by mmurtuza for removing GST Changes*/
351: , decode( upper(d.tax_type)
352: , 'EXCISE' ,1
353: , 'ADDL. EXCISE' ,1

Line 350: --, jai_constants.sgst_regime ,7 --Added by zhiwei for bug10043656 GST enhancement 2010/09/14 /Commented by mmurtuza for removing GST Changes/

346: , nvl(d.rounding_factor,0) rounding_factor
347: , DECODE( rgm_tax_types.regime_Code
348: , jai_constants.vat_regime, 4 /* added by ssumaith - bug# 4245053*/
349: --, jai_constants.cgst_regime ,7 --Added by zhiwei for bug10043656 GST enhancement 2010/09/14 /*Commented by mmurtuza for removing GST Changes*/
350: --, jai_constants.sgst_regime ,7 --Added by zhiwei for bug10043656 GST enhancement 2010/09/14 /*Commented by mmurtuza for removing GST Changes*/
351: , decode( upper(d.tax_type)
352: , 'EXCISE' ,1
353: , 'ADDL. EXCISE' ,1
354: , 'OTHER EXCISE' ,1

Line 355: , jai_constants.tax_type_cvd ,1

351: , decode( upper(d.tax_type)
352: , 'EXCISE' ,1
353: , 'ADDL. EXCISE' ,1
354: , 'OTHER EXCISE' ,1
355: , jai_constants.tax_type_cvd ,1
356: , jai_constants.tax_type_tds ,2
357: , jai_constants.tax_type_exc_edu_cess ,6
358: , jai_constants.tax_type_cvd_edu_cess ,6
359: , jai_constants.tax_type_sh_exc_edu_cess ,6

Line 356: , jai_constants.tax_type_tds ,2

352: , 'EXCISE' ,1
353: , 'ADDL. EXCISE' ,1
354: , 'OTHER EXCISE' ,1
355: , jai_constants.tax_type_cvd ,1
356: , jai_constants.tax_type_tds ,2
357: , jai_constants.tax_type_exc_edu_cess ,6
358: , jai_constants.tax_type_cvd_edu_cess ,6
359: , jai_constants.tax_type_sh_exc_edu_cess ,6
360: , jai_constants.tax_type_sh_cvd_edu_cess ,6

Line 357: , jai_constants.tax_type_exc_edu_cess ,6

353: , 'ADDL. EXCISE' ,1
354: , 'OTHER EXCISE' ,1
355: , jai_constants.tax_type_cvd ,1
356: , jai_constants.tax_type_tds ,2
357: , jai_constants.tax_type_exc_edu_cess ,6
358: , jai_constants.tax_type_cvd_edu_cess ,6
359: , jai_constants.tax_type_sh_exc_edu_cess ,6
360: , jai_constants.tax_type_sh_cvd_edu_cess ,6
361: , 'VAT REVERSAL' ,5/*Bug#6072461, bduvarag*/

Line 358: , jai_constants.tax_type_cvd_edu_cess ,6

354: , 'OTHER EXCISE' ,1
355: , jai_constants.tax_type_cvd ,1
356: , jai_constants.tax_type_tds ,2
357: , jai_constants.tax_type_exc_edu_cess ,6
358: , jai_constants.tax_type_cvd_edu_cess ,6
359: , jai_constants.tax_type_sh_exc_edu_cess ,6
360: , jai_constants.tax_type_sh_cvd_edu_cess ,6
361: , 'VAT REVERSAL' ,5/*Bug#6072461, bduvarag*/
362: , 0

Line 359: , jai_constants.tax_type_sh_exc_edu_cess ,6

355: , jai_constants.tax_type_cvd ,1
356: , jai_constants.tax_type_tds ,2
357: , jai_constants.tax_type_exc_edu_cess ,6
358: , jai_constants.tax_type_cvd_edu_cess ,6
359: , jai_constants.tax_type_sh_exc_edu_cess ,6
360: , jai_constants.tax_type_sh_cvd_edu_cess ,6
361: , 'VAT REVERSAL' ,5/*Bug#6072461, bduvarag*/
362: , 0
363: )

Line 360: , jai_constants.tax_type_sh_cvd_edu_cess ,6

356: , jai_constants.tax_type_tds ,2
357: , jai_constants.tax_type_exc_edu_cess ,6
358: , jai_constants.tax_type_cvd_edu_cess ,6
359: , jai_constants.tax_type_sh_exc_edu_cess ,6
360: , jai_constants.tax_type_sh_cvd_edu_cess ,6
361: , 'VAT REVERSAL' ,5/*Bug#6072461, bduvarag*/
362: , 0
363: )
364: ) tax_type_val

Line 2299: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,1,jai_constants.tax_type_exc_edu_Cess,1, \Bug 5989740 bduvarag\

2295: DECODE(aa.regime_code,'VAT',4, decode(upper(b.tax_type),
2296: 'EXCISE', 1,
2297: 'ADDL. EXCISE', 1,
2298: 'OTHER EXCISE', 1,
2299: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,1,jai_constants.tax_type_exc_edu_Cess,1, \*Bug 5989740 bduvarag*\
2300: 'TDS', 2, 0)) tax_type_val,
2301: b.tax_type,nvl(b.rounding_factor,0) rounding_factor
2302: FROM JAI_OM_OE_SO_TAXES a, JAI_CMN_TAXES_ALL b,jai_regime_tax_types_v aa
2303: WHERE a.header_id = p_header_id

Line 2334: , JAI_CONSTANTS.VAT_REGIME

2330: , b.uom_code
2331: , b.end_date valid_date
2332: , a.tax_amount tax_line_amt
2333: , DECODE( aa.regime_code
2334: , JAI_CONSTANTS.VAT_REGIME
2335: , 4
2336: --, JAI_CONSTANTS.cgst_regime --Added by zhiwei for bug10043656 GST enhancement 2010/09/14 /*Commented by mmurtuza for removing GST Changes*/
2337: --, 7
2338: --, JAI_CONSTANTS.sgst_regime --Added by zhiwei for bug10043656 GST enhancement 2010/09/14 /*Commented by mmurtuza for removing GST Changes*/

Line 2336: --, JAI_CONSTANTS.cgst_regime --Added by zhiwei for bug10043656 GST enhancement 2010/09/14 /Commented by mmurtuza for removing GST Changes/

2332: , a.tax_amount tax_line_amt
2333: , DECODE( aa.regime_code
2334: , JAI_CONSTANTS.VAT_REGIME
2335: , 4
2336: --, JAI_CONSTANTS.cgst_regime --Added by zhiwei for bug10043656 GST enhancement 2010/09/14 /*Commented by mmurtuza for removing GST Changes*/
2337: --, 7
2338: --, JAI_CONSTANTS.sgst_regime --Added by zhiwei for bug10043656 GST enhancement 2010/09/14 /*Commented by mmurtuza for removing GST Changes*/
2339: --, 7
2340: , decode( upper(b.tax_type)

Line 2338: --, JAI_CONSTANTS.sgst_regime --Added by zhiwei for bug10043656 GST enhancement 2010/09/14 /Commented by mmurtuza for removing GST Changes/

2334: , JAI_CONSTANTS.VAT_REGIME
2335: , 4
2336: --, JAI_CONSTANTS.cgst_regime --Added by zhiwei for bug10043656 GST enhancement 2010/09/14 /*Commented by mmurtuza for removing GST Changes*/
2337: --, 7
2338: --, JAI_CONSTANTS.sgst_regime --Added by zhiwei for bug10043656 GST enhancement 2010/09/14 /*Commented by mmurtuza for removing GST Changes*/
2339: --, 7
2340: , decode( upper(b.tax_type)
2341: , 'EXCISE' ,1
2342: , 'ADDL. EXCISE' ,1

Line 2344: , jai_constants.tax_type_tds ,2

2340: , decode( upper(b.tax_type)
2341: , 'EXCISE' ,1
2342: , 'ADDL. EXCISE' ,1
2343: , 'OTHER EXCISE' ,1
2344: , jai_constants.tax_type_tds ,2
2345: , jai_constants.tax_type_exc_edu_cess ,6
2346: , jai_constants.tax_type_cvd_edu_cess ,6
2347: , jai_constants.tax_type_sh_exc_edu_cess ,6
2348: , jai_constants.tax_type_sh_cvd_edu_cess ,6

Line 2345: , jai_constants.tax_type_exc_edu_cess ,6

2341: , 'EXCISE' ,1
2342: , 'ADDL. EXCISE' ,1
2343: , 'OTHER EXCISE' ,1
2344: , jai_constants.tax_type_tds ,2
2345: , jai_constants.tax_type_exc_edu_cess ,6
2346: , jai_constants.tax_type_cvd_edu_cess ,6
2347: , jai_constants.tax_type_sh_exc_edu_cess ,6
2348: , jai_constants.tax_type_sh_cvd_edu_cess ,6
2349: , 0

Line 2346: , jai_constants.tax_type_cvd_edu_cess ,6

2342: , 'ADDL. EXCISE' ,1
2343: , 'OTHER EXCISE' ,1
2344: , jai_constants.tax_type_tds ,2
2345: , jai_constants.tax_type_exc_edu_cess ,6
2346: , jai_constants.tax_type_cvd_edu_cess ,6
2347: , jai_constants.tax_type_sh_exc_edu_cess ,6
2348: , jai_constants.tax_type_sh_cvd_edu_cess ,6
2349: , 0
2350: )

Line 2347: , jai_constants.tax_type_sh_exc_edu_cess ,6

2343: , 'OTHER EXCISE' ,1
2344: , jai_constants.tax_type_tds ,2
2345: , jai_constants.tax_type_exc_edu_cess ,6
2346: , jai_constants.tax_type_cvd_edu_cess ,6
2347: , jai_constants.tax_type_sh_exc_edu_cess ,6
2348: , jai_constants.tax_type_sh_cvd_edu_cess ,6
2349: , 0
2350: )
2351: ) tax_type_val

Line 2348: , jai_constants.tax_type_sh_cvd_edu_cess ,6

2344: , jai_constants.tax_type_tds ,2
2345: , jai_constants.tax_type_exc_edu_cess ,6
2346: , jai_constants.tax_type_cvd_edu_cess ,6
2347: , jai_constants.tax_type_sh_exc_edu_cess ,6
2348: , jai_constants.tax_type_sh_cvd_edu_cess ,6
2349: , 0
2350: )
2351: ) tax_type_val
2352: , b.inclusive_tax_flag