DBA Data[Home] [Help]

APPS.JAI_AP_MATCH_TAX_PKG dependencies on JAI_RCV_LINE_TAXES

Line 1000: FROM JAI_RCV_LINE_TAXES jrl,rcv_shipment_lines rsl,rcv_transactions rt

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

Line 1034: JAI_RCV_LINE_TAXES jrl

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

Line 1080: jai_rcv_line_taxes jrl

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

Line 1935: from rcv_transactions and taxes from JAI_RCV_LINE_TAXES.

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.

Line 7390: JAI_RCV_LINE_TAXES jrl

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

Line 8035: from rcv_transactions and taxes from JAI_RCV_LINE_TAXES.

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.