VIEW: APPS.CSI_INSTANCE_DETAILS_V

Source

View Text - Preformatted

SELECT CII.INSTANCE_ID INSTANCE_ID, CII.INSTANCE_NUMBER INSTANCE_NUMBER, CII.EXTERNAL_REFERENCE EXTERNAL_REFERENCE, CII.INVENTORY_ITEM_ID INVENTORY_ITEM_ID, CII.INVENTORY_REVISION INVENTORY_REVISION, CII.INV_MASTER_ORGANIZATION_ID INV_MASTER_ORGANIZATION_ID, CII.SERIAL_NUMBER SERIAL_NUMBER, CII.MFG_SERIAL_NUMBER_FLAG MFG_SERIAL_NUMBER_FLAG, CII.LOT_NUMBER LOT_NUMBER, CII.QUANTITY QUANTITY, CII.UNIT_OF_MEASURE UNIT_OF_MEASURE, CII.ACCOUNTING_CLASS_CODE ACCOUNTING_CLASS_CODE, CII.INSTANCE_CONDITION_ID INSTANCE_CONDITION_ID, CII.INSTANCE_STATUS_ID INSTANCE_STATUS_ID, CII.CUSTOMER_VIEW_FLAG CUSTOMER_VIEW_FLAG, CII.MERCHANT_VIEW_FLAG MERCHANT_VIEW_FLAG, CII.SELLABLE_FLAG SELLABLE_FLAG, CII.SYSTEM_ID SYSTEM_ID, CII.INSTANCE_TYPE_CODE INSTANCE_TYPE_CODE, CII.ACTIVE_START_DATE ACTIVE_START_DATE, CII.ACTIVE_END_DATE ACTIVE_END_DATE, CII.LOCATION_TYPE_CODE LOCATION_TYPE_CODE, CII.LOCATION_ID LOCATION_ID, CII.INV_ORGANIZATION_ID INV_ORGANIZATION_ID, CII.INV_SUBINVENTORY_NAME INV_SUBINVENTORY_NAME, CII.INV_LOCATOR_ID INV_LOCATOR_ID, CII.PA_PROJECT_ID PA_PROJECT_ID, CII.PA_PROJECT_TASK_ID PA_PROJECT_TASK_ID, CII.IN_TRANSIT_ORDER_LINE_ID IN_TRANSIT_ORDER_LINE_ID, CII.WIP_JOB_ID WIP_JOB_ID, CII.PO_ORDER_LINE_ID PO_ORDER_LINE_ID, CII.LAST_OE_ORDER_LINE_ID LAST_OE_ORDER_LINE_ID, CII.LAST_OE_RMA_LINE_ID LAST_OE_RMA_LINE_ID, CII.LAST_PO_PO_LINE_ID LAST_PO_PO_LINE_ID, CII.LAST_OE_PO_NUMBER LAST_OE_PO_NUMBER, CII.LAST_WIP_JOB_ID LAST_WIP_JOB_ID, CII.LAST_PA_PROJECT_ID LAST_PA_PROJECT_ID, CII.LAST_PA_TASK_ID LAST_PA_TASK_ID, CII.LAST_OE_AGREEMENT_ID LAST_OE_AGREEMENT_ID, CII.INSTALL_DATE INSTALL_DATE, CII.MANUALLY_CREATED_FLAG MANUALLY_CREATED_FLAG, CII.RETURN_BY_DATE RETURN_BY_DATE, CII.ACTUAL_RETURN_DATE ACTUAL_RETURN_DATE, CII.CREATION_COMPLETE_FLAG CREATION_COMPLETE_FLAG, CII.COMPLETENESS_FLAG COMPLETENESS_FLAG, CII.CONTEXT CONTEXT, CII.ATTRIBUTE1 ATTRIBUTE1, CII.ATTRIBUTE2 ATTRIBUTE2, CII.ATTRIBUTE3 ATTRIBUTE3, CII.ATTRIBUTE4 ATTRIBUTE4, CII.ATTRIBUTE5 ATTRIBUTE5, CII.ATTRIBUTE6 ATTRIBUTE6, CII.ATTRIBUTE7 ATTRIBUTE7, CII.ATTRIBUTE8 ATTRIBUTE8, CII.ATTRIBUTE9 ATTRIBUTE9, CII.ATTRIBUTE10 ATTRIBUTE10, CII.ATTRIBUTE11 ATTRIBUTE11, CII.ATTRIBUTE12 ATTRIBUTE12, CII.ATTRIBUTE13 ATTRIBUTE13, CII.ATTRIBUTE14 ATTRIBUTE14, CII.ATTRIBUTE15 ATTRIBUTE15, CII.CREATED_BY CREATED_BY, CII.CREATION_DATE CREATION_DATE, CII.LAST_UPDATED_BY LAST_UPDATED_BY, CII.LAST_UPDATE_DATE LAST_UPDATE_DATE, CII.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CII.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CII.LAST_TXN_LINE_DETAIL_ID LAST_TXN_LINE_DETAIL_ID, CII.INSTALL_LOCATION_TYPE_CODE INSTALL_LOCATION_TYPE_CODE, CII.INSTALL_LOCATION_ID INSTALL_LOCATION_ID, CII.INSTANCE_USAGE_CODE INSTANCE_USAGE_CODE, CII.CONFIG_INST_HDR_ID CONFIG_INST_HDR_ID, CII.CONFIG_INST_REV_NUM CONFIG_INST_REV_NUM, CII.CONFIG_INST_ITEM_ID CONFIG_INST_ITEM_ID, CII.CONFIG_VALID_STATUS CONFIG_VALID_STATUS, CII.INSTANCE_DESCRIPTION INSTANCE_DESCRIPTION, MSIKFV.DESCRIPTION DESCRIPTION, MSI.ITEM_TYPE ITEM_TYPE, MSI.SERIAL_NUMBER_CONTROL_CODE SERIAL_NUMBER_CONTROL_CODE, MSI.LOT_CONTROL_CODE LOT_CONTROL_CODE, MSIKFV.CONCATENATED_SEGMENTS CONCATENATED_SEGMENTS, MSIKFV.PADDED_CONCATENATED_SEGMENTS PADDED_CONCATENATED_SEGMENTS, UOM.UNIT_OF_MEASURE_TL UNIT_OF_MEASURE_NAME, HOU.NAME NAME, MMS.STATUS_CODE STATUS_CODE, MMS.DESCRIPTION CONDITION_DESCRIPTION, CIS.NAME STATUS_NAME, CIS.DESCRIPTION STATUS_DESCRIPTION, PP.NAME PROJECT_NAME, PP.PROJECT_TYPE PROJECT_TYPE, PP.PROJECT_STATUS_CODE PROJECT_STATUS_CODE, PP.DESCRIPTION PROJECT_DESCRIPTION, PT.TASK_NUMBER TASK_NUMBER, PT.TASK_NAME TASK_NAME, PT.PARENT_TASK_ID PARENT_TASK_ID, PT.DESCRIPTION TASK_DESCRIPTION, OEL.LINE_TYPE_ID LINE_TYPE_ID, OEL.LINE_NUMBER LINE_NUMBER, OEL.CUST_PO_NUMBER CUST_PO_NUMBER, OOL.ORDER_NUMBER ORDER_NUMBER, OOL.VERSION_NUMBER ORDER_LINE_VERSION, OOL.ORDER_SOURCE_ID ORDER_SOURCE_ID, OOL.ORDERED_DATE ORDERED_DATE, WE.WIP_ENTITY_NAME WIP_ENTITY_NAME, WE.ENTITY_TYPE WIP_ENTITY_TYPE, WE.DESCRIPTION WIP_ENTITY_DESCRIPTION, PL.PO_HEADER_ID PO_HEADER_ID, PL.LINE_TYPE_ID PO_LINE_TYPE_ID, PL.LINE_NUM PO_LINE_NUMBER, PL.ITEM_DESCRIPTION ITEM_DESCRIPTION, CS.NAME SYSTEM_NAME, LOOH.HEADER_ID LAST_HEADER_ID, LOOH.ORDER_NUMBER LAST_ORDER_NUMBER, LOOH.ORDERED_DATE LAST_ORDERED_DATE, LOOL.LINE_ID LAST_LINE_ID, LOOL.LINE_NUMBER LAST_LINE_NUMBER, LOOL.CUST_PO_NUMBER LAST_CUST_PO_NUMBER, NVL(LOOL.ACTUAL_SHIPMENT_DATE, LOOL.FULFILLMENT_DATE) SHIPPED_DATE, CL1.MEANING INSTANCE_USAGE_MEANING, OAT.NAME AGREEMENT_NAME, CII.LAST_VLD_ORGANIZATION_ID LAST_VLD_ORGANIZATION_ID, MSI.BOM_ENABLED_FLAG BOM_ENABLED_FLAG, MSI.COMMS_NL_TRACKABLE_FLAG COMMS_NL_TRACKABLE_FLAG, MSI.INVENTORY_ITEM_FLAG INVENTORY_ITEM_FLAG, MSI.SHIPPABLE_ITEM_FLAG SHIPPABLE_ITEM_FLAG, CII.OPERATIONAL_STATUS_CODE OPERATIONAL_STATUS_CODE, CIS.STATUS_CHANGE_ALLOWED_FLAG STATUS_CHANGE_ALLOWED_FLAG, CII.ATTRIBUTE16 ATTRIBUTE16, CII.ATTRIBUTE17 ATTRIBUTE17, CII.ATTRIBUTE18 ATTRIBUTE18, CII.ATTRIBUTE19 ATTRIBUTE19, CII.ATTRIBUTE20 ATTRIBUTE20, CII.ATTRIBUTE21 ATTRIBUTE21, CII.ATTRIBUTE22 ATTRIBUTE22, CII.ATTRIBUTE23 ATTRIBUTE23, CII.ATTRIBUTE24 ATTRIBUTE24, CII.ATTRIBUTE25 ATTRIBUTE25, CII.ATTRIBUTE26 ATTRIBUTE26, CII.ATTRIBUTE27 ATTRIBUTE27, CII.ATTRIBUTE28 ATTRIBUTE28, CII.ATTRIBUTE29 ATTRIBUTE29, CII.ATTRIBUTE30 ATTRIBUTE30 FROM CSI_ITEM_INSTANCES CII, MTL_SYSTEM_ITEMS_VL MSIKFV, MTL_SYSTEM_ITEMS MSI, HR_ALL_ORGANIZATION_UNITS HOU, MTL_UNITS_OF_MEASURE_VL UOM, MTL_MATERIAL_STATUSES MMS, CSI_INSTANCE_STATUSES CIS, PA_PROJECTS_ALL PP, PA_TASKS PT, OE_ORDER_LINES_ALL OEL, OE_ORDER_HEADERS_ALL OOL, OE_AGREEMENTS_TL OAT, WIP_ENTITIES WE, PO_LINES_ALL PL, CSI_SYSTEMS_VL CS, OE_ORDER_LINES_ALL LOOL, OE_ORDER_HEADERS_ALL LOOH, CSI_LOOKUPS CL1 WHERE CII.LAST_VLD_ORGANIZATION_ID = MSI.ORGANIZATION_ID AND CII.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND CII.LAST_VLD_ORGANIZATION_ID = MSIKFV.ORGANIZATION_ID AND CII.INVENTORY_ITEM_ID = MSIKFV.INVENTORY_ITEM_ID AND CII.SYSTEM_ID = CS.SYSTEM_ID (+) AND HOU.ORGANIZATION_ID(+) = CII.LAST_VLD_ORGANIZATION_ID AND CII.UNIT_OF_MEASURE = UOM.UOM_CODE(+) AND CII.INSTANCE_CONDITION_ID = MMS.STATUS_ID (+) AND CII.INSTANCE_STATUS_ID = CIS.INSTANCE_STATUS_ID AND CII.PA_PROJECT_ID = PP.PROJECT_ID (+) AND CII.PA_PROJECT_TASK_ID = PT.TASK_ID (+) AND CII.IN_TRANSIT_ORDER_LINE_ID = OEL.LINE_ID (+) AND OEL.HEADER_ID = OOL.HEADER_ID (+) AND CII.WIP_JOB_ID = WE.WIP_ENTITY_ID(+) AND CII.PO_ORDER_LINE_ID = PL.PO_LINE_ID(+) AND CII.LAST_OE_ORDER_LINE_ID = LOOL.LINE_ID (+) AND LOOL.HEADER_ID = LOOH.HEADER_ID (+) AND CII.INSTANCE_USAGE_CODE = CL1.LOOKUP_CODE (+) AND CL1.LOOKUP_TYPE (+) = 'CSI_INSTANCE_USAGE_CODE' AND OAT.AGREEMENT_ID (+) = CII.LAST_OE_AGREEMENT_ID AND OAT.LANGUAGE (+) = USERENV('LANG')

View Text - HTML Formatted

SELECT CII.INSTANCE_ID INSTANCE_ID
, CII.INSTANCE_NUMBER INSTANCE_NUMBER
, CII.EXTERNAL_REFERENCE EXTERNAL_REFERENCE
, CII.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, CII.INVENTORY_REVISION INVENTORY_REVISION
, CII.INV_MASTER_ORGANIZATION_ID INV_MASTER_ORGANIZATION_ID
, CII.SERIAL_NUMBER SERIAL_NUMBER
, CII.MFG_SERIAL_NUMBER_FLAG MFG_SERIAL_NUMBER_FLAG
, CII.LOT_NUMBER LOT_NUMBER
, CII.QUANTITY QUANTITY
, CII.UNIT_OF_MEASURE UNIT_OF_MEASURE
, CII.ACCOUNTING_CLASS_CODE ACCOUNTING_CLASS_CODE
, CII.INSTANCE_CONDITION_ID INSTANCE_CONDITION_ID
, CII.INSTANCE_STATUS_ID INSTANCE_STATUS_ID
, CII.CUSTOMER_VIEW_FLAG CUSTOMER_VIEW_FLAG
, CII.MERCHANT_VIEW_FLAG MERCHANT_VIEW_FLAG
, CII.SELLABLE_FLAG SELLABLE_FLAG
, CII.SYSTEM_ID SYSTEM_ID
, CII.INSTANCE_TYPE_CODE INSTANCE_TYPE_CODE
, CII.ACTIVE_START_DATE ACTIVE_START_DATE
, CII.ACTIVE_END_DATE ACTIVE_END_DATE
, CII.LOCATION_TYPE_CODE LOCATION_TYPE_CODE
, CII.LOCATION_ID LOCATION_ID
, CII.INV_ORGANIZATION_ID INV_ORGANIZATION_ID
, CII.INV_SUBINVENTORY_NAME INV_SUBINVENTORY_NAME
, CII.INV_LOCATOR_ID INV_LOCATOR_ID
, CII.PA_PROJECT_ID PA_PROJECT_ID
, CII.PA_PROJECT_TASK_ID PA_PROJECT_TASK_ID
, CII.IN_TRANSIT_ORDER_LINE_ID IN_TRANSIT_ORDER_LINE_ID
, CII.WIP_JOB_ID WIP_JOB_ID
, CII.PO_ORDER_LINE_ID PO_ORDER_LINE_ID
, CII.LAST_OE_ORDER_LINE_ID LAST_OE_ORDER_LINE_ID
, CII.LAST_OE_RMA_LINE_ID LAST_OE_RMA_LINE_ID
, CII.LAST_PO_PO_LINE_ID LAST_PO_PO_LINE_ID
, CII.LAST_OE_PO_NUMBER LAST_OE_PO_NUMBER
, CII.LAST_WIP_JOB_ID LAST_WIP_JOB_ID
, CII.LAST_PA_PROJECT_ID LAST_PA_PROJECT_ID
, CII.LAST_PA_TASK_ID LAST_PA_TASK_ID
, CII.LAST_OE_AGREEMENT_ID LAST_OE_AGREEMENT_ID
, CII.INSTALL_DATE INSTALL_DATE
, CII.MANUALLY_CREATED_FLAG MANUALLY_CREATED_FLAG
, CII.RETURN_BY_DATE RETURN_BY_DATE
, CII.ACTUAL_RETURN_DATE ACTUAL_RETURN_DATE
, CII.CREATION_COMPLETE_FLAG CREATION_COMPLETE_FLAG
, CII.COMPLETENESS_FLAG COMPLETENESS_FLAG
, CII.CONTEXT CONTEXT
, CII.ATTRIBUTE1 ATTRIBUTE1
, CII.ATTRIBUTE2 ATTRIBUTE2
, CII.ATTRIBUTE3 ATTRIBUTE3
, CII.ATTRIBUTE4 ATTRIBUTE4
, CII.ATTRIBUTE5 ATTRIBUTE5
, CII.ATTRIBUTE6 ATTRIBUTE6
, CII.ATTRIBUTE7 ATTRIBUTE7
, CII.ATTRIBUTE8 ATTRIBUTE8
, CII.ATTRIBUTE9 ATTRIBUTE9
, CII.ATTRIBUTE10 ATTRIBUTE10
, CII.ATTRIBUTE11 ATTRIBUTE11
, CII.ATTRIBUTE12 ATTRIBUTE12
, CII.ATTRIBUTE13 ATTRIBUTE13
, CII.ATTRIBUTE14 ATTRIBUTE14
, CII.ATTRIBUTE15 ATTRIBUTE15
, CII.CREATED_BY CREATED_BY
, CII.CREATION_DATE CREATION_DATE
, CII.LAST_UPDATED_BY LAST_UPDATED_BY
, CII.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CII.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CII.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CII.LAST_TXN_LINE_DETAIL_ID LAST_TXN_LINE_DETAIL_ID
, CII.INSTALL_LOCATION_TYPE_CODE INSTALL_LOCATION_TYPE_CODE
, CII.INSTALL_LOCATION_ID INSTALL_LOCATION_ID
, CII.INSTANCE_USAGE_CODE INSTANCE_USAGE_CODE
, CII.CONFIG_INST_HDR_ID CONFIG_INST_HDR_ID
, CII.CONFIG_INST_REV_NUM CONFIG_INST_REV_NUM
, CII.CONFIG_INST_ITEM_ID CONFIG_INST_ITEM_ID
, CII.CONFIG_VALID_STATUS CONFIG_VALID_STATUS
, CII.INSTANCE_DESCRIPTION INSTANCE_DESCRIPTION
, MSIKFV.DESCRIPTION DESCRIPTION
, MSI.ITEM_TYPE ITEM_TYPE
, MSI.SERIAL_NUMBER_CONTROL_CODE SERIAL_NUMBER_CONTROL_CODE
, MSI.LOT_CONTROL_CODE LOT_CONTROL_CODE
, MSIKFV.CONCATENATED_SEGMENTS CONCATENATED_SEGMENTS
, MSIKFV.PADDED_CONCATENATED_SEGMENTS PADDED_CONCATENATED_SEGMENTS
, UOM.UNIT_OF_MEASURE_TL UNIT_OF_MEASURE_NAME
, HOU.NAME NAME
, MMS.STATUS_CODE STATUS_CODE
, MMS.DESCRIPTION CONDITION_DESCRIPTION
, CIS.NAME STATUS_NAME
, CIS.DESCRIPTION STATUS_DESCRIPTION
, PP.NAME PROJECT_NAME
, PP.PROJECT_TYPE PROJECT_TYPE
, PP.PROJECT_STATUS_CODE PROJECT_STATUS_CODE
, PP.DESCRIPTION PROJECT_DESCRIPTION
, PT.TASK_NUMBER TASK_NUMBER
, PT.TASK_NAME TASK_NAME
, PT.PARENT_TASK_ID PARENT_TASK_ID
, PT.DESCRIPTION TASK_DESCRIPTION
, OEL.LINE_TYPE_ID LINE_TYPE_ID
, OEL.LINE_NUMBER LINE_NUMBER
, OEL.CUST_PO_NUMBER CUST_PO_NUMBER
, OOL.ORDER_NUMBER ORDER_NUMBER
, OOL.VERSION_NUMBER ORDER_LINE_VERSION
, OOL.ORDER_SOURCE_ID ORDER_SOURCE_ID
, OOL.ORDERED_DATE ORDERED_DATE
, WE.WIP_ENTITY_NAME WIP_ENTITY_NAME
, WE.ENTITY_TYPE WIP_ENTITY_TYPE
, WE.DESCRIPTION WIP_ENTITY_DESCRIPTION
, PL.PO_HEADER_ID PO_HEADER_ID
, PL.LINE_TYPE_ID PO_LINE_TYPE_ID
, PL.LINE_NUM PO_LINE_NUMBER
, PL.ITEM_DESCRIPTION ITEM_DESCRIPTION
, CS.NAME SYSTEM_NAME
, LOOH.HEADER_ID LAST_HEADER_ID
, LOOH.ORDER_NUMBER LAST_ORDER_NUMBER
, LOOH.ORDERED_DATE LAST_ORDERED_DATE
, LOOL.LINE_ID LAST_LINE_ID
, LOOL.LINE_NUMBER LAST_LINE_NUMBER
, LOOL.CUST_PO_NUMBER LAST_CUST_PO_NUMBER
, NVL(LOOL.ACTUAL_SHIPMENT_DATE
, LOOL.FULFILLMENT_DATE) SHIPPED_DATE
, CL1.MEANING INSTANCE_USAGE_MEANING
, OAT.NAME AGREEMENT_NAME
, CII.LAST_VLD_ORGANIZATION_ID LAST_VLD_ORGANIZATION_ID
, MSI.BOM_ENABLED_FLAG BOM_ENABLED_FLAG
, MSI.COMMS_NL_TRACKABLE_FLAG COMMS_NL_TRACKABLE_FLAG
, MSI.INVENTORY_ITEM_FLAG INVENTORY_ITEM_FLAG
, MSI.SHIPPABLE_ITEM_FLAG SHIPPABLE_ITEM_FLAG
, CII.OPERATIONAL_STATUS_CODE OPERATIONAL_STATUS_CODE
, CIS.STATUS_CHANGE_ALLOWED_FLAG STATUS_CHANGE_ALLOWED_FLAG
, CII.ATTRIBUTE16 ATTRIBUTE16
, CII.ATTRIBUTE17 ATTRIBUTE17
, CII.ATTRIBUTE18 ATTRIBUTE18
, CII.ATTRIBUTE19 ATTRIBUTE19
, CII.ATTRIBUTE20 ATTRIBUTE20
, CII.ATTRIBUTE21 ATTRIBUTE21
, CII.ATTRIBUTE22 ATTRIBUTE22
, CII.ATTRIBUTE23 ATTRIBUTE23
, CII.ATTRIBUTE24 ATTRIBUTE24
, CII.ATTRIBUTE25 ATTRIBUTE25
, CII.ATTRIBUTE26 ATTRIBUTE26
, CII.ATTRIBUTE27 ATTRIBUTE27
, CII.ATTRIBUTE28 ATTRIBUTE28
, CII.ATTRIBUTE29 ATTRIBUTE29
, CII.ATTRIBUTE30 ATTRIBUTE30
FROM CSI_ITEM_INSTANCES CII
, MTL_SYSTEM_ITEMS_VL MSIKFV
, MTL_SYSTEM_ITEMS MSI
, HR_ALL_ORGANIZATION_UNITS HOU
, MTL_UNITS_OF_MEASURE_VL UOM
, MTL_MATERIAL_STATUSES MMS
, CSI_INSTANCE_STATUSES CIS
, PA_PROJECTS_ALL PP
, PA_TASKS PT
, OE_ORDER_LINES_ALL OEL
, OE_ORDER_HEADERS_ALL OOL
, OE_AGREEMENTS_TL OAT
, WIP_ENTITIES WE
, PO_LINES_ALL PL
, CSI_SYSTEMS_VL CS
, OE_ORDER_LINES_ALL LOOL
, OE_ORDER_HEADERS_ALL LOOH
, CSI_LOOKUPS CL1
WHERE CII.LAST_VLD_ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND CII.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND CII.LAST_VLD_ORGANIZATION_ID = MSIKFV.ORGANIZATION_ID
AND CII.INVENTORY_ITEM_ID = MSIKFV.INVENTORY_ITEM_ID
AND CII.SYSTEM_ID = CS.SYSTEM_ID (+)
AND HOU.ORGANIZATION_ID(+) = CII.LAST_VLD_ORGANIZATION_ID
AND CII.UNIT_OF_MEASURE = UOM.UOM_CODE(+)
AND CII.INSTANCE_CONDITION_ID = MMS.STATUS_ID (+)
AND CII.INSTANCE_STATUS_ID = CIS.INSTANCE_STATUS_ID
AND CII.PA_PROJECT_ID = PP.PROJECT_ID (+)
AND CII.PA_PROJECT_TASK_ID = PT.TASK_ID (+)
AND CII.IN_TRANSIT_ORDER_LINE_ID = OEL.LINE_ID (+)
AND OEL.HEADER_ID = OOL.HEADER_ID (+)
AND CII.WIP_JOB_ID = WE.WIP_ENTITY_ID(+)
AND CII.PO_ORDER_LINE_ID = PL.PO_LINE_ID(+)
AND CII.LAST_OE_ORDER_LINE_ID = LOOL.LINE_ID (+)
AND LOOL.HEADER_ID = LOOH.HEADER_ID (+)
AND CII.INSTANCE_USAGE_CODE = CL1.LOOKUP_CODE (+)
AND CL1.LOOKUP_TYPE (+) = 'CSI_INSTANCE_USAGE_CODE'
AND OAT.AGREEMENT_ID (+) = CII.LAST_OE_AGREEMENT_ID
AND OAT.LANGUAGE (+) = USERENV('LANG')