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 892: , jai_retro_line_changes jrlc

888: ,nvl(jcta.vat_flag,'N') VAT_FLAG
889: ,nvl(jcta.adhoc_flag,'N') adhoc_flag
890: FROM
891: jai_retro_tax_changes jrl
892: , jai_retro_line_changes jrlc
893: , jai_cmn_taxes_all jcta
894: WHERE jrlc.line_location_id = p_line_location_id
895: AND jrlc.line_change_id = jrl.line_change_id
896: AND jrlc.doc_version_number = (SELECT max(doc_version_number)

Line 897: FROM jai_retro_line_changes

893: , jai_cmn_taxes_all jcta
894: WHERE jrlc.line_location_id = p_line_location_id
895: AND jrlc.line_change_id = jrl.line_change_id
896: AND jrlc.doc_version_number = (SELECT max(doc_version_number)
897: FROM jai_retro_line_changes
898: WHERE doc_type IN ('STANDARD PO', 'RELEASE')
899: AND doc_line_id = jrlc.doc_line_id
900: )
901: AND jrlc.doc_type IN ('STANDARD PO', 'RELEASE')

Line 1119: , jai_retro_line_changes jrlc

1115: FROM
1116: jai_retro_tax_changes jrl
1117: , rcv_shipment_lines rsl
1118: , rcv_transactions rt
1119: , jai_retro_line_changes jrlc
1120: , jai_cmn_taxes_all jcta
1121: WHERE jrlc.doc_line_id = rsl.shipment_line_id
1122: AND jrlc.line_change_id = jrl.line_change_id
1123: AND jrlc.doc_version_number = (SELECT max(doc_version_number)

Line 1124: FROM jai_retro_line_changes

1120: , jai_cmn_taxes_all jcta
1121: WHERE jrlc.doc_line_id = rsl.shipment_line_id
1122: AND jrlc.line_change_id = jrl.line_change_id
1123: AND jrlc.doc_version_number = (SELECT max(doc_version_number)
1124: FROM jai_retro_line_changes
1125: WHERE doc_type = 'RECEIPT'
1126: AND doc_line_id = jrlc.doc_line_id
1127: )
1128: AND jrlc.doc_type = 'RECEIPT'