FND Design Data [Home] [Help]

View: ITG_CPO_REL_HEADERS_V

Product: ITG - Internet Procurement Enterprise Connector
Description: PO RELEASE header view for CANCEL PO 006
Implementation/DBA Data: ViewAPPS.ITG_CPO_REL_HEADERS_V
View Text

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

Columns

Name
PO_HEADER_ID
PO_RELEASE_ID
POID
SITELEVEL_1
PORELEASE