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 560: jai_regime_tax_types_v rgm_tax_types /* added by ssumaith - bug# 4245053*/

556: ) tax_type_val,
557: b.mod_cr_percentage, b.vendor_id, b.tax_type,nvl(b.rounding_factor,0) rounding_factor
558: , inclusive_tax_flag --added by walton for inclusive tax 08-Dev-07
559: FROM JAI_CMN_TAX_CTG_LINES a, JAI_CMN_TAXES_ALL b ,
560: jai_regime_tax_types_v rgm_tax_types /* added by ssumaith - bug# 4245053*/
561: WHERE a.tax_category_id = p_tax_category_id
562: AND rgm_tax_types.tax_type (+) = b.tax_type /* added by ssumaith - bug# 4245053*/
563: AND a.tax_id = b.tax_id
564: -- AND (b.end_date >= sysdate OR b.end_date IS NULL)

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

649: has been given to capture the vat assessable value.
650:
651: This needs to be used for the calculation of the taxes registered under vat regime.
652:
653: This change has been done by using the view jai_regime_tax_types_v - and outer joining it with the
654: JAI_CMN_TAXES_ALL table based on the tax type column.
655:
656: Parameter - p_vat_assessable_value NUMBER DEFAULT 0 has been added
657:

Line 1016: , jai_regime_tax_types_v rttv

1012: $$EXTRA_SELECT_COLUMN_LIST$$
1013: ,b.inclusive_tax_flag --added by walton for inclusive tax on 08-Dev-07,--Added inclusive_tax_flag in end as it is last column in record type. by JMEENA for bug#9489492
1014: from $$TAX_SOURCE_TABLE$$ a
1015: , JAI_CMN_TAXES_ALL b
1016: , jai_regime_tax_types_v rttv
1017: where $$SOURCE_TABLE_FILTER$$
1018: and rttv.tax_type (+) = b.tax_type
1019: and a.tax_id = b.tax_id $$ADDITIONAL_WHERE_CLAUSE$$
1020: order by a.tax_line_no $$ADDITIONAL_ORDER_BY$$';

Line 2755: , jai_regime_tax_types_v rttv

2751: , b.adhoc_flag
2752: $$EXTRA_SELECT_COLUMN_LIST$$
2753: from $$TAX_SOURCE_TABLE$$ a
2754: , JAI_CMN_TAXES_ALL b
2755: , jai_regime_tax_types_v rttv
2756: where $$SOURCE_TABLE_FILTER$$
2757: and rttv.tax_type (+) = b.tax_type
2758: and a.tax_id = b.tax_id $$ADDITIONAL_WHERE_CLAUSE$$
2759: order by a.tax_line_no $$ADDITIONAL_ORDER_BY$$';

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

4685: , a.tax_category_id
4686: , b.inclusive_tax_flag --added by walton for inclusive tax on 08-Dev-07
4687: from JAI_CMN_TAX_CTG_LINES a
4688: , JAI_CMN_TAXES_ALL b
4689: , jai_regime_tax_types_v rgm_tax_types /* added by ssumaith - bug# 4245053*/
4690: where a.tax_category_id in (p_tax_category_id, nvl(p_threshold_tax_cat_id,-1))
4691: and rgm_tax_types.tax_type (+) = b.tax_type /* added by ssumaith - bug# 4245053*/
4692: and a.tax_id = b.tax_id
4693: order by decode (a.tax_category_id, p_tax_category_id, a.line_no

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

4761: , a.tax_category_id
4762: , b.inclusive_tax_flag --Add by Kevin Cheng
4763: from JAI_CMN_TAX_CTG_LINES a
4764: , JAI_CMN_TAXES_ALL b
4765: , jai_regime_tax_types_v rgm_tax_types /* added by ssumaith - bug# 4245053*/
4766: where a.tax_category_id in (p_tax_category_id, nvl(p_threshold_tax_cat_id,-1))
4767: and rgm_tax_types.tax_type (+) = b.tax_type /* added by ssumaith - bug# 4245053*/
4768: and a.tax_id = b.tax_id
4769: order by decode (a.tax_category_id, p_tax_category_id, a.line_no