VIEW: APPS.PO_PURCHASE_ORDER_V

Source

View Text - Preformatted

SELECT poh.segment1, to_number(''), poh.creation_date, ppf.full_name, pov.vendor_name, poh.revision_num, poh.type_lookup_code, poh.currency_code, pol.line_num, pol.item_description, pol.unit_meas_lookup_code, pll.price_override, pll.quantity, pll.quantity_cancelled, pll.quantity_received, pll.quantity_billed, hr.location_code, pod.quantity_ordered, pod.quantity_cancelled, poh.org_id FROM PO_VENDORS POV ,PO_DISTRIBUTIONS_ALL POD ,PO_LINE_LOCATIONS_ALL PLL ,PO_LINES_ALL POL ,PO_RELEASES_ALL POR ,PO_HEADERS POH ,HR_LOCATIONS hr ,PER_PEOPLE_F ppf WHERE nvl(POH.approved_flag,'N') = 'Y' AND POH.po_header_id = POL.po_header_id AND POH.agent_id = PPF.person_id AND POV.vendor_id = POH.vendor_id AND POH.type_lookup_code = 'STANDARD' AND POL.po_line_id = PLL.po_line_id AND PLL.ship_to_location_id = HR.location_id AND PLL.line_location_id = POD.line_location_id union select poh.segment1, por.release_num, por.creation_date, ppf.full_name, pov.vendor_name, por.revision_num, 'RELEASE', poh.currency_code, pol.line_num, pol.item_description, pol.unit_meas_lookup_code, pll.price_override, pll.quantity, pll.quantity_cancelled, pll.quantity_received, pll.quantity_billed, hr.location_code, pod.quantity_ordered, pod.quantity_cancelled, por.org_id from per_people_f ppf, po_vendors pov, hr_locations hr, po_distributions_all pod, po_line_locations_all pll, po_lines_all pol, po_releases por, po_headers_all poh where nvl(por.approved_flag,'N') = 'Y' and poh.po_header_id = pol.po_header_id and por.po_header_id = poh.po_header_id and pll.po_release_id = por.po_release_id and por.agent_id = ppf.person_id and pov.vendor_id = poh.vendor_id and poh.type_lookup_code = 'BLANKET' and pol.po_line_id = pll.po_line_id and pll.ship_to_location_id = hr.location_id and pll.line_location_id = pod.line_location_id

View Text - HTML Formatted

SELECT POH.SEGMENT1
, TO_NUMBER('')
, POH.CREATION_DATE
, PPF.FULL_NAME
, POV.VENDOR_NAME
, POH.REVISION_NUM
, POH.TYPE_LOOKUP_CODE
, POH.CURRENCY_CODE
, POL.LINE_NUM
, POL.ITEM_DESCRIPTION
, POL.UNIT_MEAS_LOOKUP_CODE
, PLL.PRICE_OVERRIDE
, PLL.QUANTITY
, PLL.QUANTITY_CANCELLED
, PLL.QUANTITY_RECEIVED
, PLL.QUANTITY_BILLED
, HR.LOCATION_CODE
, POD.QUANTITY_ORDERED
, POD.QUANTITY_CANCELLED
, POH.ORG_ID
FROM PO_VENDORS POV
, PO_DISTRIBUTIONS_ALL POD
, PO_LINE_LOCATIONS_ALL PLL
, PO_LINES_ALL POL
, PO_RELEASES_ALL POR
, PO_HEADERS POH
, HR_LOCATIONS HR
, PER_PEOPLE_F PPF
WHERE NVL(POH.APPROVED_FLAG
, 'N') = 'Y'
AND POH.PO_HEADER_ID = POL.PO_HEADER_ID
AND POH.AGENT_ID = PPF.PERSON_ID
AND POV.VENDOR_ID = POH.VENDOR_ID
AND POH.TYPE_LOOKUP_CODE = 'STANDARD'
AND POL.PO_LINE_ID = PLL.PO_LINE_ID
AND PLL.SHIP_TO_LOCATION_ID = HR.LOCATION_ID
AND PLL.LINE_LOCATION_ID = POD.LINE_LOCATION_ID UNION SELECT POH.SEGMENT1
, POR.RELEASE_NUM
, POR.CREATION_DATE
, PPF.FULL_NAME
, POV.VENDOR_NAME
, POR.REVISION_NUM
, 'RELEASE'
, POH.CURRENCY_CODE
, POL.LINE_NUM
, POL.ITEM_DESCRIPTION
, POL.UNIT_MEAS_LOOKUP_CODE
, PLL.PRICE_OVERRIDE
, PLL.QUANTITY
, PLL.QUANTITY_CANCELLED
, PLL.QUANTITY_RECEIVED
, PLL.QUANTITY_BILLED
, HR.LOCATION_CODE
, POD.QUANTITY_ORDERED
, POD.QUANTITY_CANCELLED
, POR.ORG_ID
FROM PER_PEOPLE_F PPF
, PO_VENDORS POV
, HR_LOCATIONS HR
, PO_DISTRIBUTIONS_ALL POD
, PO_LINE_LOCATIONS_ALL PLL
, PO_LINES_ALL POL
, PO_RELEASES POR
, PO_HEADERS_ALL POH
WHERE NVL(POR.APPROVED_FLAG
, 'N') = 'Y'
AND POH.PO_HEADER_ID = POL.PO_HEADER_ID
AND POR.PO_HEADER_ID = POH.PO_HEADER_ID
AND PLL.PO_RELEASE_ID = POR.PO_RELEASE_ID
AND POR.AGENT_ID = PPF.PERSON_ID
AND POV.VENDOR_ID = POH.VENDOR_ID
AND POH.TYPE_LOOKUP_CODE = 'BLANKET'
AND POL.PO_LINE_ID = PLL.PO_LINE_ID
AND PLL.SHIP_TO_LOCATION_ID = HR.LOCATION_ID
AND PLL.LINE_LOCATION_ID = POD.LINE_LOCATION_ID