[Home] [Help]
View: MRP_SRS_FCST_LOAD_SOURCE_V
View Text
SELECT ORGANIZATION_ID
, 5
, SELECTION_LIST_NAME
, DESCRIPTION
, NULL
FROM MRP_LOAD_SELECTIONS
WHERE SELECTION_LIST_TYPE = 2 UNION ALL SELECT ORGANIZATION_ID
, 2
, FORECAST_DESIGNATOR
, DESCRIPTION
, NULL
FROM MRP_FORECAST_DESIGNATORS
WHERE NVL(DISABLE_DATE
, TRUNC(SYSDATE)+1) > TRUNC(SYSDATE)
Columns
Name |
ORGANIZATION_ID |
SOURCE_TYPE |
NAME |
DESCRIPTION |
DESIGNATOR_TYPE |