機械翻訳について

MSC_AP_WD_COMP_SUB_CONFIG_V

詳細

• スキーマ: FUSION

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

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

列

名前
SUB_MATERIAL_ID ORGANIZATION_CODE SUBSTITUTE_ITEM_QUANTITY PRIORITY_RANKING SUB_ITEM_NAME ASSEMBLY_NAME EFFECTIVITY_DATE WORK_DEFINITION_CODE OPERATION_SEQ_NUMBER COMPONENT_NAME ROUNDING_DIRECTION

問合せ

SQL_Statement

SELECT subs.sub_material_id, comps.organization_code, subs.substitute_item_quantity, subs.priority_ranking, esi.item_number sub_item_name, comps.assembly_name, comps.effective_from_date effectivity_date, comps.work_definition_code, comps.operation_seq_number, comps.component_name, submat.enforce_int_requirements rounding_direction FROM msc_api_wd_comp_substitutes subs, msc_ap_wd_op_mat_config_v comps , msc_planned_egp_system_items esi, wis_wd_op_sub_materials_v submat WHERE subs.config_item_id = comps.config_item_id AND subs.organization_id = comps.organization_id AND subs.wd_operation_material_id = comps.wd_operation_material_id AND esi.organization_id = subs.organization_id AND esi.inventory_item_id = subs.sub_component_id AND submat.sub_material_id = subs.sub_material_id