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_CMN_TAXES_ALL

Line 369: , p_thhold_cat_base_tax_typ JAI_CMN_TAXES_ALL.tax_type%type default null -- tax type to be considered as base when calculating threshold taxes

365: p_last_update_login NUMBER,
366: p_operation_flag NUMBER DEFAULT NULL , -- for CRM this is used to hold aso_shipments.shipment_id
367: p_vat_assessable_value NUMBER DEFAULT 0
368: /** bgowrava for forward porting bug#5631784,Following parameters are added for TCS enh.*/
369: , p_thhold_cat_base_tax_typ JAI_CMN_TAXES_ALL.tax_type%type default null -- tax type to be considered as base when calculating threshold taxes
370: , p_threshold_tax_cat_id JAI_AP_TDS_THHOLD_TAXES.tax_category_id%type default null
371: , p_source_trx_type jai_cmn_document_taxes.source_doc_type%type default null
372: , p_source_table_name jai_cmn_document_taxes.source_table_name%type default null
373: , p_action varchar2 default null

Line 527: from JAI_CMN_TAX_CTG_LINES cat, JAI_CMN_TAXES_ALL taxes

523:
524: cursor c_get_max_rgm_tax_line
525: is
526: select max(line_no) max_rgm_tax_line
527: from JAI_CMN_TAX_CTG_LINES cat, JAI_CMN_TAXES_ALL taxes
528: where cat.tax_category_id = p_tax_category_id
529: and taxes.tax_id = cat.tax_id
530: and taxes.tax_type = p_thhold_cat_base_tax_typ;
531:

Line 559: FROM JAI_CMN_TAX_CTG_LINES a, JAI_CMN_TAXES_ALL b ,

555: )
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

Line 623: UOM setup in the tax definitions India Localization (JAI_CMN_TAXES_ALL table).

619:
620: 1. 12/07/2003 Aiyer - Bug #3749294 File Version 115.1
621: Issue:-
622: Uom based taxes do not get calculated correctly if the transaction UOM is different from the
623: UOM setup in the tax definitions India Localization (JAI_CMN_TAXES_ALL table).
624:
625: Reason:-
626: --------
627: This was happening because the UOM calculation was previously happening only for cases of exact match

Line 654: JAI_CMN_TAXES_ALL table based on the tax type column.

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:
658: Dependency due to this bug - Huge

Line 843: from JAI_CMN_TAXES_ALL

839: /*Fetch quantity of parent line to populate taxes in child lines*/
840: ja_in_po_get_reqline_p(p_parent_req_line_id, ln_prev_quantity);
841:
842: select rounding_factor into ln_rounding_factor
843: from JAI_CMN_TAXES_ALL
844: where tax_id = c_req_tax_lines.tax_id;
845:
846: /*Insert Tax Lines for child lines based on Tax lines of the parent*/
847: insert into JAI_PO_REQ_LINE_TAXES(

Line 1015: , JAI_CMN_TAXES_ALL b

1011: , b.adhoc_flag
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$$

Line 2754: , JAI_CMN_TAXES_ALL b

2750: , nvl(b.rounding_factor,0) rounding_factor
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$$

Line 3665: FROM jai_cmn_taxes_all

3661: ------------------------------
3662: BEGIN
3663: SELECT tax_type
3664: INTO lv_tax_type
3665: FROM jai_cmn_taxes_all
3666: WHERE tax_id = rec.tax_id;
3667: EXCEPTION
3668: WHEN OTHERS THEN
3669: lv_tax_type := NULL;

Line 3917: FROM JAI_CMN_TAXES_ALL

3913: operation VARCHAR2(2);
3914:
3915: CURSOR fetch_mod_cr_cur( taxid IN NUMBER ) IS
3916: SELECT Tax_Type, Mod_Cr_Percentage, Vendor_Id
3917: FROM JAI_CMN_TAXES_ALL
3918: WHERE Tax_Id = taxid;
3919:
3920: CURSOR fetch_vendor2_cur IS
3921: SELECT vendor_id

Line 4688: , JAI_CMN_TAXES_ALL b

4684: , b.adhoc_flag
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

Line 4764: , JAI_CMN_TAXES_ALL b

4760: , b.adhoc_flag
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