[Home] [Help]
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
Name |
TASK_ID |
TASK_ASSIGNMENT_ID |
LATEST_ARRIVAL_DATE |