996: jrl.tax_type tax_type,
997: jrl.modvat_flag,
998: jrl.tax_line_no tax_line_no --modified by kunkumar for bug 5593895
999: , NVL(jcta.inclusive_tax_flag,'N') inc_tax_flag --Added by Eric for Inclusive Tax
1000: FROM JAI_RCV_LINE_TAXES jrl,rcv_shipment_lines rsl,rcv_transactions rt
1001: WHERE jrl.shipment_line_id = rsl.shipment_line_id
1002: AND rt.shipment_line_id = rsl.shipment_line_id
1003: AND rt.transaction_id = tran_id
1004: AND jrl.vendor_id = ven_id
1030: ,jcta.vat_flag vat_flag
1031: ,nvl(jcta.adhoc_flag,'N') adhoc_flag --12697697
1032:
1033: FROM
1034: JAI_RCV_LINE_TAXES jrl
1035: , RCV_SHIPMENT_LINES RSL
1036: , RCV_TRANSACTIONS RT
1037: , jai_cmn_taxes_all jcta
1038: WHERE jrl.shipment_line_id = rsl.shipment_line_id
1076: , NVL(jcta.inclusive_tax_flag,'N') inc_tax_flag --Added by Eric for Inclusive Tax
1077: ,jcta.vat_flag vat_flag
1078: ,nvl(jcta.adhoc_flag,'N') ADHOC_FLAG --12697697
1079: FROM
1080: jai_rcv_line_taxes jrl
1081: , rcv_shipment_lines rsl
1082: , rcv_transactions rt
1083: , jai_cmn_taxes_all jcta --Added by Eric for Inclusive Tax
1084: WHERE jrl.shipment_line_id = rsl.shipment_line_id
1931:
1932: 38 08/07/2004 Aparajita for bug#3752887. Version#115.3. Clean up.
1933:
1934: Function apportion_tax_pay_on_rect_f was considering the quantity
1935: from rcv_transactions and taxes from JAI_RCV_LINE_TAXES.
1936: This fails when there have been corrections as taxes are modified as
1937: per the corrected quantity.
1938:
1939: Cleaned the entire logic of apportioning of tax from PO to AP.
7386: , jrl.modvat_flag
7387: , jrl.tax_line_no --Added by kunkumar for bug#5593895
7388: , NVL(jcta.inclusive_tax_flag,'N') inc_tax_flag --Added by Eric for Inclusive Tax
7389: FROM
7390: JAI_RCV_LINE_TAXES jrl
7391: , rcv_shipment_lines rsl
7392: , rcv_transactions rt
7393: , jai_cmn_taxes_all jcta
7394: WHERE jrl.shipment_line_id = rsl.shipment_line_id
8031:
8032: 36 08/07/2004 Aparajita for bug#3752887. Version#115.1, Clean up.
8033:
8034: Function apportion_tax_pay_on_rect_f was considering the quantity
8035: from rcv_transactions and taxes from JAI_RCV_LINE_TAXES.
8036: This fails when there have been corrections as taxes are modified as
8037: per the corrected quantity.
8038:
8039: Cleaned the entire logic of apportioning of tax from PO to AP.