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