[Home] [Help]
814: /* commented out by eric for inclusive tax
815: CURSOR from_line_location_taxes(p_line_location_id NUMBER, vend_id NUMBER) IS
816: SELECT tax_id, tax_amount, currency, tax_target_amount, nvl(modvat_flag,'Y') modvat_flag,
817: tax_type, tax_line_no -- added by kunkumar for bug 5593895
818: FROM JAI_PO_TAXES
819: -- WHERE line_focus_id = focus_id
820: WHERE line_location_id = p_line_location_id -- 3096578
821: AND NVL(upper(tax_type), 'A') NOT IN
822: ('TDS',
849: , NVL(jcta.inclusive_tax_flag,'N') inc_tax_flag --Added by Eric for Inclusive Tax
850: ,nvl(jcta.vat_flag,'N') VAT_FLAG
851: ,nvl(jcta.adhoc_flag,'N') adhoc_flag
852: FROM
853: JAI_PO_TAXES jpt
854: , JAI_CMN_TAXES_ALL jcta --Added by Eric for Inclusive Tax
855: -- WHERE line_focus_id = focus_id
856: WHERE line_location_id = p_line_location_id -- 3096578
857: AND NVL(UPPER(jpt.tax_type), 'A')
7426: , jpt.tax_type
7427: , jpt.tax_line_no --Added by kunkumar for bug#5593895
7428: , NVL(jcta.inclusive_tax_flag,'N') inc_tax_flag --Added by Eric for Inclusive Tax
7429: FROM
7430: jai_po_taxes jpt
7431: , jai_cmn_taxes_all jcta --Added by Eric for Inclusive Tax
7432: -- WHERE line_focus_id = focus_id
7433: WHERE jpt.line_location_id = p_line_location_id -- 3096578
7434: AND jcta.tax_id = jpt.tax_id --Added by Eric for Inclusive Tax
7877: - from_line_location_taxes
7878: - tax_lines1_cur
7879:
7880: 12. 13/04/2003 bug#2799217. Version # 615.10
7881: line focus id from JAI_PO_TAXES instead of
7882: JAI_PO_LINE_LOCATIONS, changed cursor get_focus_id.
7883:
7884: This was done as in some cases data does not exist in
7885: JAI_PO_LINE_LOCATIONS but exists in JAI_PO_TAXES.
7881: line focus id from JAI_PO_TAXES instead of
7882: JAI_PO_LINE_LOCATIONS, changed cursor get_focus_id.
7883:
7884: This was done as in some cases data does not exist in
7885: JAI_PO_LINE_LOCATIONS but exists in JAI_PO_TAXES.
7886: The root cause of this will be looked into separately.
7887:
7888: 13 17/07/2003 Aparajita for bug#3038566, version # 616.1
7889: