FND Design Data [Home] [Help]

View: ITG_CPO_REL_LINES_V

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

SELECT PLA.PO_LINE_ID
, PLA.PO_HEADER_ID
, PRA.PO_RELEASE_ID
, PLA.LINE_NUM POLINENUM
FROM PO_LINES_ALL PLA
, PO_RELEASES_ALL PRA
WHERE PRA.PO_HEADER_ID = PLA.PO_HEADER_ID

Columns

Name
PO_LINE_ID
PO_HEADER_ID
PO_RELEASE_ID
POLINENUM