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