ZSF_FCST_PRODUCT

Details

Schema: FUSION
Object owner: ZSF
Object type: VIEW

Columns

Name
FCST_PRODUCT_ID PARENT_FCST_PRODUCT_ID FCST_METRICS_PRODUCT_ID ENTITY_TYPE UNSPECIFIED_FLAG SNAPSHOT_VERSION_ID PROD_HIERARCHY_LEVEL INVENTORY_ITEM_ID INV_ORG_ID PRODUCT_GROUP_ID START_DATE END_DATE CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CONFLICT_ID OBJECT_VERSION_NUMBER USER_LAST_UPDATE_DATE

Name

FCST_PRODUCT_ID

PARENT_FCST_PRODUCT_ID

FCST_METRICS_PRODUCT_ID

ENTITY_TYPE

UNSPECIFIED_FLAG

SNAPSHOT_VERSION_ID

PROD_HIERARCHY_LEVEL

INVENTORY_ITEM_ID

INV_ORG_ID

PRODUCT_GROUP_ID

START_DATE

END_DATE

CREATED_BY

CREATION_DATE

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

CONFLICT_ID

OBJECT_VERSION_NUMBER

USER_LAST_UPDATE_DATE

Query

SQL_Statement
SELECT "FCST_PRODUCT_ID","PARENT_FCST_PRODUCT_ID",DECODE(UNSPECIFIED_FLAG, 'N',FCST_PRODUCT_ID,PARENT_FCST_PRODUCT_ID) "FCST_METRICS_PRODUCT_ID","ENTITY_TYPE","UNSPECIFIED_FLAG","SNAPSHOT_VERSION_ID","PROD_HIERARCHY_LEVEL","INVENTORY_ITEM_ID","INV_ORG_ID","PRODUCT_GROUP_ID","START_DATE","END_DATE","CREATED_BY","CREATION_DATE","LAST_UPDATE_DATE","LAST_UPDATED_BY","LAST_UPDATE_LOGIN","CONFLICT_ID","OBJECT_VERSION_NUMBER","USER_LAST_UPDATE_DATE" FROM ZSF_FCST_PRODUCT

SQL_Statement

SELECT "FCST_PRODUCT_ID","PARENT_FCST_PRODUCT_ID",DECODE(UNSPECIFIED_FLAG, 'N',FCST_PRODUCT_ID,PARENT_FCST_PRODUCT_ID) "FCST_METRICS_PRODUCT_ID","ENTITY_TYPE","UNSPECIFIED_FLAG","SNAPSHOT_VERSION_ID","PROD_HIERARCHY_LEVEL","INVENTORY_ITEM_ID","INV_ORG_ID","PRODUCT_GROUP_ID","START_DATE","END_DATE","CREATED_BY","CREATION_DATE","LAST_UPDATE_DATE","LAST_UPDATED_BY","LAST_UPDATE_LOGIN","CONFLICT_ID","OBJECT_VERSION_NUMBER","USER_LAST_UPDATE_DATE"

FROM ZSF_FCST_PRODUCT