[Home] [Help]
VIEW: APPS.ITG_CPO_REL_HEADERS_V
Source
View Text - Preformatted
SELECT pra.po_header_id, pra.po_release_id, pha.segment1 poid, pha.org_id sitelevel_1, pra.release_num porelease FROM po_releases_all pra, po_headers_all pha WHERE pra.po_header_id = pha.po_header_id
View Text - HTML Formatted
SELECT PRA.PO_HEADER_ID
, PRA.PO_RELEASE_ID
, PHA.SEGMENT1 POID
, PHA.ORG_ID SITELEVEL_1
, PRA.RELEASE_NUM PORELEASE
FROM PO_RELEASES_ALL PRA
, PO_HEADERS_ALL PHA
WHERE PRA.PO_HEADER_ID = PHA.PO_HEADER_ID