DBA Data[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