[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: |
APPS.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 |