[Home] [Help]
View: ITG_CREQ_LINES_V
| Product: | ITG - Internet Procurement Enterprise Connector |
| Description: | Lines view for Cancel Requisition XML |
| Implementation/DBA Data: |
APPS.ITG_CREQ_LINES_V
|
View Text
SELECT PRLA.REQUISITION_HEADER_ID
, PRLA.REQUISITION_LINE_ID
, PRLA.LINE_NUM REQLINENUM
, PRHA.SEGMENT1
, PRHA.ORG_ID
FROM PO_REQUISITION_HEADERS_ALL PRHA
, PO_REQUISITION_LINES_ALL PRLA
WHERE PRHA.REQUISITION_HEADER_ID = PRLA.REQUISITION_HEADER_ID
Columns
| Name |
| REQUISITION_HEADER_ID |
| REQUISITION_LINE_ID |
| REQLINENUM |
| SEGMENT1 |
| ORG_ID |