DBA Data[Home] [Help]

APPS.JAI_AP_MATCH_TAX_PKG dependencies on JAI_RCV_LINE_TAXES

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

732: CURSOR tax_lines1_cur(tran_id NUMBER,ven_id NUMBER)
733: IS
734: SELECT jrl.tax_amount tax_amount, jrl.tax_id, jrl.currency,jrl.tax_type tax_type, jrl.modvat_flag,
735: jrl.tax_line_no tax_line_no --modified by kunkumar for bug 5593895
736: FROM JAI_RCV_LINE_TAXES jrl,rcv_shipment_lines rsl,rcv_transactions rt
737: WHERE jrl.shipment_line_id = rsl.shipment_line_id
738: AND rt.shipment_line_id = rsl.shipment_line_id
739: AND rt.transaction_id = tran_id
740: AND jrl.vendor_id = ven_id

Line 767: JAI_RCV_LINE_TAXES jrl

763: , jrl.modvat_flag
764: , jrl.tax_line_no tax_line_no --modified by kunkumar for bug 5593895
765: , NVL(jcta.inclusive_tax_flag,'N') inc_tax_flag --Added by Eric for Inclusive Tax
766: FROM
767: JAI_RCV_LINE_TAXES jrl
768: , RCV_SHIPMENT_LINES RSL
769: , RCV_TRANSACTIONS RT
770: , jai_cmn_taxes_all jcta
771: WHERE jrl.shipment_line_id = rsl.shipment_line_id

Line 806: jai_rcv_line_taxes jrl

802: , jrl.modvat_flag
803: , jrl.tax_line_no tax_line_no --Added by kunkumar for bug 5593895
804: , NVL(jcta.inclusive_tax_flag,'N') inc_tax_flag --Added by Eric for Inclusive Tax
805: FROM
806: jai_rcv_line_taxes jrl
807: , rcv_shipment_lines rsl
808: , rcv_transactions rt
809: , jai_cmn_taxes_all jcta --Added by Eric for Inclusive Tax
810: WHERE jrl.shipment_line_id = rsl.shipment_line_id

Line 1608: from rcv_transactions and taxes from JAI_RCV_LINE_TAXES.

1604:
1605: 38 08/07/2004 Aparajita for bug#3752887. Version#115.3. Clean up.
1606:
1607: Function apportion_tax_pay_on_rect_f was considering the quantity
1608: from rcv_transactions and taxes from JAI_RCV_LINE_TAXES.
1609: This fails when there have been corrections as taxes are modified as
1610: per the corrected quantity.
1611:
1612: Cleaned the entire logic of apportioning of tax from PO to AP.

Line 5839: JAI_RCV_LINE_TAXES jrl

5835: , jrl.modvat_flag
5836: , jrl.tax_line_no --Added by kunkumar for bug#5593895
5837: , NVL(jcta.inclusive_tax_flag,'N') inc_tax_flag --Added by Eric for Inclusive Tax
5838: FROM
5839: JAI_RCV_LINE_TAXES jrl
5840: , rcv_shipment_lines rsl
5841: , rcv_transactions rt
5842: , jai_cmn_taxes_all jcta
5843: WHERE jrl.shipment_line_id = rsl.shipment_line_id

Line 6481: from rcv_transactions and taxes from JAI_RCV_LINE_TAXES.

6477:
6478: 36 08/07/2004 Aparajita for bug#3752887. Version#115.1, Clean up.
6479:
6480: Function apportion_tax_pay_on_rect_f was considering the quantity
6481: from rcv_transactions and taxes from JAI_RCV_LINE_TAXES.
6482: This fails when there have been corrections as taxes are modified as
6483: per the corrected quantity.
6484:
6485: Cleaned the entire logic of apportioning of tax from PO to AP.