VIEW: APPS.ITG_SP_REL_HEADERS_V

Source

View Text - Preformatted

SELECT pha.po_header_id, pra.po_release_id, pra.approved_date datetime_document, itg_x_utils.sumPoLineLocs(pha.po_header_id, pra.po_release_id) operamt_extended, pha.currency_code operamt_currency, pha.segment1 poid, per.full_name buyerid, Loc.location_code deliverto, pha.comments notes, TO_CHAR(pra.org_id) poentity, pra.release_num porelease, pra.authorization_status postatus, pha.type_lookup_code potype, NULL taxwhexmpt, NULL to_po_internal, NULL to_misc, NULL to_approver, NULL to_buyer, NULL to_payables, NULL to_receiver, NULL to_supplier FROM per_people_f per, hr_locations_all loc, po_headers_all pha, po_releases_all pra WHERE per.person_id (+) = pha.agent_id AND loc.location_id (+) = pha.ship_to_location_id AND pra.po_header_id = pha.po_header_id AND nvl(per.effective_end_date, sysdate+1) > sysdate

View Text - HTML Formatted

SELECT PHA.PO_HEADER_ID
, PRA.PO_RELEASE_ID
, PRA.APPROVED_DATE DATETIME_DOCUMENT
, ITG_X_UTILS.SUMPOLINELOCS(PHA.PO_HEADER_ID
, PRA.PO_RELEASE_ID) OPERAMT_EXTENDED
, PHA.CURRENCY_CODE OPERAMT_CURRENCY
, PHA.SEGMENT1 POID
, PER.FULL_NAME BUYERID
, LOC.LOCATION_CODE DELIVERTO
, PHA.COMMENTS NOTES
, TO_CHAR(PRA.ORG_ID) POENTITY
, PRA.RELEASE_NUM PORELEASE
, PRA.AUTHORIZATION_STATUS POSTATUS
, PHA.TYPE_LOOKUP_CODE POTYPE
, NULL TAXWHEXMPT
, NULL TO_PO_INTERNAL
, NULL TO_MISC
, NULL TO_APPROVER
, NULL TO_BUYER
, NULL TO_PAYABLES
, NULL TO_RECEIVER
, NULL TO_SUPPLIER
FROM PER_PEOPLE_F PER
, HR_LOCATIONS_ALL LOC
, PO_HEADERS_ALL PHA
, PO_RELEASES_ALL PRA
WHERE PER.PERSON_ID (+) = PHA.AGENT_ID
AND LOC.LOCATION_ID (+) = PHA.SHIP_TO_LOCATION_ID
AND PRA.PO_HEADER_ID = PHA.PO_HEADER_ID
AND NVL(PER.EFFECTIVE_END_DATE
, SYSDATE+1) > SYSDATE