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