eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AP_MATCH_TAX_PKG dependencies on JAI_RETRO_LINE_CHANGES

Line 641: , jai_retro_line_changes jrlc

637: , jrl.tax_line_no tax_line_no
638: , NVL(jcta.inclusive_tax_flag,'N') inc_tax_flag
639: FROM
640: jai_retro_tax_changes jrl
641: , jai_retro_line_changes jrlc
642: , jai_cmn_taxes_all jcta
643: WHERE jrlc.line_location_id = p_line_location_id
644: AND jrlc.line_change_id = jrl.line_change_id
645: AND jrlc.doc_version_number = (SELECT max(doc_version_number)

Line 646: FROM jai_retro_line_changes

642: , jai_cmn_taxes_all jcta
643: WHERE jrlc.line_location_id = p_line_location_id
644: AND jrlc.line_change_id = jrl.line_change_id
645: AND jrlc.doc_version_number = (SELECT max(doc_version_number)
646: FROM jai_retro_line_changes
647: WHERE doc_type IN ('STANDARD PO', 'RELEASE')
648: AND doc_line_id = jrlc.doc_line_id
649: )
650: AND jrlc.doc_type IN ('STANDARD PO', 'RELEASE')

Line 839: , jai_retro_line_changes jrlc

835: FROM
836: jai_retro_tax_changes jrl
837: , rcv_shipment_lines rsl
838: , rcv_transactions rt
839: , jai_retro_line_changes jrlc
840: , jai_cmn_taxes_all jcta
841: WHERE jrlc.doc_line_id = rsl.shipment_line_id
842: AND jrlc.line_change_id = jrl.line_change_id
843: AND jrlc.doc_version_number = (SELECT max(doc_version_number)

Line 844: FROM jai_retro_line_changes

840: , jai_cmn_taxes_all jcta
841: WHERE jrlc.doc_line_id = rsl.shipment_line_id
842: AND jrlc.line_change_id = jrl.line_change_id
843: AND jrlc.doc_version_number = (SELECT max(doc_version_number)
844: FROM jai_retro_line_changes
845: WHERE doc_type = 'RECEIPT'
846: AND doc_line_id = jrlc.doc_line_id
847: )
848: AND jrlc.doc_type = 'RECEIPT'