機械翻訳について

CST_COSTED_VU_ALL_COSTS_V

詳細

• スキーマ: FUSION

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

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

列

名前
COST_ORG_ID COST_BOOK_ID INVENTORY_ITEM_ID VAL_UNIT_ID EXPENSE_POOL_ID COST_ELEMENT_ID SNAPSHOT_DATE EFF_TO_DATE ONHAND_VALUE UNIT_COST CURRENCY_CODE UOM_CODE COST_METHOD_CODE SCENARIO_ID STATUS_CODE PERIOD_NAME STD_COST_SOURCE

問合せ

SQL_Statement

SELECT cost_org_id, cost_book_id, inventory_item_id, val_unit_id, expense_pool_id, cost_element_id, snapshot_date, eff_to_date, onhand_value, unit_cost, currency_code, uom_code, cost_method_code, scenario_id, status_code, CAST(NULL AS VARCHAR2(15)) period_name, CAST(NULL AS VARCHAR2(30)) std_cost_source FROM cst_costed_vu_costs_mv UNION ALL SELECT sc.cost_org_id, sc.cost_book_id, sc.inventory_item_id, sc.val_unit_id, scd.expense_pool_id, scd.cost_element_id, sc.effective_start_date snapshot_date, decode(sc.effective_end_date, TO_DATE('4712-12-31', 'yyyy-mm-dd'), sc.effective_end_date, sc.effective_end_date + INTERVAL '1' DAY) eff_to_date, 0 onhand_value, SUM(scd.unit_cost) unit_cost, sc.currency_code, sc.uom_code, CAST('STANDARD' AS VARCHAR2(30)) cost_method_code, sc.scenario_id, sc.status_code, CAST(NULL AS VARCHAR2(15)) period_name, sc.std_cost_source FROM cst_std_costs_v sc, cst_std_cost_details scd, cst_cost_profiles_b cp WHERE sc.assignment_level = 'VALUATION_UNIT' AND sc.val_unit_id IS NOT NULL AND sc.cost_profile_id = cp.cost_profile_id AND sc.std_cost_id = scd.std_cost_id AND cp.cost_method_code = 'STANDARD' GROUP BY sc.cost_org_id, sc.cost_book_id, sc.inventory_item_id, sc.val_unit_id, scd.expense_pool_id, scd.cost_element_id, sc.effective_start_date, decode(sc.effective_end_date, TO_DATE('4712-12-31', 'yyyy-mm-dd'), sc.effective_end_date, sc.effective_end_date + INTERVAL '1' DAY), sc.currency_code, sc.uom_code, sc.scenario_id, sc.status_code, sc.std_cost_source UNION ALL SELECT cpac.cost_org_id, cpac.cost_book_id, cpac.inventory_item_id, cpac.val_unit_id, CAST(0 AS NUMBER) expense_pool_id, 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, CAST(NULL AS NUMBER(18, 0)) scenario_id, CAST(NULL AS VARCHAR2(30)) status_code, cpac.period_name, CAST(NULL AS VARCHAR2(30)) std_cost_source FROM cst_periodic_avg_costs cpac, cst_period_statuses cps WHERE cps.cost_org_id = cpac.cost_org_id AND cps.cost_book_id = cpac.cost_book_id AND cps.period_name = cpac.period_name