APPS.JAI_CMN_RCV_MATCHING_PKG dependencies on JAI_REGIME_TAX_TYPES_V

Line 1520: FROM jai_regime_tax_types_v jrttv

1516: lv_sh_excise_cess_code,4, --added by sacsethi for budget07 enhancement
1517: lv_sh_cvd_cess_code,4, --added by sacsethi for budget07 enhancement
1518: /* Added for bug#8887871 */
1519: (SELECT jrttv.tax_type
1520: FROM jai_regime_tax_types_v jrttv
1521: WHERE jrttv.tax_type = upper(b.tax_type)
1522: AND jrttv.regime_code = jai_constants.vat_regime), 5,
1523: 'VAT REVERSAL', 6, 0)) tax_type_val,
1524: b.mod_cr_Percentage ,

Line 1532: jai_regime_tax_types_v aa, -- Add by Xiao for GST refer to bug#10043656.

1528: b.adhoc_flag /* Added bug 5091874 */
1529: , b.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 12, 2007
1530: FROM
1531: JAI_OM_OE_SO_TAXES a ,
1532: jai_regime_tax_types_v aa, -- Add by Xiao for GST refer to bug#10043656.
1533: JAI_CMN_TAXES_ALL b
1534: WHERE a.line_id = p_line_id
1535: AND a.tax_id = b.tax_id
1536: AND aa.tax_type(+) = b.tax_type -- Add by Xiao for GST refer to bug#10043656.

Line 1573: FROM jai_regime_tax_types_v jrttv

1569: lv_cvd_cess_code,3,
1570: lv_sh_excise_cess_code,4, --added by sacsethi for budget07 enhancement
1571: lv_sh_cvd_cess_code,4, --added by sacsethi for budget07 enhancement
1572: (SELECT jrttv.tax_type
1573: FROM jai_regime_tax_types_v jrttv
1574: WHERE jrttv.tax_type = upper(b.tax_type)
1575: AND jrttv.regime_code = jai_constants.vat_regime), 5,
1576: 'VAT REVERSAL', 6, 0)) tax_type_val,
1577: b.mod_cr_Percentage ,

Line 1585: jai_regime_tax_types_v aa , -- Add by Xiao for GST refer to bug#10043656.

1581: b.adhoc_flag
1582: , b.inclusive_tax_flag --Add by Kevin for inclusive tax Dec 12, 2007
1583: FROM
1584: jai_cmn_document_taxes a ,
1585: jai_regime_tax_types_v aa , -- Add by Xiao for GST refer to bug#10043656.
1586: jai_cmn_taxes_all b ,
1587: jai_mtl_trxs c /* jai_mtl_trxs_temp is modified as jai_mtl_trxs by Vijay for ReArch. bug#2942973 */
1588: WHERE
1589: a.source_doc_line_id = p_line_id AND

Line 1623: FROM jai_regime_tax_types_v jrttv

1619: lv_sh_excise_cess_code,4, /*Bug 5989740 bduvarag*/
1620: lv_sh_cvd_cess_code,4,
1621: /* Added for bug#8887871 */
1622: (SELECT jrttv.tax_type
1623: FROM jai_regime_tax_types_v jrttv
1624: WHERE jrttv.tax_type = upper(b.tax_type)
1625: AND jrttv.regime_code = jai_constants.vat_regime), 5,
1626: 'VAT REVERSAL', 6, 0)) tax_type_val,
1627: b.mod_cr_Percentage, b.vendor_id, b.tax_type, NVL( b.rounding_factor, 0 ) rnd, b.adhoc_flag /* Added for bug 5091874*/

Line 1630: jai_regime_tax_types_v aa -- Add by Xiao for GST refer to bug#10043656.

1626: 'VAT REVERSAL', 6, 0)) tax_type_val,
1627: b.mod_cr_Percentage, b.vendor_id, b.tax_type, NVL( b.rounding_factor, 0 ) rnd, b.adhoc_flag /* Added for bug 5091874*/
1628: , b.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 12, 2007
1629: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b,
1630: jai_regime_tax_types_v aa -- Add by Xiao for GST refer to bug#10043656.
1631: WHERE a.link_to_cust_trx_line_id = p_line_id
1632: AND a.tax_id = b.tax_id
1633: AND aa.tax_type(+) = b.tax_type -- Add by Xiao for GST refer to bug#10043656.
1634: ORDER BY a.tax_line_no;