View: CSP_ORDERS_DUE_V

Product:	CSP - Spares Management
Description:	Returns tasks that need to be assigned today.
Implementation/DBA Data:	APPS.CSP_ORDERS_DUE_V

View Text

SELECT CRH.TASK_ID
, CRH.TASK_ASSIGNMENT_ID
, OOLA.SCHEDULE_SHIP_DATE
FROM CSP_REQUIREMENT_HEADERS CRH
, CSP_REQUIREMENT_LINES CRL
, CSP_REQ_LINE_DETAILS CRLD
, OE_ORDER_LINES_ALL OOLA
WHERE CRL.REQUIREMENT_HEADER_ID = CRH.REQUIREMENT_HEADER_ID AND CRLD.REQUIREMENT_LINE_ID = CRL.REQUIREMENT_LINE_ID AND CRLD.SOURCE_TYPE = 'IO' AND OOLA.LINE_ID = CRLD.SOURCE_ID

Columns