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