[Home] [Help]
View: IEU_UWQ_FORECAST_V
Product: | IEU - Universal Work Queue |
Description: | View used for UWQ selector SpreadTable. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT B.OBJECT_FUNCTION IEU_OBJECT_FUNCTION
, B.OBJECT_PARAMETERS IEU_OBJECT_PARAMETERS
, '' IEU_MEDIA_TYPE_UUID
, 'FORECAST_ID' IEU_PARAM_PK_COL
, TO_CHAR(A.FORECAST_ID) IEU_PARAM_PK_VALUE
, A.PERIOD_NAME
, A.STATUS_CODE
, A.RESOURCE_GROUP_ID
, A.FORECAST_AMOUNT
, A.BEST_FORECAST_AMOUNT
, A.WORST_FORECAST_AMOUNT
, A.RESOURCE_ID
, A.RESOURCE_TYPE
FROM AS_SALES_FORECAST_UWQ_V A
, JTF_OBJECTS_VL B
WHERE B.OBJECT_CODE = A.OBJECT_CODE
Columns
Name |
IEU_OBJECT_FUNCTION |
IEU_OBJECT_PARAMETERS |
IEU_MEDIA_TYPE_UUID |
IEU_PARAM_PK_COL |
IEU_PARAM_PK_VALUE |
PERIOD_NAME |
STATUS_CODE |
RESOURCE_GROUP_ID |
FORECAST_AMOUNT |
BEST_FORECAST_AMOUNT |
WORST_FORECAST_AMOUNT |
RESOURCE_ID |
RESOURCE_TYPE |