[Home] [Help]
572: /* commented out by eric for inclusive tax
573: CURSOR from_line_location_taxes(p_line_location_id NUMBER, vend_id NUMBER) IS
574: SELECT tax_id, tax_amount, currency, tax_target_amount, nvl(modvat_flag,'Y') modvat_flag,
575: tax_type, tax_line_no -- added by kunkumar for bug 5593895
576: FROM JAI_PO_TAXES
577: -- WHERE line_focus_id = focus_id
578: WHERE line_location_id = p_line_location_id -- 3096578
579: AND NVL(upper(tax_type), 'A') NOT IN
580: ('TDS',
605: , jpt.tax_type
606: , jpt.tax_line_no -- added by kunkumar for bug 5593895
607: , NVL(jcta.inclusive_tax_flag,'N') inc_tax_flag --Added by Eric for Inclusive Tax
608: FROM
609: JAI_PO_TAXES jpt
610: , JAI_CMN_TAXES_ALL jcta --Added by Eric for Inclusive Tax
611: -- WHERE line_focus_id = focus_id
612: WHERE line_location_id = p_line_location_id -- 3096578
613: AND NVL(UPPER(jpt.tax_type), 'A')
5875: , jpt.tax_type
5876: , jpt.tax_line_no --Added by kunkumar for bug#5593895
5877: , NVL(jcta.inclusive_tax_flag,'N') inc_tax_flag --Added by Eric for Inclusive Tax
5878: FROM
5879: jai_po_taxes jpt
5880: , jai_cmn_taxes_all jcta --Added by Eric for Inclusive Tax
5881: -- WHERE line_focus_id = focus_id
5882: WHERE jpt.line_location_id = p_line_location_id -- 3096578
5883: AND jcta.tax_id = jpt.tax_id --Added by Eric for Inclusive Tax
6323: - from_line_location_taxes
6324: - tax_lines1_cur
6325:
6326: 12. 13/04/2003 bug#2799217. Version # 615.10
6327: line focus id from JAI_PO_TAXES instead of
6328: JAI_PO_LINE_LOCATIONS, changed cursor get_focus_id.
6329:
6330: This was done as in some cases data does not exist in
6331: JAI_PO_LINE_LOCATIONS but exists in JAI_PO_TAXES.
6327: line focus id from JAI_PO_TAXES instead of
6328: JAI_PO_LINE_LOCATIONS, changed cursor get_focus_id.
6329:
6330: This was done as in some cases data does not exist in
6331: JAI_PO_LINE_LOCATIONS but exists in JAI_PO_TAXES.
6332: The root cause of this will be looked into separately.
6333:
6334: 13 17/07/2003 Aparajita for bug#3038566, version # 616.1
6335: