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 173: DECODE(rgm_tax_types.regime_Code,jai_constants.vat_regime, 4, \* added by ssumaith - bug# 4245053*\

169: 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,
170: 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 )
171: c.tax_amount, d.tax_type, d.end_date valid_date, d.rounding_factor,
172:
173: DECODE(rgm_tax_types.regime_Code,jai_constants.vat_regime, 4, \* added by ssumaith - bug# 4245053*\
174: decode(upper(d.tax_type),
175: 'EXCISE', 1,
176: 'ADDL. EXCISE', 1,
177: 'OTHER EXCISE', 1,

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

224: , d.tax_type
225: , d.end_date valid_date
226: , nvl(d.rounding_factor,0) rounding_factor
227: , DECODE( rgm_tax_types.regime_Code
228: , jai_constants.vat_regime ,4 /* added by ssumaith - bug# 4245053*/
229: , decode( upper(d.tax_type)
230: , 'EXCISE' ,1
231: , 'ADDL. EXCISE' ,1
232: , 'OTHER EXCISE' ,1

Line 233: , jai_constants.tax_type_cvd ,1

229: , decode( upper(d.tax_type)
230: , 'EXCISE' ,1
231: , 'ADDL. EXCISE' ,1
232: , 'OTHER EXCISE' ,1
233: , jai_constants.tax_type_cvd ,1
234: , jai_constants.tax_type_tds ,2
235: , jai_constants.tax_type_exc_edu_cess ,6
236: , jai_constants.tax_type_cvd_edu_cess ,6
237: , jai_constants.tax_type_sh_exc_edu_cess ,6

Line 234: , jai_constants.tax_type_tds ,2

230: , 'EXCISE' ,1
231: , 'ADDL. EXCISE' ,1
232: , 'OTHER EXCISE' ,1
233: , jai_constants.tax_type_cvd ,1
234: , jai_constants.tax_type_tds ,2
235: , jai_constants.tax_type_exc_edu_cess ,6
236: , jai_constants.tax_type_cvd_edu_cess ,6
237: , jai_constants.tax_type_sh_exc_edu_cess ,6
238: , jai_constants.tax_type_sh_cvd_edu_cess ,6

Line 235: , jai_constants.tax_type_exc_edu_cess ,6

231: , 'ADDL. EXCISE' ,1
232: , 'OTHER EXCISE' ,1
233: , jai_constants.tax_type_cvd ,1
234: , jai_constants.tax_type_tds ,2
235: , jai_constants.tax_type_exc_edu_cess ,6
236: , jai_constants.tax_type_cvd_edu_cess ,6
237: , jai_constants.tax_type_sh_exc_edu_cess ,6
238: , jai_constants.tax_type_sh_cvd_edu_cess ,6
239: , 'VAT REVERSAL' ,5/*Bug#6072461, bduvarag*/

Line 236: , jai_constants.tax_type_cvd_edu_cess ,6

232: , 'OTHER EXCISE' ,1
233: , jai_constants.tax_type_cvd ,1
234: , jai_constants.tax_type_tds ,2
235: , jai_constants.tax_type_exc_edu_cess ,6
236: , jai_constants.tax_type_cvd_edu_cess ,6
237: , jai_constants.tax_type_sh_exc_edu_cess ,6
238: , jai_constants.tax_type_sh_cvd_edu_cess ,6
239: , 'VAT REVERSAL' ,5/*Bug#6072461, bduvarag*/
240: , 0

Line 237: , jai_constants.tax_type_sh_exc_edu_cess ,6

233: , jai_constants.tax_type_cvd ,1
234: , jai_constants.tax_type_tds ,2
235: , jai_constants.tax_type_exc_edu_cess ,6
236: , jai_constants.tax_type_cvd_edu_cess ,6
237: , jai_constants.tax_type_sh_exc_edu_cess ,6
238: , jai_constants.tax_type_sh_cvd_edu_cess ,6
239: , 'VAT REVERSAL' ,5/*Bug#6072461, bduvarag*/
240: , 0
241: )

Line 238: , jai_constants.tax_type_sh_cvd_edu_cess ,6

234: , jai_constants.tax_type_tds ,2
235: , jai_constants.tax_type_exc_edu_cess ,6
236: , jai_constants.tax_type_cvd_edu_cess ,6
237: , jai_constants.tax_type_sh_exc_edu_cess ,6
238: , jai_constants.tax_type_sh_cvd_edu_cess ,6
239: , 'VAT REVERSAL' ,5/*Bug#6072461, bduvarag*/
240: , 0
241: )
242: ) tax_type_val

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

268: 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,
269: 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,
270: 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 )
271: c.tax_amount, d.tax_type, d.end_date valid_date, d.rounding_factor,
272: DECODE(rgm_tax_types.regime_Code,jai_constants.vat_regime, 4, \* added by ssumaith - bug# 4245053*\
273: decode(upper(d.tax_type),'EXCISE', 1, 'ADDL. EXCISE', 1, 'OTHER EXCISE', 1, 'CVD',1, 'TDS', 2, 0
274: )
275: ) tax_type_val,
276: d.adhoc_flag

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

308: , d.tax_type
309: , d.end_date valid_date
310: , nvl(d.rounding_factor,0) rounding_factor
311: , DECODE( rgm_tax_types.regime_Code
312: , jai_constants.vat_regime, 4 /* added by ssumaith - bug# 4245053*/
313: , decode( upper(d.tax_type)
314: , 'EXCISE' ,1
315: , 'ADDL. EXCISE' ,1
316: , 'OTHER EXCISE' ,1

Line 317: , jai_constants.tax_type_cvd ,1

313: , decode( upper(d.tax_type)
314: , 'EXCISE' ,1
315: , 'ADDL. EXCISE' ,1
316: , 'OTHER EXCISE' ,1
317: , jai_constants.tax_type_cvd ,1
318: , jai_constants.tax_type_tds ,2
319: , jai_constants.tax_type_exc_edu_cess ,6
320: , jai_constants.tax_type_cvd_edu_cess ,6
321: , jai_constants.tax_type_sh_exc_edu_cess ,6

Line 318: , jai_constants.tax_type_tds ,2

314: , 'EXCISE' ,1
315: , 'ADDL. EXCISE' ,1
316: , 'OTHER EXCISE' ,1
317: , jai_constants.tax_type_cvd ,1
318: , jai_constants.tax_type_tds ,2
319: , jai_constants.tax_type_exc_edu_cess ,6
320: , jai_constants.tax_type_cvd_edu_cess ,6
321: , jai_constants.tax_type_sh_exc_edu_cess ,6
322: , jai_constants.tax_type_sh_cvd_edu_cess ,6

Line 319: , jai_constants.tax_type_exc_edu_cess ,6

315: , 'ADDL. EXCISE' ,1
316: , 'OTHER EXCISE' ,1
317: , jai_constants.tax_type_cvd ,1
318: , jai_constants.tax_type_tds ,2
319: , jai_constants.tax_type_exc_edu_cess ,6
320: , jai_constants.tax_type_cvd_edu_cess ,6
321: , jai_constants.tax_type_sh_exc_edu_cess ,6
322: , jai_constants.tax_type_sh_cvd_edu_cess ,6
323: , 'VAT REVERSAL' ,5/*Bug#6072461, bduvarag*/

Line 320: , jai_constants.tax_type_cvd_edu_cess ,6

316: , 'OTHER EXCISE' ,1
317: , jai_constants.tax_type_cvd ,1
318: , jai_constants.tax_type_tds ,2
319: , jai_constants.tax_type_exc_edu_cess ,6
320: , jai_constants.tax_type_cvd_edu_cess ,6
321: , jai_constants.tax_type_sh_exc_edu_cess ,6
322: , jai_constants.tax_type_sh_cvd_edu_cess ,6
323: , 'VAT REVERSAL' ,5/*Bug#6072461, bduvarag*/
324: , 0

Line 321: , jai_constants.tax_type_sh_exc_edu_cess ,6

317: , jai_constants.tax_type_cvd ,1
318: , jai_constants.tax_type_tds ,2
319: , jai_constants.tax_type_exc_edu_cess ,6
320: , jai_constants.tax_type_cvd_edu_cess ,6
321: , jai_constants.tax_type_sh_exc_edu_cess ,6
322: , jai_constants.tax_type_sh_cvd_edu_cess ,6
323: , 'VAT REVERSAL' ,5/*Bug#6072461, bduvarag*/
324: , 0
325: )

Line 322: , jai_constants.tax_type_sh_cvd_edu_cess ,6

318: , jai_constants.tax_type_tds ,2
319: , jai_constants.tax_type_exc_edu_cess ,6
320: , jai_constants.tax_type_cvd_edu_cess ,6
321: , jai_constants.tax_type_sh_exc_edu_cess ,6
322: , jai_constants.tax_type_sh_cvd_edu_cess ,6
323: , 'VAT REVERSAL' ,5/*Bug#6072461, bduvarag*/
324: , 0
325: )
326: ) tax_type_val

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

1592: DECODE(aa.regime_code,'VAT',4, decode(upper(b.tax_type),
1593: 'EXCISE', 1,
1594: 'ADDL. EXCISE', 1,
1595: 'OTHER EXCISE', 1,
1596: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,1,jai_constants.tax_type_exc_edu_Cess,1, \*Bug 5989740 bduvarag*\
1597: 'TDS', 2, 0)) tax_type_val,
1598: b.tax_type,nvl(b.rounding_factor,0) rounding_factor
1599: FROM JAI_OM_OE_SO_TAXES a, JAI_CMN_TAXES_ALL b,jai_regime_tax_types_v aa
1600: WHERE a.header_id = p_header_id

Line 1631: , JAI_CONSTANTS.VAT_REGIME

1627: , b.uom_code
1628: , b.end_date valid_date
1629: , a.tax_amount tax_line_amt
1630: , DECODE( aa.regime_code
1631: , JAI_CONSTANTS.VAT_REGIME
1632: , 4
1633: , decode( upper(b.tax_type)
1634: , 'EXCISE' ,1
1635: , 'ADDL. EXCISE' ,1

Line 1637: , jai_constants.tax_type_tds ,2

1633: , decode( upper(b.tax_type)
1634: , 'EXCISE' ,1
1635: , 'ADDL. EXCISE' ,1
1636: , 'OTHER EXCISE' ,1
1637: , jai_constants.tax_type_tds ,2
1638: , jai_constants.tax_type_exc_edu_cess ,6
1639: , jai_constants.tax_type_cvd_edu_cess ,6
1640: , jai_constants.tax_type_sh_exc_edu_cess ,6
1641: , jai_constants.tax_type_sh_cvd_edu_cess ,6

Line 1638: , jai_constants.tax_type_exc_edu_cess ,6

1634: , 'EXCISE' ,1
1635: , 'ADDL. EXCISE' ,1
1636: , 'OTHER EXCISE' ,1
1637: , jai_constants.tax_type_tds ,2
1638: , jai_constants.tax_type_exc_edu_cess ,6
1639: , jai_constants.tax_type_cvd_edu_cess ,6
1640: , jai_constants.tax_type_sh_exc_edu_cess ,6
1641: , jai_constants.tax_type_sh_cvd_edu_cess ,6
1642: , 0

Line 1639: , jai_constants.tax_type_cvd_edu_cess ,6

1635: , 'ADDL. EXCISE' ,1
1636: , 'OTHER EXCISE' ,1
1637: , jai_constants.tax_type_tds ,2
1638: , jai_constants.tax_type_exc_edu_cess ,6
1639: , jai_constants.tax_type_cvd_edu_cess ,6
1640: , jai_constants.tax_type_sh_exc_edu_cess ,6
1641: , jai_constants.tax_type_sh_cvd_edu_cess ,6
1642: , 0
1643: )

Line 1640: , jai_constants.tax_type_sh_exc_edu_cess ,6

1636: , 'OTHER EXCISE' ,1
1637: , jai_constants.tax_type_tds ,2
1638: , jai_constants.tax_type_exc_edu_cess ,6
1639: , jai_constants.tax_type_cvd_edu_cess ,6
1640: , jai_constants.tax_type_sh_exc_edu_cess ,6
1641: , jai_constants.tax_type_sh_cvd_edu_cess ,6
1642: , 0
1643: )
1644: ) tax_type_val

Line 1641: , jai_constants.tax_type_sh_cvd_edu_cess ,6

1637: , jai_constants.tax_type_tds ,2
1638: , jai_constants.tax_type_exc_edu_cess ,6
1639: , jai_constants.tax_type_cvd_edu_cess ,6
1640: , jai_constants.tax_type_sh_exc_edu_cess ,6
1641: , jai_constants.tax_type_sh_cvd_edu_cess ,6
1642: , 0
1643: )
1644: ) tax_type_val
1645: , b.inclusive_tax_flag