VIEW: APPS.PO_HEADERS_VIEW

Source

View Text - Preformatted

SELECT poh.po_header_id, to_number(''), poh.segment1, poh.revision_num, poh.type_lookup_code, poh.approved_flag, poh.approved_date, poh.acceptance_required_flag, poh.acceptance_due_date, to_number(''), poh.vendor_id, poh.vendor_site_id, poh.agent_id, poh.start_date, poh.end_date, poh.last_update_date, poh.last_updated_by, poh.last_update_login, poh.creation_date, poh.created_by, poh.org_id FROM PO_HEADERS POH WHERE nvl(poh.closed_code,'OPEN') != 'FINALLY CLOSED' AND poh.approved_date is not null AND poh.type_lookup_code IN ('STANDARD','BLANKET','CONTRACT', 'PLANNED') UNION SELECT por.po_header_id, por.po_release_id, poh.segment1, por.revision_num, poh.type_lookup_code, por.approved_flag, por.approved_date, por.acceptance_required_flag, por.acceptance_due_date, por.release_num, poh.vendor_id, poh.vendor_site_id, por.agent_id, poh.start_date, poh.end_date, por.last_update_date, por.last_updated_by, por.last_update_login, por.creation_date, por.created_by, por.org_id FROM po_releases por, po_headers_all poh WHERE poh.po_header_id = por.po_header_id AND por.approved_date is not null AND nvl(poh.closed_code,'OPEN') != 'FINALLY CLOSED' AND poh.type_lookup_code IN ('BLANKET','PLANNED')

View Text - HTML Formatted

SELECT POH.PO_HEADER_ID
, TO_NUMBER('')
, POH.SEGMENT1
, POH.REVISION_NUM
, POH.TYPE_LOOKUP_CODE
, POH.APPROVED_FLAG
, POH.APPROVED_DATE
, POH.ACCEPTANCE_REQUIRED_FLAG
, POH.ACCEPTANCE_DUE_DATE
, TO_NUMBER('')
, POH.VENDOR_ID
, POH.VENDOR_SITE_ID
, POH.AGENT_ID
, POH.START_DATE
, POH.END_DATE
, POH.LAST_UPDATE_DATE
, POH.LAST_UPDATED_BY
, POH.LAST_UPDATE_LOGIN
, POH.CREATION_DATE
, POH.CREATED_BY
, POH.ORG_ID
FROM PO_HEADERS POH
WHERE NVL(POH.CLOSED_CODE
, 'OPEN') != 'FINALLY CLOSED'
AND POH.APPROVED_DATE IS NOT NULL
AND POH.TYPE_LOOKUP_CODE IN ('STANDARD'
, 'BLANKET'
, 'CONTRACT'
, 'PLANNED') UNION SELECT POR.PO_HEADER_ID
, POR.PO_RELEASE_ID
, POH.SEGMENT1
, POR.REVISION_NUM
, POH.TYPE_LOOKUP_CODE
, POR.APPROVED_FLAG
, POR.APPROVED_DATE
, POR.ACCEPTANCE_REQUIRED_FLAG
, POR.ACCEPTANCE_DUE_DATE
, POR.RELEASE_NUM
, POH.VENDOR_ID
, POH.VENDOR_SITE_ID
, POR.AGENT_ID
, POH.START_DATE
, POH.END_DATE
, POR.LAST_UPDATE_DATE
, POR.LAST_UPDATED_BY
, POR.LAST_UPDATE_LOGIN
, POR.CREATION_DATE
, POR.CREATED_BY
, POR.ORG_ID
FROM PO_RELEASES POR
, PO_HEADERS_ALL POH
WHERE POH.PO_HEADER_ID = POR.PO_HEADER_ID
AND POR.APPROVED_DATE IS NOT NULL
AND NVL(POH.CLOSED_CODE
, 'OPEN') != 'FINALLY CLOSED'
AND POH.TYPE_LOOKUP_CODE IN ('BLANKET'
, 'PLANNED')