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 828: , po_line_locations_archive_all plla

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

Line 850: FROM po_line_locations_archive_all plla2

846: AND pola2.revision_num <= poha.revision_num )
847: AND plla.po_line_id = pola.po_line_id
848: AND plla.revision_num =
849: ( SELECT MAX(plla2.revision_num)
850: FROM po_line_locations_archive_all plla2
851: WHERE plla2.line_location_id = plla.line_location_id
852: AND plla2.revision_num <= poha.revision_num )
853: AND psg.line_location_id (+) = plla.line_location_id
854: AND ppf.person_id (+) = psg.deliver_to_person_id

Line 1025: FROM po_line_locations_archive_all plla

1021: ( SELECT l_gt_key1
1022: , poda.line_location_id
1023: , poda.distribution_num
1024: , poda.deliver_to_person_id
1025: FROM po_line_locations_archive_all plla
1026: , po_distributions_archive_all poda
1027: WHERE plla.po_header_id = p_doc_id
1028: AND plla.revision_num = ( SELECT MAX(plla2.revision_num)
1029: FROM

Line 1030: po_line_locations_archive_all plla2

1026: , po_distributions_archive_all poda
1027: WHERE plla.po_header_id = p_doc_id
1028: AND plla.revision_num = ( SELECT MAX(plla2.revision_num)
1029: FROM
1030: po_line_locations_archive_all plla2
1031: WHERE plla2.line_location_id
1032: = plla.line_location_id
1033: AND plla2.po_header_id = p_doc_id
1034: AND plla2.revision_num <= p_doc_revision )

Line 1343: , po_line_locations_archive_all plla

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

Line 1357: FROM po_line_locations_archive_all plla2

1353: AND pola2.revision_num <= poha.revision_num )
1354: AND plla.po_line_id = pola.po_line_id
1355: AND plla.revision_num =
1356: ( SELECT MAX(plla2.revision_num)
1357: FROM po_line_locations_archive_all plla2
1358: WHERE plla2.line_location_id = plla.line_location_id
1359: AND plla2.revision_num <= poha.revision_num )
1360: AND pola.order_type_lookup_code = 'QUANTITY'
1361: AND fsp.org_id = pola.org_id

Line 1584: , po_line_locations_archive_all plla

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

Line 1609: FROM po_line_locations_archive_all plla2

1605: AND plla.po_line_id = pola.po_line_id
1606: AND plla.po_release_id = pora.po_release_id
1607: AND plla.revision_num =
1608: ( SELECT MAX(plla2.revision_num)
1609: FROM po_line_locations_archive_all plla2
1610: WHERE plla2.line_location_id = plla.line_location_id
1611: AND plla2.revision_num <= pora.revision_num )
1612: AND psg.line_location_id (+) = plla.line_location_id
1613: AND ppf.person_id (+) = psg.deliver_to_person_id

Line 1792: FROM po_line_locations_archive_all plla

1788: ( SELECT l_gt_key1
1789: , poda.line_location_id
1790: , poda.distribution_num
1791: , poda.deliver_to_person_id
1792: FROM po_line_locations_archive_all plla
1793: , po_distributions_archive_all poda
1794: WHERE plla.po_release_id = p_doc_id
1795: AND plla.revision_num = ( SELECT MAX(plla2.revision_num)
1796: FROM

Line 1797: po_line_locations_archive_all plla2

1793: , po_distributions_archive_all poda
1794: WHERE plla.po_release_id = p_doc_id
1795: AND plla.revision_num = ( SELECT MAX(plla2.revision_num)
1796: FROM
1797: po_line_locations_archive_all plla2
1798: WHERE plla2.line_location_id
1799: = plla.line_location_id
1800: AND plla2.po_release_id = p_doc_id
1801: AND plla2.revision_num <= p_doc_revision )

Line 2111: , po_line_locations_archive_all plla

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

Line 2129: FROM po_line_locations_archive_all plla2

2125: AND plla.po_line_id = pola.po_line_id
2126: AND plla.po_release_id = pora.po_release_id
2127: AND plla.revision_num =
2128: ( SELECT MAX(plla2.revision_num)
2129: FROM po_line_locations_archive_all plla2
2130: WHERE plla2.line_location_id = plla.line_location_id
2131: AND plla2.po_line_id = pola.po_line_id
2132: AND plla2.revision_num <= pora.revision_num )
2133: AND pola.order_type_lookup_code = 'QUANTITY'