APPS.PO_OTM_INTEGRATION_PVT dependencies on PO_HEADERS_ARCHIVE_ALL

Line 410: FROM po_headers_archive_all poha

406: , l_po_number
407: , l_release_number
408: , l_doc_revision
409: , l_org_name
410: FROM po_headers_archive_all poha
411: , po_releases_archive_all pora
412: , hr_all_organization_units hou
413: WHERE pora.po_release_id = p_doc_id
414: AND pora.latest_external_flag = 'Y'

Line 427: FROM po_headers_archive_all poha

423: , hou.name
424: INTO l_po_number
425: , l_doc_revision
426: , l_org_name
427: FROM po_headers_archive_all poha
428: , hr_all_organization_units hou
429: WHERE poha.po_header_id = p_doc_id
430: AND poha.latest_external_flag = 'Y'
431: AND hou.organization_id = poha.org_id;

Line 826: FROM po_headers_archive_all poha

822: , HR_GENERAL.get_phone_number(
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

Line 959: FROM po_headers_archive_all poha

955: , x_otm_doc.buyer_fax
956: , x_otm_doc.bill_to_location_id
957: , x_otm_doc.bill_to_location_code
958: , x_otm_doc.terms
959: FROM po_headers_archive_all poha
960: , po_vendors pov
961: , po_vendor_sites_all povs
962: , fnd_territories fter
963: , po_vendor_contacts povc

Line 1341: FROM po_headers_archive_all poha

1337: SELECT pola.po_line_id
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

Line 1396: FROM po_headers_archive_all poha

1392: , hou.name
1393: INTO x_otm_doc.po_header_id
1394: , x_otm_doc.po_number
1395: , x_otm_doc.org_name
1396: FROM po_headers_archive_all poha
1397: , hr_all_organization_units hou
1398: WHERE poha.po_header_id = p_doc_id
1399: AND poha.revision_num = p_doc_revision
1400: AND poha.org_id = hou.organization_id

Line 1507: FROM po_headers_archive_all poha

1503: , hou.name
1504: INTO x_otm_doc.po_header_id
1505: , x_otm_doc.po_number
1506: , x_otm_doc.org_name
1507: FROM po_headers_archive_all poha
1508: , hr_all_organization_units hou
1509: WHERE poha.po_header_id = p_doc_id
1510: AND poha.revision_num = p_doc_revision
1511: AND poha.org_id = hou.organization_id

Line 1581: FROM po_headers_archive_all poha

1577: , HR_GENERAL.get_phone_number(
1578: psg.deliver_to_person_id, 'W1', SYSDATE) ship_to_contact_phone
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

Line 1723: FROM po_headers_archive_all poha

1719: , x_otm_doc.buyer_fax
1720: , x_otm_doc.bill_to_location_id
1721: , x_otm_doc.bill_to_location_code
1722: , x_otm_doc.terms
1723: FROM po_headers_archive_all poha
1724: , po_releases_archive_all pora
1725: , po_vendors pov
1726: , po_vendor_sites_all povs
1727: , fnd_territories fter

Line 2108: FROM po_headers_archive_all poha

2104: SELECT pola.po_line_id
2105: , plla.line_location_id
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

Line 2171: FROM po_headers_archive_all poha

2167: , x_otm_doc.po_release_id
2168: , x_otm_doc.po_number
2169: , x_otm_doc.release_number
2170: , x_otm_doc.org_name
2171: FROM po_headers_archive_all poha
2172: , po_releases_archive_all pora
2173: , hr_all_organization_units hou
2174: WHERE pora.po_release_id = p_doc_id
2175: AND pora.revision_num = p_doc_revision

Line 2287: FROM po_headers_archive_all poha

2283: , x_otm_doc.po_release_id
2284: , x_otm_doc.po_number
2285: , x_otm_doc.release_number
2286: , x_otm_doc.org_name
2287: FROM po_headers_archive_all poha
2288: , po_releases_all por
2289: , hr_all_organization_units hou
2290: WHERE por.po_release_id = p_doc_id
2291: AND poha.po_header_id = por.po_header_id