CST_COSTED_ATTR_ONHAND_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
COST_ORG_ID COST_BOOK_ID VAL_UNIT_ID INVENTORY_ITEM_ID SNAPSHOT_DATE EFF_TO_DATE QUANTITY VU_QUANTITY CTLQUANTITY INVENTORY_ORG_ID SUBINVENTORY_CODE LOCATOR_ID PROJECT_ID TASK_ID COUNTRY_OF_ORIGIN_CODE

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)) VAL_UNIT_ID, cast(NULL as NUMBER(18)) INVENTORY_ITEM_ID, cast(NULL as DATE) SNAPSHOT_DATE, cast(NULL as DATE) EFF_TO_DATE, cast(NULL as NUMBER) QUANTITY, cast(NULL as NUMBER) VU_QUANTITY, cast(NULL as NUMBER) CTLQUANTITY, cast(NULL as NUMBER(18)) INVENTORY_ORG_ID, cast(NULL as VARCHAR2(10)) SUBINVENTORY_CODE, cast(NULL as NUMBER(18)) LOCATOR_ID, cast(NULL as NUMBER(18)) PROJECT_ID, cast(NULL as NUMBER(18)) TASK_ID, cast(NULL as VARCHAR2(2)) COUNTRY_OF_ORIGIN_CODE FROM CST_B_COSTED_ATTR_ONHAND_V WHERE 1=2