[Home] [Help]
225: l_command VARCHAR2(30);
226:
227: l_doc_revision NUMBER;
228: l_blanket_revision PO_HEADERS_ALL.revision_num%TYPE;
229: l_org_name HR_ALL_ORGANIZATION_UNITS.name%TYPE;
230: l_po_number PO_HEADERS_ALL.segment1%TYPE;
231: l_release_number PO_RELEASES_ALL.release_num%TYPE;
232: l_shipping_control PO_HEADERS_ALL.shipping_control%TYPE;
233: l_line_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE; --
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'
389: AND poha.po_header_id = pora.po_header_id
390: AND poha.latest_external_flag = 'Y'
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;
406: ELSE
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
763: , financials_system_params_all fsp
890: , po_vendors pov
891: , po_vendor_sites_all povs
892: , fnd_territories fter
893: , po_vendor_contacts povc
894: , hr_all_organization_units hou
895: , hr_locations_all hrl
896: , per_all_people_f ppf
897: , hr_locations_all hrl2
898: , ap_terms apt
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
1329: AND NVL(poha.consigned_consumption_flag, 'N') = 'N'
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
1440: AND NVL(poha.consigned_consumption_flag, 'N') = 'N'
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
1517: , financials_system_params_all fsp
1653: , po_vendors pov
1654: , po_vendor_sites_all povs
1655: , fnd_territories fter
1656: , po_vendor_contacts povc
1657: , hr_all_organization_units hou
1658: , hr_locations_all hrl
1659: , per_all_people_f ppf
1660: , hr_locations_all hrl2
1661: , ap_terms apt
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
2104: AND poha.po_header_id = pora.po_header_id
2105: AND poha.revision_num = p_blanket_revision
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
2220: AND poha.revision_num = p_blanket_revision
2221: AND poha.org_id = hou.organization_id