機械翻訳について

CST_COSTED_ATTR_COSTS_V

詳細

• スキーマ: FUSION

• オブジェクト所有者: CST

• オブジェクト・タイプ: VIEW

列

名前
COST_ORG_ID COST_BOOK_ID INVENTORY_ITEM_ID VAL_UNIT_ID INVENTORY_ORG_ID SUBINVENTORY_CODE LOCATOR_ID PROJECT_ID TASK_ID COUNTRY_OF_ORIGIN_CODE COST_ELEMENT_ID SNAPSHOT_DATE EFF_TO_DATE ONHAND_VALUE UNIT_COST CURRENCY_CODE UOM_CODE COST_METHOD_CODE PERIOD_NAME

問合せ

SQL_Statement

SELECT cost_org_id, cost_book_id, inventory_item_id, val_unit_id, inventory_org_id, subinventory_code, locator_id, project_id, task_id, country_of_origin_code, cost_element_id, snapshot_date, eff_to_date, onhand_value, unit_cost, currency_code, uom_code, cost_method_code, cast(null as varchar2(15)) period_name FROM CST_COSTED_ATTR_COSTS_MV UNION ALL SELECT cpac.cost_org_id, cpac.cost_book_id, cpac.inventory_item_id, cpac.val_unit_id, cast(-1 as number) inventory_org_id, cast(' 'as varchar2(10)) subinventory_code, cast(-1 as number) locator_id, cast(-1 as number) project_id, cast(-1 as number) task_id, cast(' ' AS VARCHAR2(2)) country_of_origin_code, cpac.cost_element_id, cps.start_date snapshot_date, decode(cps.status_code,'O',to_date('4712-12-31', 'yyyy-mm-dd') ,cps.end_date + INTERVAL '1' DAY) eff_to_date, cast(0 AS NUMBER) onhand_value, cpac.periodic_avg_cost unit_cost, cpac.currency_code, cpac.uom_code, cast('PERIODIC_AVERAGE' AS VARCHAR2(30)) cost_method_code, cpac.period_name FROM cst_periodic_avg_costs cpac, cst_period_statuses cps WHERE cpac.cost_org_id = cps.cost_org_id AND cpac.cost_book_id = cps.cost_book_id AND cpac.period_name = cps.period_name