FND Design Data [Home] [Help]

View: ITG_CREQ_LINES_V

Product: ITG - Internet Procurement Enterprise Connector
Description: Lines view for Cancel Requisition XML
Implementation/DBA Data: ViewAPPS.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