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_LINE_LOCATIONS_ARCHIVE_ALL

Line 758: , po_line_locations_archive_all plla

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
762: , mtl_units_of_measure muom

Line 780: FROM po_line_locations_archive_all plla2

776: AND pola2.revision_num <= poha.revision_num )
777: AND plla.po_line_id = pola.po_line_id
778: AND plla.revision_num =
779: ( SELECT MAX(plla2.revision_num)
780: FROM po_line_locations_archive_all plla2
781: WHERE plla2.line_location_id = plla.line_location_id
782: AND plla2.revision_num <= poha.revision_num )
783: AND psg.line_location_id (+) = plla.line_location_id
784: AND ppf.person_id (+) = psg.deliver_to_person_id

Line 955: FROM po_line_locations_archive_all plla

951: ( SELECT l_gt_key1
952: , poda.line_location_id
953: , poda.distribution_num
954: , poda.deliver_to_person_id
955: FROM po_line_locations_archive_all plla
956: , po_distributions_archive_all poda
957: WHERE plla.po_header_id = p_doc_id
958: AND plla.revision_num = ( SELECT MAX(plla2.revision_num)
959: FROM

Line 960: po_line_locations_archive_all plla2

956: , po_distributions_archive_all poda
957: WHERE plla.po_header_id = p_doc_id
958: AND plla.revision_num = ( SELECT MAX(plla2.revision_num)
959: FROM
960: po_line_locations_archive_all plla2
961: WHERE plla2.line_location_id
962: = plla.line_location_id
963: AND plla2.po_header_id = p_doc_id
964: AND plla2.revision_num <= p_doc_revision )

Line 1271: , po_line_locations_archive_all plla

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
1275: AND poha.revision_num = p_doc_revision

Line 1285: FROM po_line_locations_archive_all plla2

1281: AND pola2.revision_num <= poha.revision_num )
1282: AND plla.po_line_id = pola.po_line_id
1283: AND plla.revision_num =
1284: ( SELECT MAX(plla2.revision_num)
1285: FROM po_line_locations_archive_all plla2
1286: WHERE plla2.line_location_id = plla.line_location_id
1287: AND plla2.revision_num <= poha.revision_num )
1288: AND pola.order_type_lookup_code = 'QUANTITY'
1289: AND fsp.org_id = pola.org_id

Line 1512: , po_line_locations_archive_all plla

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
1516: , mtl_units_of_measure muom

Line 1537: FROM po_line_locations_archive_all plla2

1533: AND plla.po_line_id = pola.po_line_id
1534: AND plla.po_release_id = pora.po_release_id
1535: AND plla.revision_num =
1536: ( SELECT MAX(plla2.revision_num)
1537: FROM po_line_locations_archive_all plla2
1538: WHERE plla2.line_location_id = plla.line_location_id
1539: AND plla2.revision_num <= pora.revision_num )
1540: AND psg.line_location_id (+) = plla.line_location_id
1541: AND ppf.person_id (+) = psg.deliver_to_person_id

Line 1720: FROM po_line_locations_archive_all plla

1716: ( SELECT l_gt_key1
1717: , poda.line_location_id
1718: , poda.distribution_num
1719: , poda.deliver_to_person_id
1720: FROM po_line_locations_archive_all plla
1721: , po_distributions_archive_all poda
1722: WHERE plla.po_release_id = p_doc_id
1723: AND plla.revision_num = ( SELECT MAX(plla2.revision_num)
1724: FROM

Line 1725: po_line_locations_archive_all plla2

1721: , po_distributions_archive_all poda
1722: WHERE plla.po_release_id = p_doc_id
1723: AND plla.revision_num = ( SELECT MAX(plla2.revision_num)
1724: FROM
1725: po_line_locations_archive_all plla2
1726: WHERE plla2.line_location_id
1727: = plla.line_location_id
1728: AND plla2.po_release_id = p_doc_id
1729: AND plla2.revision_num <= p_doc_revision )

Line 2039: , po_line_locations_archive_all plla

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
2043: AND pora.revision_num = p_doc_revision

Line 2057: FROM po_line_locations_archive_all plla2

2053: AND plla.po_line_id = pola.po_line_id
2054: AND plla.po_release_id = pora.po_release_id
2055: AND plla.revision_num =
2056: ( SELECT MAX(plla2.revision_num)
2057: FROM po_line_locations_archive_all plla2
2058: WHERE plla2.line_location_id = plla.line_location_id
2059: AND plla2.po_line_id = pola.po_line_id
2060: AND plla2.revision_num <= pora.revision_num )
2061: AND pola.order_type_lookup_code = 'QUANTITY'