CST_ACCTD_ATTR_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 BUSINESS_UNIT_ID INVENTORY_ORG_ID SUBINVENTORY_CODE LOCATOR_ID PROJECT_ID TASK_ID COUNTRY_OF_ORIGIN_CODE VAL_STRUCTURE_TYPE_CODE SNAPSHOT_DATE UOM_CODE CURRENCY_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 NUMBER(18)) business_unit_id, 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, cast(NULL as VARCHAR2(30)) val_structure_type_code, cast(NULL as DATE) snapshot_date, cast(NULL as VARCHAR2(3)) uom_code, cast(NULL as VARCHAR2(30)) currency_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_ATTR_VALUES_V WHERE 1=2 |