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