View: CSP_ARRIVAL_DATES_V

Product:	CSP - Spares Management
Description:	This view shows the estimated arrival date for a required part.
Implementation/DBA Data:	APPS.CSP_ARRIVAL_DATES_V

View Text

SELECT CRH.TASK_ID
, CRH.TASK_ASSIGNMENT_ID
, MAX(NVL(CRL.ARRIVAL_DATE
, CRL.CREATION_DATE)) FROM CSP_REQUIREMENT_HEADERS CRH
, CSP_REQUIREMENT_LINES CRL WHERE CRH.REQUIREMENT_HEADER_ID = CRL.REQUIREMENT_HEADER_ID GROUP BY CRH.TASK_ID
, CRH.TASK_ASSIGNMENT_ID

Columns