EGP_INTF_EXPLOSIONS_V
Details
-
Schema: FUSION
-
Object owner: EGP
-
Object type: VIEW
Columns
Name |
---|
TOP_ITEM_NUMBER TOP_ITEM_ID TOP_BILL_SEQUENCE_ID BILL_SEQUENCE_ID COMPONENT_SEQUENCE_ID PLAN_LEVEL CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ATTRIBUTE21 ATTRIBUTE22 ATTRIBUTE23 ATTRIBUTE24 ATTRIBUTE25 ATTRIBUTE26 ATTRIBUTE27 ATTRIBUTE28 ATTRIBUTE29 ATTRIBUTE30 BASIS_TYPE COMPONENT_QUANTITY SO_BASIS OPTIONAL MUTUALLY_EXCLUSIVE_OPTIONS CHECK_ATP SHIPPING_ALLOWED REQUIRED_TO_SHIP REQUIRED_FOR_REVENUE INCLUDE_ON_SHIP_DOCS INCLUDE_ON_BILL_DOCS LOW_QUANTITY HIGH_QUANTITY PICK_COMPONENTS PRIMARY_UOM_CODE COMPONENT_PRIMARY_UOM_CODE PRIMARY_UNIT_OF_MEASURE BASE_ITEM_ID ATP_COMPONENTS_FLAG ATP_FLAG BOM_ITEM_TYPE PICK_COMPONENTS_FLAG REPLENISH_TO_ORDER_FLAG SHIPPABLE_ITEM_FLAG CUSTOMER_ORDER_FLAG INTERNAL_ORDER_FLAG CUSTOMER_ORDER_ENABLED_FLAG INTERNAL_ORDER_ENABLED_FLAG SO_TRANSACTIONS_FLAG DESCRIPTION COMPONENT_PATH PARENT_BOM_ITEM_TYPE OPERATION_SEQ_NUM ITEM_NUM EFFECTIVITY_DATE DISABLE_DATE IMPLEMENTATION_DATE COMMON_BILL_SEQUENCE_ID SOURCE_BILL_SEQUENCE_ID AUTO_REQUEST_MATERIAL ITEM_NAME ITEM_STATUS ALTERNATE_BOM_DESIGNATOR ALTERNATE_DESIGNATOR_ID REVISION_LABEL COMPONENT_YIELD_FACTOR PLANNING_FACTOR USER_ITEM_TYPE CHANGE_ID LONG_DESCRIPTION REVISION PK1_VALUE PK2_VALUE PK3_VALUE PK4_VALUE PK5_VALUE PARENT_PK1_VALUE PARENT_PK2_VALUE PARENT_PK3_VALUE PARENT_PK4_VALUE PARENT_PK5_VALUE OBJ_NAME PARENT_OBJ_NAME ITEM_CATALOG_GROUP_ID REVISION_ID FROM_END_ITEM_REV_ID TO_END_ITEM_REV_ID FROM_END_ITEM_REVISION_LABEL TO_END_ITEM_REVISION_LABEL EFFECTIVITY_CONTROL ACD_TYPE QUANTITY_RELATED SUPPLY_SUBINVENTORY COMPONENT_REMARKS WIP_SUPPLY_TYPE LOCATOR COMP_FIXED_REV_CODE COMMON_COMPONENT_SEQUENCE_ID INVERSE_QUANTITY PARENT_EFFECTIVITY_CONTROL REVISED_ITEM_SEQUENCE_ID FROM_END_ITEM_REVISION_CODE TO_END_ITEM_REVISION_CODE ENFORCE_INT_REQUIREMENTS STRUCTURE_DESC STYLE_ITEM_ID STYLE_ITEM_FLAG EXPL_PLAN_LEVEL LINK_BY_BILL_SEQ EXPL_PLAN_LEVEL_1 SOURCE_SYSTEM_REFERENCE COMP_SOURCE_SYSTEM_REFERENCE PARENT_SOURCE_SYSTEM_REFERENCE ITEM_NUMBER COMPONENT_ITEM_NUMBER ASSEMBLY_ITEM_NUMBER TRANSACTION_TYPE CONFIRM_STATUS TRANSACTION_ID SHOW_IN_SALES |
Query
SQL_Statement |
---|
SELECT Nvl(Sys_context('INTF_EXPL_CTX', 'ITEM_NUMBER'), Sys_context('INTF_EXPL_CTX', 'SS_REF')) top_item_number, b.pk1_value top_item_id, bill_sequence_id top_bill_sequence_id, bill_sequence_id bill_sequence_id, NULL component_sequence_id, 0 plan_level, b.creation_date, b.created_by, b.last_update_date, b.last_updated_by, b.attribute_category, b.attribute1, b.attribute2, b.attribute3, b.attribute4, b.attribute5, b.attribute6, b.attribute7, b.attribute8, b.attribute9, b.attribute10, b.attribute11, b.attribute12, b.attribute13, b.attribute14, b.attribute15, NULL attribute16, NULL attribute17, NULL attribute18, NULL attribute19, NULL attribute20, NULL attribute21, NULL attribute22, NULL attribute23, NULL attribute24, NULL attribute25, NULL attribute26, NULL attribute27, NULL attribute28, NULL attribute29, NULL attribute30, NULL basis_type, NULL component_quantity, NULL so_basis, NULL optional, NULL mutually_exclusive_options, NULL check_atp, NULL shipping_allowed, NULL required_to_ship, NULL required_for_revenue, NULL include_on_ship_docs, NULL include_on_bill_docs, NULL low_quantity, NULL high_quantity, NULL pick_components, NULL primary_uom_code, NULL component_primary_uom_code, NULL primary_unit_of_measure, NULL base_item_id, NULL atp_components_flag, NULL atp_flag, NULL bom_item_type, NULL pick_components_flag, NULL replenish_to_order_flag, NULL shippable_item_flag, NULL customer_order_flag, NULL internal_order_flag, NULL customer_order_enabled_flag, NULL internal_order_enabled_flag, NULL so_transactions_flag, NULL description, NULL component_path, NULL parent_bom_item_type, NULL operation_seq_num, NULL item_num, NULL effectivity_date, NULL disable_date, NULL implementation_date, common_bill_sequence_id, source_bill_sequence_id, NULL auto_request_material, b.item_number item_name, NULL item_status, alternate_bom_designator, NULL alternate_designator_id, b.revision revision_label, NULL component_yield_factor, NULL planning_factor, NULL user_item_type, b.change_id, NULL long_description, b.revision, b.pk1_value, b.pk2_value, b.pk3_value, b.pk4_value, b.pk5_value, NULL parent_pk1_value, NULL parent_pk2_value, NULL parent_pk3_value, NULL parent_pk4_value, NULL parent_pk5_value, obj_name, NULL parent_obj_name, NULL item_catalog_group_id, NULL revision_id, NULL from_end_item_rev_id, NULL to_end_item_rev_id, NULL from_end_item_revision_label, NULL to_end_item_revision_label, b.effectivity_control, NULL acd_type, NULL quantity_related, NULL supply_subinventory, NULL component_remarks, NULL wip_supply_type, NULL locator, NULL comp_fixed_rev_code, NULL common_component_sequence_id, NULL inverse_quantity, NULL parent_effectivity_control, NULL revised_item_sequence_id, NULL from_end_item_revision_code, NULL to_end_item_revision_code, NULL enforce_int_requirements, NULL structure_desc, NULL style_item_id, NULL style_item_flag, NULL expl_plan_level, NULL link_by_bill_seq, NULL expl_plan_level_1, b.source_system_reference, NULL comp_source_system_reference, NULL parent_source_system_reference, Sys_context('INTF_EXPL_CTX', 'ITEM_NUMBER') item_number, NULL component_item_number, NULL assembly_item_number, b.transaction_type, DECODE(b.process_status,1,'CN','UN') CONFIRM_STATUS, b.transaction_id, null show_in_sales FROM egp_structures_interface b LEFT OUTER JOIN egp_system_items_interface m ON (b.organization_code = m.organization_code OR b.organization_id = m.organization_id) AND m.batch_id = b.batch_id AND (m.source_system_reference = b.source_system_reference OR m.item_number = b.item_number) AND (m.source_system_id = b.source_system_id OR (m.source_system_id IS NULL OR b.source_system_id IS NULL)) AND (m.organization_code = b.organization_code OR m.organization_id = b.organization_id) WHERE b.batch_id = Sys_context('INTF_EXPL_CTX', 'BATCH_ID') AND ( b.source_system_reference = Sys_context('INTF_EXPL_CTX', 'SS_REF') OR b.item_number = Sys_context('INTF_EXPL_CTX', 'ITEM_NUMBER') ) AND ( b.organization_code = Sys_context('INTF_EXPL_CTX', 'CTX_ORG') OR b.organization_id = Sys_context('INTF_EXPL_CTX', 'CTX_ORG_ID') ) AND ( b.alternate_bom_designator = Sys_context('INTF_EXPL_CTX', 'STR_NAME') ) AND m.process_status IN ( 0, 1 ) AND b.process_status IN ( 0, 1 ) UNION ALL SELECT Nvl(Sys_context('INTF_EXPL_CTX', 'ITEM_NUMBER'), Sys_context('INTF_EXPL_CTX', 'SS_REF')) top_item_number, hky.pk1_value top_item_id, NULL top_bill_sequence_id, hky.bill_sequence_id bill_sequence_id, hky.component_sequence_id component_sequence_id, hky.expl_plan_level plan_level, hky.creation_date, hky.created_by, hky.last_update_date, hky.last_updated_by, hky.attribute_category, hky.attribute1, hky.attribute2, hky.attribute3, hky.attribute4, hky.attribute5, hky.attribute6, hky.attribute7, hky.attribute8, hky.attribute9, hky.attribute10, hky.attribute11, hky.attribute12, hky.attribute13, hky.attribute14, hky.attribute15, NULL attribute16, NULL attribute17, NULL attribute18, NULL attribute19, NULL attribute20, NULL attribute21, NULL attribute22, NULL attribute23, NULL attribute24, NULL attribute25, NULL attribute26, NULL attribute27, NULL attribute28, NULL attribute29, NULL attribute30, NULL basis_type, hky.component_quantity, hky.so_basis, hky.optional, hky.mutually_exclusive_options, hky.check_atp, hky.shipping_allowed, hky.required_to_ship, hky.required_for_revenue, hky.include_on_ship_docs, hky.include_on_bill_docs, hky.low_quantity, hky.high_quantity, hky.pick_components, msii.primary_uom_code, hky.primary_uom_code component_primary_uom_code, NULL primary_unit_of_measure, msii.base_item_id, msii.atp_components_flag, msii.atp_flag, msii.bom_item_type, msii.pick_components_flag, msii.replenish_to_order_flag, msii.shippable_item_flag, msii.customer_order_flag, msii.internal_order_flag, msii.customer_order_enabled_flag, msii.internal_order_enabled_flag, msii.so_transactions_flag, msii.description, hky.component_path component_path, hky.parent_bom_item_type, hky.operation_seq_num, hky.item_num, hky.effectivity_date, hky.disable_date, hky.implementation_date, hky.common_bill_sequence_id, hky.source_bill_sequence_id, hky.auto_request_material, hky.component_item_number item_name, NULL item_status, hky.alternate_bom_designator, NULL alternate_designator_id, NULL revision_label, hky.component_yield_factor, hky.planning_factor, msii.item_type user_item_type, hky.change_id, msii.long_description, hky.component_revision_code revision, hky.pk1_value, hky.pk2_value, hky.pk3_value, hky.pk4_value, hky.pk5_value, hky.parent_pk1_value, hky.parent_pk2_value, hky.parent_pk3_value, hky.parent_pk4_value, hky.parent_pk5_value, hky.obj_name, hky.parent_obj_name, msii.item_catalog_group_id, NULL revision_id, hky.from_end_item_rev_id, hky.to_end_item_rev_id, NULL from_end_item_revision_label, NULL to_end_item_revision_label, hky.effectivity_control, hky.acd_type, hky.quantity_related, hky.supply_subinventory, hky.component_remarks, hky.wip_supply_type, NULL locator, NULL comp_fixed_rev_code, hky.common_component_sequence_id, DECODE(hky.component_quantity, NULL,NULL, 0,NULL, (1 / hky.component_quantity)) inverse_quantity, hky.parent_effectivity_control, hky.revised_item_sequence_id, hky.from_end_item_rev_code from_end_item_revision_code, hky.to_end_item_rev_code from_end_item_revision_code, hky.enforce_int_requirements, hky.structure_desc, msii.style_item_id, msii.style_item_flag, hky.expl_plan_level, NULL link_by_bill_seq, NULL expl_plan_level_1, NULL source_system_reference, comp_source_system_reference, parent_source_system_reference, NULL item_number, hky.component_item_number, hky.assembly_item_number, hky.transaction_type, DECODE(hky.comp_process_status,1,'CN','UN') CONFIRM_STATUS, hky.transaction_id, hky.show_in_sales FROM egp_system_items_interface msii, (SELECT comp_header.*, header.pk2_value bill_org_id, header.common_bill_sequence_id, header.source_bill_sequence_id, header.obj_name parent_obj_name, header.pk1_value parent_pk1_value, header.pk2_value parent_pk2_value, header.pk3_value parent_pk3_value, header.pk4_value parent_pk4_value, header.pk5_value parent_pk5_value, header.effectivity_control parent_effectivity_control, header.specific_assembly_comment structure_desc , PRIOR comp_header.implementation_date parent_implementation_date, PRIOR comp_header.change_id parent_change_id, PRIOR comp_header.bom_item_type parent_bom_item_type, Substr(Sys_connect_by_path(comp_header.parent_source_system_reference, '>'), 2, Length(Sys_connect_by_path(comp_header.parent_source_system_reference, '>'))) component_path, connect_by_isleaf, LEVEL expl_plan_level, connect_by_iscycle loop_flag, NULL expl_plan_level_1, header.process_status parent_process_flag, comp_header.process_status comp_process_status FROM (SELECT comps.OPERATION_SEQ_NUM, comps.COMPONENT_ITEM_ID, comps.LAST_UPDATE_DATE, comps.LAST_UPDATED_BY, comps.CREATION_DATE, comps.CREATED_BY, comps.LAST_UPDATE_LOGIN, comps.ITEM_NUM, comps.COMPONENT_QUANTITY, comps.COMPONENT_YIELD_FACTOR, comps.COMPONENT_REMARKS, comps.EFFECTIVITY_DATE, comps.CHANGE_NOTICE, comps.IMPLEMENTATION_DATE, comps.DISABLE_DATE, comps.ATTRIBUTE_CATEGORY, comps.ATTRIBUTE1, comps.ATTRIBUTE2, comps.ATTRIBUTE3, comps.ATTRIBUTE4, comps.ATTRIBUTE5, comps.ATTRIBUTE6, comps.ATTRIBUTE7, comps.ATTRIBUTE8, comps.ATTRIBUTE9, comps.ATTRIBUTE10, comps.ATTRIBUTE11, comps.ATTRIBUTE12, comps.ATTRIBUTE13, comps.ATTRIBUTE14, comps.ATTRIBUTE15, comps.ATTRIBUTE16, comps.ATTRIBUTE17, comps.ATTRIBUTE18, comps.ATTRIBUTE19, comps.ATTRIBUTE20, comps.ATTRIBUTE21, comps.ATTRIBUTE22, comps.ATTRIBUTE23, comps.ATTRIBUTE24, comps.ATTRIBUTE25, comps.ATTRIBUTE26, comps.ATTRIBUTE27, comps.ATTRIBUTE28, comps.ATTRIBUTE29, comps.ATTRIBUTE30, comps.PLANNING_FACTOR, comps.QUANTITY_RELATED, comps.SO_BASIS, comps.OPTIONAL, comps.MUTUALLY_EXCLUSIVE_OPTIONS, comps.INCLUDE_IN_COST_ROLLUP, comps.CHECK_ATP, comps.SHIPPING_ALLOWED, comps.REQUIRED_TO_SHIP, comps.REQUIRED_FOR_REVENUE, comps.INCLUDE_ON_SHIP_DOCS, comps.INCLUDE_ON_BILL_DOCS, comps.LOW_QUANTITY, comps.HIGH_QUANTITY, comps.ACD_TYPE, comps.OLD_COMPONENT_SEQUENCE_ID, comps.COMPONENT_SEQUENCE_ID, comps.BILL_SEQUENCE_ID, comps.REQUEST_ID, comps.WIP_SUPPLY_TYPE, comps.PICK_COMPONENTS, comps.SUPPLY_SUBINVENTORY, comps.SUPPLY_LOCATOR_ID, comps.OPERATION_LEAD_TIME_PERCENT, comps.REVISED_ITEM_SEQUENCE_ID, comps.MODEL_COMP_SEQ_ID, comps.ASSEMBLY_ITEM_ID, comps.ALTERNATE_BOM_DESIGNATOR, comps.ORGANIZATION_ID, comps.COST_FACTOR, comps.DDF_CONTEXT1, comps.DDF_CONTEXT2, comps.ORGANIZATION_CODE, comps.COMPONENT_ITEM_NUMBER, comps.ASSEMBLY_ITEM_NUMBER, comps.REVISED_ITEM_NUMBER, comps.LOCATION_NAME, comps.REFERENCE_DESIGNATOR, comps.SUBSTITUTE_COMP_ID, comps.SUBSTITUTE_COMP_NUMBER, comps.TRANSACTION_ID, comps.BOM_ITEM_TYPE, comps.NEW_OPERATION_SEQ_NUM, comps.OLD_OPERATION_SEQ_NUM, comps.NEW_EFFECTIVITY_DATE, comps.OLD_EFFECTIVITY_DATE, comps.ASSEMBLY_TYPE, comps.INTERFACE_ENTITY_TYPE, comps.TRANSACTION_TYPE, comps.BOM_INVENTORY_COMPS_IFCE_KEY, comps.ENG_REVISED_ITEMS_IFCE_KEY, comps.ENG_CHANGES_IFCE_KEY, comps.FROM_END_ITEM_UNIT_NUMBER, comps.NEW_FROM_END_ITEM_UNIT_NUMBER, comps.TO_END_ITEM_UNIT_NUMBER, comps.DELETE_GROUP_NAME, comps.DG_DESCRIPTION, comps.ORIGINAL_SYSTEM_REFERENCE, comps.ENFORCE_INT_REQUIREMENTS, comps.OPTIONAL_ON_MODEL, comps.PARENT_BILL_SEQ_ID, comps.PLAN_LEVEL, comps.AUTO_REQUEST_MATERIAL, comps.BASIS_TYPE, comps.INVERSE_QUANTITY, comps.SUGGESTED_VENDOR_NAME, comps.UNIT_PRICE, comps.NEW_REVISED_ITEM_REVISION, comps.OBJ_NAME, comps.PK1_VALUE, comps.PK2_VALUE, comps.PK3_VALUE, comps.PK4_VALUE, comps.PK5_VALUE, comps.FROM_OBJECT_REVISION_CODE, comps.FROM_OBJECT_REVISION_ID, comps.TO_OBJECT_REVISION_CODE, comps.TO_OBJECT_REVISION_ID, comps.FROM_MINOR_REVISION_CODE, comps.FROM_MINOR_REVISION_ID, comps.TO_MINOR_REVISION_CODE, comps.TO_MINOR_REVISION_ID, comps.FROM_END_ITEM_MINOR_REV_CODE, comps.FROM_END_ITEM_MINOR_REV_ID, comps.TO_END_ITEM_MINOR_REV_CODE, comps.TO_END_ITEM_MINOR_REV_ID, comps.RETURN_STATUS, comps.FROM_END_ITEM, comps.FROM_END_ITEM_ID, comps.FROM_END_ITEM_REV_CODE, comps.FROM_END_ITEM_REV_ID, comps.TO_END_ITEM_REV_CODE, comps.TO_END_ITEM_REV_ID, comps.COMPONENT_REVISION_CODE, comps.COMPONENT_REVISION_ID, comps.BATCH_ID, comps.COMP_SOURCE_SYSTEM_REFERENCE, comps.COMP_SOURCE_SYSTEM_REFER_DESC, comps.PARENT_SOURCE_SYSTEM_REFERENCE, comps.CATALOG_CATEGORY_NAME, comps.ITEM_CATALOG_GROUP_ID, comps.CHANGE_ID, comps.TEMPLATE_NAME, comps.PRIMARY_UNIT_OF_MEASURE, comps.ITEM_DESCRIPTION, comps.COMMON_COMPONENT_SEQUENCE_ID, comps.CHANGE_TRANSACTION_TYPE, comps.PARENT_REVISION_CODE, comps.PARENT_REVISION_ID, comps.OBJECT_VERSION_NUMBER, comps.PROGRAM_NAME, comps.PROGRAM_APP_NAME, comps.THREAD_NUMBER, comps.VERSION_REVISION_CODE, comps.VERSION_START_DATE, comps.SOURCE_SYSTEM_ID, comps.INTERFACE_TABLE_UNIQUE_ID, comps.ITEM_TRANSACTION_ID, comps.PHASE_NUMBER, comps.ATTRIBUTE_NUMBER1, comps.ATTRIBUTE_NUMBER2, comps.ATTRIBUTE_NUMBER3, comps.ATTRIBUTE_NUMBER4, comps.ATTRIBUTE_NUMBER5, comps.ATTRIBUTE_NUMBER6, comps.ATTRIBUTE_NUMBER7, comps.ATTRIBUTE_NUMBER8, comps.ATTRIBUTE_NUMBER9, comps.ATTRIBUTE_NUMBER10, comps.ATTRIBUTE_DATE1, comps.ATTRIBUTE_DATE2, comps.ATTRIBUTE_DATE3, comps.ATTRIBUTE_DATE4, comps.ATTRIBUTE_DATE5, comps.ATTRIBUTE_TIMESTAMP1, comps.ATTRIBUTE_TIMESTAMP2, comps.ATTRIBUTE_TIMESTAMP3, comps.ATTRIBUTE_TIMESTAMP4, comps.ATTRIBUTE_TIMESTAMP5, comps.INSTANTIABILITY_CODE, comps.SHOW_IN_SALES, comps.BATCH_NUMBER, comps.SOURCE_SYSTEM_CODE, comps.process_status, comps.primary_uom_code, sub_assy.item_number sub_assy_item_number, sub_assy.effectivity_control, sub_assy.source_system_reference ss_ref FROM egp_structures_interface sub_assy RIGHT OUTER JOIN egp_components_interface comps ON sub_assy.source_system_reference = comps.comp_source_system_reference AND sub_assy.organization_code = comps.organization_code AND (sub_assy.source_system_id = comps.source_system_id OR (sub_assy.source_system_id IS NULL OR comps.source_system_id IS NULL)) AND sub_assy.alternate_bom_designator = comps.alternate_bom_designator AND sub_assy.batch_id = comps.batch_id WHERE comps.batch_id = Sys_context('INTF_EXPL_CTX', 'BATCH_ID') AND comps.alternate_bom_designator = Sys_context('INTF_EXPL_CTX', 'STR_NAME') ) comp_header JOIN egp_structures_interface header ON header.batch_id = comp_header.batch_id AND header.source_system_reference = comp_header.parent_source_system_reference AND (header.source_system_id = comp_header.source_system_id OR (header.source_system_id IS NULL OR comp_header.source_system_id IS NULL)) AND header.organization_code = comp_header.organization_code AND header.alternate_bom_designator = comp_header.alternate_bom_designator WHERE header.batch_id = Sys_context('INTF_EXPL_CTX', 'BATCH_ID') AND header.alternate_bom_designator = Sys_context('INTF_EXPL_CTX', 'STR_NAME') AND header.process_status IN ( 0, 1 ) AND comp_header.process_status IN ( 0, 1 ) START WITH comp_header.parent_source_system_reference = Sys_context('INTF_EXPL_CTX', 'SS_REF') CONNECT BY nocycle PRIOR comp_header.ss_ref = comp_header.parent_source_system_reference) hky WHERE hky.batch_id = msii.batch_id AND ( hky.comp_source_system_reference = msii.source_system_reference OR hky.component_item_number = msii.item_number ) AND ( hky.organization_code = msii.organization_code OR hky.organization_id = msii.organization_id ) AND (hky.source_system_id = msii.source_system_id OR (hky.source_system_id IS NULL OR msii.source_system_id IS NULL)) AND msii.process_status IN ( 0, 1 ) |