CST_ACCTD_VU_VALUES_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
COST_ORG_ID COST_BOOK_ID INVENTORY_ITEM_ID VAL_UNIT_ID SNAPSHOT_DATE UOM_CODE EFF_TO_DATE COSTED_VALUE ACCOUNTED_VALUE UNACCOUNTED_VALUE EXCLUDED_FROM_ACCTG_VALUE

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 DATE) SNAPSHOT_DATE, cast(NULL as VARCHAR2(25)) UOM_CODE, cast(NULL as DATE) EFF_TO_DATE, cast(NULL as NUMBER) COSTED_VALUE, cast(NULL as NUMBER) ACCOUNTED_VALUE, cast(NULL as NUMBER) UNACCOUNTED_VALUE, cast(NULL as NUMBER) EXCLUDED_FROM_ACCTG_VALUE FROM CST_B_ACCTD_VU_VALUES_V WHERE 1=2