MSC_AP_WD_COMP_SUB_CONFIG_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
SUB_MATERIAL_ID ORGANIZATION_CODE ORGANIZATION_ID SUBSTITUTE_ITEM_QUANTITY PRIORITY_RANKING SUB_ITEM_NAME ASSEMBLY_NAME EFFECTIVITY_DATE WORK_DEFINITION_CODE OPERATION_SEQ_NUMBER COMPONENT_NAME ROUNDING_DIRECTION

Query

SQL_Statement

SELECT /*+ leading (subs comps) */ subs.sub_material_id, comps.organization_code, subs.organization_id, 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, SUBCOMP.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_WORK_DEFINITIONS WD, WIS_WD_OPERATION_MATERIALS MTL, EGP_SUBSTITUTE_COMPONENTS SUBCOMP 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 NVL(WD.SYSTEM_GENERATED_FLAG,'N')='N' AND WD.WORK_DEFINITION_ID = comps.WORK_DEFINITION_ID AND MTL.WD_OPERATION_MATERIAL_ID = subs.WD_OPERATION_MATERIAL_ID AND SUBCOMP.COMPONENT_SEQUENCE_ID = subs.SUB_COMPONENT_SEQUENCE_ID AND SUBCOMP.SUBSTITUTE_COMPONENT_ID = subs.SUB_COMPONENT_ID AND ((SUBCOMP.ACD_TYPE != 3 AND MTL.COMPONENT_SEQUENCE_ID_PATH IS NOT NULL) OR MTL.COMPONENT_SEQUENCE_ID_PATH IS NULL)