DBA Data[Home] [Help]

APPS.PO_OTM_INTEGRATION_PVT dependencies on PO_HEADERS_ARCHIVE_ALL

Line 384: FROM po_headers_archive_all poha

380: , l_po_number
381: , l_release_number
382: , l_doc_revision
383: , l_org_name
384: FROM po_headers_archive_all poha
385: , po_releases_archive_all pora
386: , hr_all_organization_units hou
387: WHERE pora.po_release_id = p_doc_id
388: AND pora.latest_external_flag = 'Y'

Line 401: FROM po_headers_archive_all poha

397: , hou.name
398: INTO l_po_number
399: , l_doc_revision
400: , l_org_name
401: FROM po_headers_archive_all poha
402: , hr_all_organization_units hou
403: WHERE poha.po_header_id = p_doc_id
404: AND poha.latest_external_flag = 'Y'
405: AND hou.organization_id = poha.org_id;

Line 756: FROM po_headers_archive_all poha

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

Line 889: FROM po_headers_archive_all poha

885: , x_otm_doc.buyer_fax
886: , x_otm_doc.bill_to_location_id
887: , x_otm_doc.bill_to_location_code
888: , x_otm_doc.terms
889: FROM po_headers_archive_all poha
890: , po_vendors pov
891: , po_vendor_sites_all povs
892: , fnd_territories fter
893: , po_vendor_contacts povc

Line 1269: FROM po_headers_archive_all poha

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

Line 1324: FROM po_headers_archive_all poha

1320: , hou.name
1321: INTO x_otm_doc.po_header_id
1322: , x_otm_doc.po_number
1323: , x_otm_doc.org_name
1324: FROM po_headers_archive_all poha
1325: , hr_all_organization_units hou
1326: WHERE poha.po_header_id = p_doc_id
1327: AND poha.revision_num = p_doc_revision
1328: AND poha.org_id = hou.organization_id

Line 1435: FROM po_headers_archive_all poha

1431: , hou.name
1432: INTO x_otm_doc.po_header_id
1433: , x_otm_doc.po_number
1434: , x_otm_doc.org_name
1435: FROM po_headers_archive_all poha
1436: , hr_all_organization_units hou
1437: WHERE poha.po_header_id = p_doc_id
1438: AND poha.revision_num = p_doc_revision
1439: AND poha.org_id = hou.organization_id

Line 1509: FROM po_headers_archive_all poha

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

Line 1651: FROM po_headers_archive_all poha

1647: , x_otm_doc.buyer_fax
1648: , x_otm_doc.bill_to_location_id
1649: , x_otm_doc.bill_to_location_code
1650: , x_otm_doc.terms
1651: FROM po_headers_archive_all poha
1652: , po_releases_archive_all pora
1653: , po_vendors pov
1654: , po_vendor_sites_all povs
1655: , fnd_territories fter

Line 2036: FROM po_headers_archive_all poha

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

Line 2099: FROM po_headers_archive_all poha

2095: , x_otm_doc.po_release_id
2096: , x_otm_doc.po_number
2097: , x_otm_doc.release_number
2098: , x_otm_doc.org_name
2099: FROM po_headers_archive_all poha
2100: , po_releases_archive_all pora
2101: , hr_all_organization_units hou
2102: WHERE pora.po_release_id = p_doc_id
2103: AND pora.revision_num = p_doc_revision

Line 2215: FROM po_headers_archive_all poha

2211: , x_otm_doc.po_release_id
2212: , x_otm_doc.po_number
2213: , x_otm_doc.release_number
2214: , x_otm_doc.org_name
2215: FROM po_headers_archive_all poha
2216: , po_releases_all por
2217: , hr_all_organization_units hou
2218: WHERE por.po_release_id = p_doc_id
2219: AND poha.po_header_id = por.po_header_id