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.PO_OTM_INTEGRATION_PVT dependencies on PO_LINES_ARCHIVE_ALL

Line 827: , po_lines_archive_all pola

823: psg.deliver_to_person_id, 'W1', SYSDATE) ship_to_contact_phone
824: , HR_GENERAL.get_phone_number(
825: psg.deliver_to_person_id, 'W1', SYSDATE) ship_to_contact_fax
826: FROM po_headers_archive_all poha
827: , po_lines_archive_all pola
828: , po_line_locations_archive_all plla
829: , hr_all_organization_units hou
830: , hr_locations_all hrl
831: , mtl_system_items_kfv msik

Line 844: FROM po_lines_archive_all pola2

840: AND poha.revision_num = p_doc_revision
841: AND pola.po_header_id = poha.po_header_id
842: AND pola.revision_num =
843: ( SELECT MAX(pola2.revision_num)
844: FROM po_lines_archive_all pola2
845: WHERE pola2.po_line_id = pola.po_line_id
846: AND pola2.revision_num <= poha.revision_num )
847: AND plla.po_line_id = pola.po_line_id
848: AND plla.revision_num =

Line 1342: , po_lines_archive_all pola

1338: , plla.line_location_id
1339: , pola.line_num
1340: , plla.shipment_num
1341: FROM po_headers_archive_all poha
1342: , po_lines_archive_all pola
1343: , po_line_locations_archive_all plla
1344: , financials_system_params_all fsp
1345: , mtl_system_items msi
1346: WHERE poha.po_header_id = p_doc_id

Line 1351: FROM po_lines_archive_all pola2

1347: AND poha.revision_num = p_doc_revision
1348: AND pola.po_header_id = poha.po_header_id
1349: AND pola.revision_num =
1350: ( SELECT MAX(pola2.revision_num)
1351: FROM po_lines_archive_all pola2
1352: WHERE pola2.po_line_id = pola.po_line_id
1353: AND pola2.revision_num <= poha.revision_num )
1354: AND plla.po_line_id = pola.po_line_id
1355: AND plla.revision_num =

Line 1583: , po_lines_archive_all pola

1579: , HR_GENERAL.get_phone_number(
1580: psg.deliver_to_person_id, 'W1', SYSDATE) ship_to_contact_fax
1581: FROM po_headers_archive_all poha
1582: , po_releases_archive_all pora
1583: , po_lines_archive_all pola
1584: , po_line_locations_archive_all plla
1585: , hr_all_organization_units hou
1586: , hr_locations_all hrl
1587: , mtl_system_items_kfv msik

Line 1602: FROM po_lines_archive_all pola2

1598: AND poha.revision_num = p_blanket_revision
1599: AND pola.po_header_id = poha.po_header_id
1600: AND pola.revision_num =
1601: ( SELECT MAX(pola2.revision_num)
1602: FROM po_lines_archive_all pola2
1603: WHERE pola2.po_line_id = pola.po_line_id
1604: AND pola2.revision_num <= poha.revision_num )
1605: AND plla.po_line_id = pola.po_line_id
1606: AND plla.po_release_id = pora.po_release_id

Line 2110: , po_lines_archive_all pola

2106: , pola.line_num
2107: , plla.shipment_num
2108: FROM po_headers_archive_all poha
2109: , po_releases_archive_all pora
2110: , po_lines_archive_all pola
2111: , po_line_locations_archive_all plla
2112: , mtl_system_items msi
2113: , financials_system_params_all fsp
2114: WHERE pora.po_release_id = p_doc_id

Line 2121: FROM po_lines_archive_all pola2

2117: AND poha.revision_num = p_blanket_revision
2118: AND pola.po_header_id = poha.po_header_id
2119: AND pola.revision_num =
2120: ( SELECT MAX(pola2.revision_num)
2121: FROM po_lines_archive_all pola2
2122: WHERE pola2.po_line_id = pola.po_line_id
2123: AND pola2.po_header_id = poha.po_header_id
2124: AND pola2.revision_num <= poha.revision_num )
2125: AND plla.po_line_id = pola.po_line_id