CST_COSTED_VU_COSTS_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
COST_ORG_ID COST_BOOK_ID INVENTORY_ITEM_ID VAL_UNIT_ID EXPENSE_POOL_ID COST_ELEMENT_ID SNAPSHOT_DATE EFF_TO_DATE ONHAND_VALUE UNIT_COST CURRENCY_CODE UOM_CODE COST_METHOD_CODE SCENARIO_ID PERIOD_NAME

Query

SQL_Statement

SELECT cast(NULL as NUMBER(18)) COST_ORG_ID, cast(NULL as NUMBER(18)) COST_BOOK_ID, cast(NULL as NUMBER(18)) INVENTORY_ITEM_ID, cast(NULL as NUMBER(18)) VAL_UNIT_ID, cast(NULL as NUMBER) EXPENSE_POOL_ID, cast(NULL as NUMBER(18)) COST_ELEMENT_ID, cast(NULL as DATE) SNAPSHOT_DATE, cast(NULL as DATE) EFF_TO_DATE, cast(NULL as NUMBER) ONHAND_VALUE, cast(NULL as NUMBER) UNIT_COST, cast(NULL as VARCHAR2(30)) CURRENCY_CODE, cast(NULL as VARCHAR2(30)) UOM_CODE, cast(NULL as VARCHAR2(30)) COST_METHOD_CODE, cast(NULL as NUMBER(18)) SCENARIO_ID, CAST(NULL AS VARCHAR2(15)) PERIOD_NAME FROM CST_B_COSTED_VU_COSTS_V WHERE 1=2