CST_COSTED_VU_ALL_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 STATUS_CODE PERIOD_NAME STD_COST_SOURCE

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(30)) status_code, CAST(NULL AS VARCHAR2(15)) period_name, CAST(NULL AS VARCHAR2(30)) std_cost_source FROM CST_B_COSTED_VU_COSTS_V WHERE 1=2