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 757: , po_lines_archive_all pola

753: psg.deliver_to_person_id, 'W1', SYSDATE) ship_to_contact_phone
754: , HR_GENERAL.get_phone_number(
755: psg.deliver_to_person_id, 'W1', SYSDATE) ship_to_contact_fax
756: FROM po_headers_archive_all poha
757: , po_lines_archive_all pola
758: , po_line_locations_archive_all plla
759: , hr_all_organization_units hou
760: , hr_locations_all hrl
761: , mtl_system_items_kfv msik

Line 774: FROM po_lines_archive_all pola2

770: AND poha.revision_num = p_doc_revision
771: AND pola.po_header_id = poha.po_header_id
772: AND pola.revision_num =
773: ( SELECT MAX(pola2.revision_num)
774: FROM po_lines_archive_all pola2
775: WHERE pola2.po_line_id = pola.po_line_id
776: AND pola2.revision_num <= poha.revision_num )
777: AND plla.po_line_id = pola.po_line_id
778: AND plla.revision_num =

Line 1270: , po_lines_archive_all pola

1266: , plla.line_location_id
1267: , pola.line_num
1268: , plla.shipment_num
1269: FROM po_headers_archive_all poha
1270: , po_lines_archive_all pola
1271: , po_line_locations_archive_all plla
1272: , financials_system_params_all fsp
1273: , mtl_system_items msi
1274: WHERE poha.po_header_id = p_doc_id

Line 1279: FROM po_lines_archive_all pola2

1275: AND poha.revision_num = p_doc_revision
1276: AND pola.po_header_id = poha.po_header_id
1277: AND pola.revision_num =
1278: ( SELECT MAX(pola2.revision_num)
1279: FROM po_lines_archive_all pola2
1280: WHERE pola2.po_line_id = pola.po_line_id
1281: AND pola2.revision_num <= poha.revision_num )
1282: AND plla.po_line_id = pola.po_line_id
1283: AND plla.revision_num =

Line 1511: , po_lines_archive_all pola

1507: , HR_GENERAL.get_phone_number(
1508: psg.deliver_to_person_id, 'W1', SYSDATE) ship_to_contact_fax
1509: FROM po_headers_archive_all poha
1510: , po_releases_archive_all pora
1511: , po_lines_archive_all pola
1512: , po_line_locations_archive_all plla
1513: , hr_all_organization_units hou
1514: , hr_locations_all hrl
1515: , mtl_system_items_kfv msik

Line 1530: FROM po_lines_archive_all pola2

1526: AND poha.revision_num = p_blanket_revision
1527: AND pola.po_header_id = poha.po_header_id
1528: AND pola.revision_num =
1529: ( SELECT MAX(pola2.revision_num)
1530: FROM po_lines_archive_all pola2
1531: WHERE pola2.po_line_id = pola.po_line_id
1532: AND pola2.revision_num <= poha.revision_num )
1533: AND plla.po_line_id = pola.po_line_id
1534: AND plla.po_release_id = pora.po_release_id

Line 2038: , po_lines_archive_all pola

2034: , pola.line_num
2035: , plla.shipment_num
2036: FROM po_headers_archive_all poha
2037: , po_releases_archive_all pora
2038: , po_lines_archive_all pola
2039: , po_line_locations_archive_all plla
2040: , mtl_system_items msi
2041: , financials_system_params_all fsp
2042: WHERE pora.po_release_id = p_doc_id

Line 2049: FROM po_lines_archive_all pola2

2045: AND poha.revision_num = p_blanket_revision
2046: AND pola.po_header_id = poha.po_header_id
2047: AND pola.revision_num =
2048: ( SELECT MAX(pola2.revision_num)
2049: FROM po_lines_archive_all pola2
2050: WHERE pola2.po_line_id = pola.po_line_id
2051: AND pola2.po_header_id = poha.po_header_id
2052: AND pola2.revision_num <= poha.revision_num )
2053: AND plla.po_line_id = pola.po_line_id