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_CMN_TAX_DEFAULTATION_PKG dependencies on JAI_REGIME_TAX_TYPES_V

Line 508: jai_regime_tax_types_v rgm_tax_types /* added by ssumaith - bug# 4245053*/

504: ) tax_type_val,
505: b.mod_cr_percentage, b.vendor_id, b.tax_type,nvl(b.rounding_factor,0) rounding_factor
506: , inclusive_tax_flag --added by walton for inclusive tax 08-Dev-07
507: FROM JAI_CMN_TAX_CTG_LINES a, JAI_CMN_TAXES_ALL b ,
508: jai_regime_tax_types_v rgm_tax_types /* added by ssumaith - bug# 4245053*/
509: WHERE a.tax_category_id = p_tax_category_id
510: AND rgm_tax_types.tax_type (+) = b.tax_type /* added by ssumaith - bug# 4245053*/
511: AND a.tax_id = b.tax_id
512: -- AND (b.end_date >= sysdate OR b.end_date IS NULL)

Line 598: This change has been done by using the view jai_regime_tax_types_v - and outer joining it with the

594: has been given to capture the vat assessable value.
595:
596: This needs to be used for the calculation of the taxes registered under vat regime.
597:
598: This change has been done by using the view jai_regime_tax_types_v - and outer joining it with the
599: JAI_CMN_TAXES_ALL table based on the tax type column.
600:
601: Parameter - p_vat_assessable_value NUMBER DEFAULT 0 has been added
602:

Line 826: , jai_regime_tax_types_v rttv

822: , b.inclusive_tax_flag --added by walton for inclusive tax on 08-Dev-07
823: $$EXTRA_SELECT_COLUMN_LIST$$
824: from $$TAX_SOURCE_TABLE$$ a
825: , JAI_CMN_TAXES_ALL b
826: , jai_regime_tax_types_v rttv
827: where $$SOURCE_TABLE_FILTER$$
828: and rttv.tax_type (+) = b.tax_type
829: and a.tax_id = b.tax_id $$ADDITIONAL_WHERE_CLAUSE$$
830: order by a.tax_line_no $$ADDITIONAL_ORDER_BY$$';

Line 1742: , jai_regime_tax_types_v rttv

1738: , b.adhoc_flag
1739: $$EXTRA_SELECT_COLUMN_LIST$$
1740: from $$TAX_SOURCE_TABLE$$ a
1741: , JAI_CMN_TAXES_ALL b
1742: , jai_regime_tax_types_v rttv
1743: where $$SOURCE_TABLE_FILTER$$
1744: and rttv.tax_type (+) = b.tax_type
1745: and a.tax_id = b.tax_id $$ADDITIONAL_WHERE_CLAUSE$$
1746: order by a.tax_line_no $$ADDITIONAL_ORDER_BY$$';

Line 3452: , jai_regime_tax_types_v rgm_tax_types /* added by ssumaith - bug# 4245053*/

3448: , a.tax_category_id
3449: , b.inclusive_tax_flag --added by walton for inclusive tax on 08-Dev-07
3450: from JAI_CMN_TAX_CTG_LINES a
3451: , JAI_CMN_TAXES_ALL b
3452: , jai_regime_tax_types_v rgm_tax_types /* added by ssumaith - bug# 4245053*/
3453: where a.tax_category_id in (p_tax_category_id, nvl(p_threshold_tax_cat_id,-1))
3454: and rgm_tax_types.tax_type (+) = b.tax_type /* added by ssumaith - bug# 4245053*/
3455: and a.tax_id = b.tax_id
3456: order by decode (a.tax_category_id, p_tax_category_id, a.line_no

Line 3525: , jai_regime_tax_types_v rgm_tax_types /* added by ssumaith - bug# 4245053*/

3521: , a.tax_category_id
3522: , b.inclusive_tax_flag --Add by Kevin Cheng
3523: from JAI_CMN_TAX_CTG_LINES a
3524: , JAI_CMN_TAXES_ALL b
3525: , jai_regime_tax_types_v rgm_tax_types /* added by ssumaith - bug# 4245053*/
3526: where a.tax_category_id in (p_tax_category_id, nvl(p_threshold_tax_cat_id,-1))
3527: and rgm_tax_types.tax_type (+) = b.tax_type /* added by ssumaith - bug# 4245053*/
3528: and a.tax_id = b.tax_id
3529: order by decode (a.tax_category_id, p_tax_category_id, a.line_no