eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.MTL_EAM_ASSET_REBUILDS_DTLS_V

Source

View Text - Preformatted


SELECT cii.rowid row_id, cii.inventory_item_id, cii.serial_number, cii.instance_description as descriptive_text, cii.inv_subinventory_name current_subinventory_code, cii.inv_locator_id as current_locator_id, cii.network_asset_flag network_asset_flag, cii.context, cii.attribute1, cii.attribute2, cii.attribute3, cii.attribute4, cii.attribute5, cii.attribute6, cii.attribute7, cii.attribute8, cii.attribute9, cii.attribute10, cii.attribute11, cii.attribute12, cii.attribute13, cii.attribute14, cii.attribute15, cii.attribute16, cii.attribute17, cii.attribute18, cii.attribute19, cii.attribute20, cii.attribute21, cii.attribute22, cii.attribute23, cii.attribute24, cii.attribute25, cii.attribute26, cii.attribute27, cii.attribute28, cii.attribute29, cii.attribute30, mp.maint_organization_id current_organization_id, MP.ORGANIZATION_CODE, msi.concatenated_segments, msi.eam_item_type, msi.description asset_group_description, cii.category_id category_id, mck.concatenated_segments category_name, cii.pn_location_id pn_location_id, pl.building||pl.floor||pl.office pn_location_name, pl.location_code pn_location_code, cii.asset_criticality_code asset_criticality_code, ml.meaning asset_criticality, eomd.accounting_class_code wip_accounting_class_code, nvl(cii.maintainable_flag, 'Y') maintainable_flag, eomd.area_id, el.location_codes eam_location, eomd.owning_department_id, bd.department_code owning_department, msn_prod.current_organization_id prod_organization_id, OOD.ORGANIZATION_CODE PROD_ORGANIZATION_CODE, OOD.ORGANIZATION_NAME PROD_ORGANIZATION_NAME, msn_prod.inventory_item_id equipment_item_id, msn_prod.serial_number eqp_serial_number, cia.fa_asset_id, fa.asset_category_id, fa.asset_number fa_asset_number, msn_parent.inventory_item_id parent_item_id, msn_parent.serial_number parent_serial_number, msn_parent.gen_object_id parent_object_id, msn.gen_object_id, msn.current_status, ml2.meaning current_status_meaning, cii.instance_number, cii.last_vld_organization_id inv_organization_id, 3 maintenance_object_type, cii.instance_id maintenance_object_id ,cii.LAST_UPDATE_DATE ,cii.LAST_UPDATED_BY ,cii.CREATION_DATE ,cii.CREATED_BY ,cii.LAST_UPDATE_LOGIN ,cii.request_id ,cii.program_application_id ,cii.program_id ,cii.program_update_date FROM mtl_parameters mp, ORG_ORGANIZATION_DEFINITIONS OOD, csi_item_instances cii, eam_org_maint_defaults eomd, csi_i_assets cia, mfg_lookups ml, bom_departments bd, pn_locations_all pl, mtl_eam_locations el, mtl_categories_kfv mck, mtl_system_items_b_kfv msi, mtl_serial_numbers msn_prod,fa_additions_b fa, mtl_object_genealogy mog, mtl_serial_numbers msn, mtl_serial_numbers msn_parent, mfg_lookups ml2 WHERE mp.organization_id = cii.last_vld_organization_id AND cii.last_vld_organization_id = msi.organization_id AND msi.inventory_item_id = cii.inventory_item_id AND msi.eam_item_type in (1,3) AND nvl(cii.active_start_date, SYSDATE-1) <= SYSDATE AND nvl(cii.active_end_date, SYSDATE+1) >= SYSDATE AND msi.serial_number_control_code <> 1 AND cii.instance_id = eomd.object_id (+) AND eomd.object_type = 50 AND (eomd.organization_id = mp.maint_organization_id) AND cii.asset_criticality_code = ml.lookup_code(+) AND ml.lookup_type(+) = 'MTL_EAM_ASSET_CRITICALITY' AND bd.department_id(+) = eomd.owning_department_id AND cii.pn_location_id = pl.location_id(+) AND eomd.area_id = el.location_id(+) AND cii.category_id = mck.category_id(+) AND cii.equipment_gen_object_id = msn_prod.gen_object_id(+) AND OOD.ORGANIZATION_ID(+) = MSN_PROD.CURRENT_ORGANIZATION_ID AND cii.instance_id = cia.instance_id(+) AND cia.fa_asset_id = fa.asset_id(+) AND cii.inventory_item_id = msn.inventory_item_id AND cii.serial_number = msn.serial_number AND msn.gen_object_id = mog.object_id(+) AND mog.parent_object_id = msn_parent.gen_object_id(+) AND mog.genealogy_type(+) = 5 AND SYSDATE >= nvl(mog.start_date_active(+), SYSDATE) AND SYSDATE <= nvl(mog.end_date_active(+), SYSDATE) AND ml2.lookup_type(+) = 'SERIAL_NUM_STATUS' AND ml2.lookup_code(+) = MSN.CURRENT_STATUS UNION ALL SELECT cii.rowid row_id, cii.inventory_item_id, cii.serial_number, cii.instance_description as descriptive_text, cii.inv_subinventory_name current_subinventory_code, cii.inv_locator_id as current_locator_id, cii.network_asset_flag network_asset_flag, cii.context, cii.attribute1, cii.attribute2, cii.attribute3, cii.attribute4, cii.attribute5, cii.attribute6, cii.attribute7, cii.attribute8, cii.attribute9, cii.attribute10, cii.attribute11, cii.attribute12, cii.attribute13, cii.attribute14, cii.attribute15, cii.attribute16, cii.attribute17, cii.attribute18, cii.attribute19, cii.attribute20, cii.attribute21, cii.attribute22, cii.attribute23, cii.attribute24, cii.attribute25, cii.attribute26, cii.attribute27, cii.attribute28, cii.attribute29, cii.attribute30, mp.maint_organization_id current_organization_id,mp.organization_code, msi.concatenated_segments, msi.eam_item_type, msi.description asset_group_description, cii.category_id category_id, mck.concatenated_segments category_name, cii.pn_location_id pn_location_id, pl.building||pl.floor||pl.office pn_location_name, pl.location_code pn_location_code, cii.asset_criticality_code asset_criticality_code, ml.meaning asset_criticality, null wip_accounting_class_code, nvl(cii.maintainable_flag, 'Y') maintainable_flag, null, null eam_location, null, null owning_department, msn_prod.current_organization_id prod_organization_id, OOD.ORGANIZATION_CODE PROD_ORGANIZATION_CODE, OOD.ORGANIZATION_NAME PROD_ORGANIZATION_NAME, msn_prod.inventory_item_id equipment_item_id, msn_prod.serial_number eqp_serial_number, cia.fa_asset_id, fa.asset_category_id, fa.asset_number fa_asset_number, msn_parent.inventory_item_id parent_item_id, msn_parent.serial_number parent_serial_number, msn_parent.gen_object_id parent_object_id, msn.gen_object_id, msn.current_status, ml2.meaning current_status_meaning, cii.instance_number, cii.last_vld_organization_id inv_organization_id, 3 maintenance_object_type, cii.instance_id maintenance_object_id, cii.LAST_UPDATE_DATE, cii.LAST_UPDATED_BY, cii.CREATION_DATE, cii.CREATED_BY, cii.LAST_UPDATE_LOGIN, cii.request_id, cii.program_application_id, cii.program_id, cii.program_update_date FROM mtl_parameters mp, ORG_ORGANIZATION_DEFINITIONS OOD,csi_item_instances cii, csi_i_assets cia, mfg_lookups ml, pn_locations_all pl, mtl_categories_kfv mck, mtl_system_items_b_kfv msi, mtl_serial_numbers msn_prod,fa_additions_b fa, mtl_object_genealogy mog, mtl_serial_numbers msn, mtl_serial_numbers msn_parent, mfg_lookups ml2 WHERE mp.organization_id = cii.last_vld_organization_id AND cii.last_vld_organization_id = msi.organization_id AND msi.inventory_item_id = cii.inventory_item_id AND msi.eam_item_type in (1,3) AND nvl(cii.active_start_date, SYSDATE-1) <= SYSDATE AND nvl(cii.active_end_date, SYSDATE+1) >= SYSDATE AND msi.serial_number_control_code <> 1 AND cii.asset_criticality_code = ml.lookup_code(+) AND ml.lookup_type(+) = 'MTL_EAM_ASSET_CRITICALITY' AND cii.pn_location_id = pl.location_id(+) AND cii.category_id = mck.category_id(+) AND cii.equipment_gen_object_id = msn_prod.gen_object_id(+) AND cii.instance_id = cia.instance_id(+) AND cia.fa_asset_id = fa.asset_id(+) AND cii.inventory_item_id = msn.inventory_item_id AND cii.serial_number = msn.serial_number AND msn.gen_object_id = mog.object_id(+) AND mog.parent_object_id = msn_parent.gen_object_id(+) AND mog.genealogy_type(+) = 5 AND SYSDATE >= nvl(mog.start_date_active(+), SYSDATE) AND SYSDATE <= nvl(mog.end_date_active(+), SYSDATE) AND NOT EXISTS (SELECT 1 FROM eam_org_maint_defaults eomd WHERE eomd.organization_id = mp.maint_organization_id AND eomd.object_id = cii.instance_id AND eomd.object_type = 50) AND ml2.lookup_type(+) = 'SERIAL_NUM_STATUS' AND ml2.lookup_code(+) = MSN.CURRENT_STATUS AND OOD.ORGANIZATION_ID(+) = MSN_PROD.CURRENT_ORGANIZATION_ID

View Text - HTML Formatted

SELECT CII.ROWID ROW_ID
, CII.INVENTORY_ITEM_ID
, CII.SERIAL_NUMBER
, CII.INSTANCE_DESCRIPTION AS DESCRIPTIVE_TEXT
, CII.INV_SUBINVENTORY_NAME CURRENT_SUBINVENTORY_CODE
, CII.INV_LOCATOR_ID AS CURRENT_LOCATOR_ID
, CII.NETWORK_ASSET_FLAG NETWORK_ASSET_FLAG
, CII.CONTEXT
, CII.ATTRIBUTE1
, CII.ATTRIBUTE2
, CII.ATTRIBUTE3
, CII.ATTRIBUTE4
, CII.ATTRIBUTE5
, CII.ATTRIBUTE6
, CII.ATTRIBUTE7
, CII.ATTRIBUTE8
, CII.ATTRIBUTE9
, CII.ATTRIBUTE10
, CII.ATTRIBUTE11
, CII.ATTRIBUTE12
, CII.ATTRIBUTE13
, CII.ATTRIBUTE14
, CII.ATTRIBUTE15
, CII.ATTRIBUTE16
, CII.ATTRIBUTE17
, CII.ATTRIBUTE18
, CII.ATTRIBUTE19
, CII.ATTRIBUTE20
, CII.ATTRIBUTE21
, CII.ATTRIBUTE22
, CII.ATTRIBUTE23
, CII.ATTRIBUTE24
, CII.ATTRIBUTE25
, CII.ATTRIBUTE26
, CII.ATTRIBUTE27
, CII.ATTRIBUTE28
, CII.ATTRIBUTE29
, CII.ATTRIBUTE30
, MP.MAINT_ORGANIZATION_ID CURRENT_ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, MSI.CONCATENATED_SEGMENTS
, MSI.EAM_ITEM_TYPE
, MSI.DESCRIPTION ASSET_GROUP_DESCRIPTION
, CII.CATEGORY_ID CATEGORY_ID
, MCK.CONCATENATED_SEGMENTS CATEGORY_NAME
, CII.PN_LOCATION_ID PN_LOCATION_ID
, PL.BUILDING||PL.FLOOR||PL.OFFICE PN_LOCATION_NAME
, PL.LOCATION_CODE PN_LOCATION_CODE
, CII.ASSET_CRITICALITY_CODE ASSET_CRITICALITY_CODE
, ML.MEANING ASSET_CRITICALITY
, EOMD.ACCOUNTING_CLASS_CODE WIP_ACCOUNTING_CLASS_CODE
, NVL(CII.MAINTAINABLE_FLAG
, 'Y') MAINTAINABLE_FLAG
, EOMD.AREA_ID
, EL.LOCATION_CODES EAM_LOCATION
, EOMD.OWNING_DEPARTMENT_ID
, BD.DEPARTMENT_CODE OWNING_DEPARTMENT
, MSN_PROD.CURRENT_ORGANIZATION_ID PROD_ORGANIZATION_ID
, OOD.ORGANIZATION_CODE PROD_ORGANIZATION_CODE
, OOD.ORGANIZATION_NAME PROD_ORGANIZATION_NAME
, MSN_PROD.INVENTORY_ITEM_ID EQUIPMENT_ITEM_ID
, MSN_PROD.SERIAL_NUMBER EQP_SERIAL_NUMBER
, CIA.FA_ASSET_ID
, FA.ASSET_CATEGORY_ID
, FA.ASSET_NUMBER FA_ASSET_NUMBER
, MSN_PARENT.INVENTORY_ITEM_ID PARENT_ITEM_ID
, MSN_PARENT.SERIAL_NUMBER PARENT_SERIAL_NUMBER
, MSN_PARENT.GEN_OBJECT_ID PARENT_OBJECT_ID
, MSN.GEN_OBJECT_ID
, MSN.CURRENT_STATUS
, ML2.MEANING CURRENT_STATUS_MEANING
, CII.INSTANCE_NUMBER
, CII.LAST_VLD_ORGANIZATION_ID INV_ORGANIZATION_ID
, 3 MAINTENANCE_OBJECT_TYPE
, CII.INSTANCE_ID MAINTENANCE_OBJECT_ID
, CII.LAST_UPDATE_DATE
, CII.LAST_UPDATED_BY
, CII.CREATION_DATE
, CII.CREATED_BY
, CII.LAST_UPDATE_LOGIN
, CII.REQUEST_ID
, CII.PROGRAM_APPLICATION_ID
, CII.PROGRAM_ID
, CII.PROGRAM_UPDATE_DATE
FROM MTL_PARAMETERS MP
, ORG_ORGANIZATION_DEFINITIONS OOD
, CSI_ITEM_INSTANCES CII
, EAM_ORG_MAINT_DEFAULTS EOMD
, CSI_I_ASSETS CIA
, MFG_LOOKUPS ML
, BOM_DEPARTMENTS BD
, PN_LOCATIONS_ALL PL
, MTL_EAM_LOCATIONS EL
, MTL_CATEGORIES_KFV MCK
, MTL_SYSTEM_ITEMS_B_KFV MSI
, MTL_SERIAL_NUMBERS MSN_PROD
, FA_ADDITIONS_B FA
, MTL_OBJECT_GENEALOGY MOG
, MTL_SERIAL_NUMBERS MSN
, MTL_SERIAL_NUMBERS MSN_PARENT
, MFG_LOOKUPS ML2
WHERE MP.ORGANIZATION_ID = CII.LAST_VLD_ORGANIZATION_ID
AND CII.LAST_VLD_ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = CII.INVENTORY_ITEM_ID
AND MSI.EAM_ITEM_TYPE IN (1
, 3)
AND NVL(CII.ACTIVE_START_DATE
, SYSDATE-1) <= SYSDATE
AND NVL(CII.ACTIVE_END_DATE
, SYSDATE+1) >= SYSDATE
AND MSI.SERIAL_NUMBER_CONTROL_CODE <> 1
AND CII.INSTANCE_ID = EOMD.OBJECT_ID (+)
AND EOMD.OBJECT_TYPE = 50
AND (EOMD.ORGANIZATION_ID = MP.MAINT_ORGANIZATION_ID)
AND CII.ASSET_CRITICALITY_CODE = ML.LOOKUP_CODE(+)
AND ML.LOOKUP_TYPE(+) = 'MTL_EAM_ASSET_CRITICALITY'
AND BD.DEPARTMENT_ID(+) = EOMD.OWNING_DEPARTMENT_ID
AND CII.PN_LOCATION_ID = PL.LOCATION_ID(+)
AND EOMD.AREA_ID = EL.LOCATION_ID(+)
AND CII.CATEGORY_ID = MCK.CATEGORY_ID(+)
AND CII.EQUIPMENT_GEN_OBJECT_ID = MSN_PROD.GEN_OBJECT_ID(+)
AND OOD.ORGANIZATION_ID(+) = MSN_PROD.CURRENT_ORGANIZATION_ID
AND CII.INSTANCE_ID = CIA.INSTANCE_ID(+)
AND CIA.FA_ASSET_ID = FA.ASSET_ID(+)
AND CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
AND MSN.GEN_OBJECT_ID = MOG.OBJECT_ID(+)
AND MOG.PARENT_OBJECT_ID = MSN_PARENT.GEN_OBJECT_ID(+)
AND MOG.GENEALOGY_TYPE(+) = 5
AND SYSDATE >= NVL(MOG.START_DATE_ACTIVE(+)
, SYSDATE)
AND SYSDATE <= NVL(MOG.END_DATE_ACTIVE(+)
, SYSDATE)
AND ML2.LOOKUP_TYPE(+) = 'SERIAL_NUM_STATUS'
AND ML2.LOOKUP_CODE(+) = MSN.CURRENT_STATUS UNION ALL SELECT CII.ROWID ROW_ID
, CII.INVENTORY_ITEM_ID
, CII.SERIAL_NUMBER
, CII.INSTANCE_DESCRIPTION AS DESCRIPTIVE_TEXT
, CII.INV_SUBINVENTORY_NAME CURRENT_SUBINVENTORY_CODE
, CII.INV_LOCATOR_ID AS CURRENT_LOCATOR_ID
, CII.NETWORK_ASSET_FLAG NETWORK_ASSET_FLAG
, CII.CONTEXT
, CII.ATTRIBUTE1
, CII.ATTRIBUTE2
, CII.ATTRIBUTE3
, CII.ATTRIBUTE4
, CII.ATTRIBUTE5
, CII.ATTRIBUTE6
, CII.ATTRIBUTE7
, CII.ATTRIBUTE8
, CII.ATTRIBUTE9
, CII.ATTRIBUTE10
, CII.ATTRIBUTE11
, CII.ATTRIBUTE12
, CII.ATTRIBUTE13
, CII.ATTRIBUTE14
, CII.ATTRIBUTE15
, CII.ATTRIBUTE16
, CII.ATTRIBUTE17
, CII.ATTRIBUTE18
, CII.ATTRIBUTE19
, CII.ATTRIBUTE20
, CII.ATTRIBUTE21
, CII.ATTRIBUTE22
, CII.ATTRIBUTE23
, CII.ATTRIBUTE24
, CII.ATTRIBUTE25
, CII.ATTRIBUTE26
, CII.ATTRIBUTE27
, CII.ATTRIBUTE28
, CII.ATTRIBUTE29
, CII.ATTRIBUTE30
, MP.MAINT_ORGANIZATION_ID CURRENT_ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, MSI.CONCATENATED_SEGMENTS
, MSI.EAM_ITEM_TYPE
, MSI.DESCRIPTION ASSET_GROUP_DESCRIPTION
, CII.CATEGORY_ID CATEGORY_ID
, MCK.CONCATENATED_SEGMENTS CATEGORY_NAME
, CII.PN_LOCATION_ID PN_LOCATION_ID
, PL.BUILDING||PL.FLOOR||PL.OFFICE PN_LOCATION_NAME
, PL.LOCATION_CODE PN_LOCATION_CODE
, CII.ASSET_CRITICALITY_CODE ASSET_CRITICALITY_CODE
, ML.MEANING ASSET_CRITICALITY
, NULL WIP_ACCOUNTING_CLASS_CODE
, NVL(CII.MAINTAINABLE_FLAG
, 'Y') MAINTAINABLE_FLAG
, NULL
, NULL EAM_LOCATION
, NULL
, NULL OWNING_DEPARTMENT
, MSN_PROD.CURRENT_ORGANIZATION_ID PROD_ORGANIZATION_ID
, OOD.ORGANIZATION_CODE PROD_ORGANIZATION_CODE
, OOD.ORGANIZATION_NAME PROD_ORGANIZATION_NAME
, MSN_PROD.INVENTORY_ITEM_ID EQUIPMENT_ITEM_ID
, MSN_PROD.SERIAL_NUMBER EQP_SERIAL_NUMBER
, CIA.FA_ASSET_ID
, FA.ASSET_CATEGORY_ID
, FA.ASSET_NUMBER FA_ASSET_NUMBER
, MSN_PARENT.INVENTORY_ITEM_ID PARENT_ITEM_ID
, MSN_PARENT.SERIAL_NUMBER PARENT_SERIAL_NUMBER
, MSN_PARENT.GEN_OBJECT_ID PARENT_OBJECT_ID
, MSN.GEN_OBJECT_ID
, MSN.CURRENT_STATUS
, ML2.MEANING CURRENT_STATUS_MEANING
, CII.INSTANCE_NUMBER
, CII.LAST_VLD_ORGANIZATION_ID INV_ORGANIZATION_ID
, 3 MAINTENANCE_OBJECT_TYPE
, CII.INSTANCE_ID MAINTENANCE_OBJECT_ID
, CII.LAST_UPDATE_DATE
, CII.LAST_UPDATED_BY
, CII.CREATION_DATE
, CII.CREATED_BY
, CII.LAST_UPDATE_LOGIN
, CII.REQUEST_ID
, CII.PROGRAM_APPLICATION_ID
, CII.PROGRAM_ID
, CII.PROGRAM_UPDATE_DATE
FROM MTL_PARAMETERS MP
, ORG_ORGANIZATION_DEFINITIONS OOD
, CSI_ITEM_INSTANCES CII
, CSI_I_ASSETS CIA
, MFG_LOOKUPS ML
, PN_LOCATIONS_ALL PL
, MTL_CATEGORIES_KFV MCK
, MTL_SYSTEM_ITEMS_B_KFV MSI
, MTL_SERIAL_NUMBERS MSN_PROD
, FA_ADDITIONS_B FA
, MTL_OBJECT_GENEALOGY MOG
, MTL_SERIAL_NUMBERS MSN
, MTL_SERIAL_NUMBERS MSN_PARENT
, MFG_LOOKUPS ML2
WHERE MP.ORGANIZATION_ID = CII.LAST_VLD_ORGANIZATION_ID
AND CII.LAST_VLD_ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = CII.INVENTORY_ITEM_ID
AND MSI.EAM_ITEM_TYPE IN (1
, 3)
AND NVL(CII.ACTIVE_START_DATE
, SYSDATE-1) <= SYSDATE
AND NVL(CII.ACTIVE_END_DATE
, SYSDATE+1) >= SYSDATE
AND MSI.SERIAL_NUMBER_CONTROL_CODE <> 1
AND CII.ASSET_CRITICALITY_CODE = ML.LOOKUP_CODE(+)
AND ML.LOOKUP_TYPE(+) = 'MTL_EAM_ASSET_CRITICALITY'
AND CII.PN_LOCATION_ID = PL.LOCATION_ID(+)
AND CII.CATEGORY_ID = MCK.CATEGORY_ID(+)
AND CII.EQUIPMENT_GEN_OBJECT_ID = MSN_PROD.GEN_OBJECT_ID(+)
AND CII.INSTANCE_ID = CIA.INSTANCE_ID(+)
AND CIA.FA_ASSET_ID = FA.ASSET_ID(+)
AND CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
AND MSN.GEN_OBJECT_ID = MOG.OBJECT_ID(+)
AND MOG.PARENT_OBJECT_ID = MSN_PARENT.GEN_OBJECT_ID(+)
AND MOG.GENEALOGY_TYPE(+) = 5
AND SYSDATE >= NVL(MOG.START_DATE_ACTIVE(+)
, SYSDATE)
AND SYSDATE <= NVL(MOG.END_DATE_ACTIVE(+)
, SYSDATE)
AND NOT EXISTS (SELECT 1
FROM EAM_ORG_MAINT_DEFAULTS EOMD
WHERE EOMD.ORGANIZATION_ID = MP.MAINT_ORGANIZATION_ID
AND EOMD.OBJECT_ID = CII.INSTANCE_ID
AND EOMD.OBJECT_TYPE = 50)
AND ML2.LOOKUP_TYPE(+) = 'SERIAL_NUM_STATUS'
AND ML2.LOOKUP_CODE(+) = MSN.CURRENT_STATUS
AND OOD.ORGANIZATION_ID(+) = MSN_PROD.CURRENT_ORGANIZATION_ID