VIEW: APPS.WIP_EAM_WORK_REQUESTS_V

Source

View Text - Preformatted

SELECT wr.ROWID , wr.WORK_REQUEST_ID , wr.WORK_REQUEST_NUMBER , wr.DESCRIPTION , wr.LAST_UPDATE_DATE , wr.LAST_UPDATED_BY , wr.CREATION_DATE, wr.CREATED_BY, wr.LAST_UPDATE_LOGIN, cii.instance_number, cii.inventory_item_id, wr.ORGANIZATION_ID, wr.WORK_REQUEST_STATUS_ID, lv1.meaning WORK_REQUEST_STATUS, wr.WORK_REQUEST_PRIORITY_ID, lv2.meaning WORK_REQUEST_PRIORITY, wr.WORK_REQUEST_OWNING_DEPT, bd.DEPARTMENT_CODE, wr.EXPECTED_RESOLUTION_DATE, wr.WIP_ENTITY_ID, we.WIP_ENTITY_NAME, wr.ATTRIBUTE_CATEGORY, wr.ATTRIBUTE1 , wr.ATTRIBUTE2, wr.ATTRIBUTE3, wr.ATTRIBUTE4, wr.ATTRIBUTE5, wr.ATTRIBUTE6, wr.ATTRIBUTE7, wr.ATTRIBUTE8, wr.ATTRIBUTE9, wr.ATTRIBUTE10, wr.ATTRIBUTE11, wr.ATTRIBUTE12, wr.ATTRIBUTE13, wr.ATTRIBUTE14, wr.ATTRIBUTE15, wr.WORK_REQUEST_AUTO_APPROVE, wr.WORK_REQUEST_TYPE_ID, lv3.meaning WORK_REQUEST_TYPE, wr.WORK_REQUEST_CREATED_BY, cii.instance_description, eomd.area_id, mel.location_codes, cii.category_id from wip_eam_work_requests wr, csi_item_instances cii, eam_org_maint_defaults eomd, mtl_eam_locations mel, mfg_lookups lv1, mfg_lookups lv2, mfg_lookups lv3, wip_entities we, bom_departments bd WHERE wr.maintenance_object_type = 3 and wr.maintenance_object_id = cii.instance_id and we.wip_entity_id (+) = wr.wip_entity_id and we.organization_id (+) = wr.organization_id and cii.instance_id = eomd.object_id (+) and eomd.object_type(+) = 50 and (eomd.organization_id is null or eomd.organization_id = wr.organization_id) and mel.location_id (+) = eomd.area_id and bd.department_id (+) = wr.work_request_owning_dept and lv1.lookup_type (+) = 'WIP_EAM_WORK_REQ_STATUS' and lv1.lookup_code (+) = wr.work_request_status_id and lv2.lookup_type (+) = 'WIP_EAM_ACTIVITY_PRIORITY' and lv2.lookup_code (+) = wr.work_request_priority_id and lv3.lookup_type (+) = 'WIP_EAM_WORK_REQ_TYPE' and lv3.lookup_code (+) = wr.work_request_type_id

View Text - HTML Formatted

SELECT WR.ROWID
, WR.WORK_REQUEST_ID
, WR.WORK_REQUEST_NUMBER
, WR.DESCRIPTION
, WR.LAST_UPDATE_DATE
, WR.LAST_UPDATED_BY
, WR.CREATION_DATE
, WR.CREATED_BY
, WR.LAST_UPDATE_LOGIN
, CII.INSTANCE_NUMBER
, CII.INVENTORY_ITEM_ID
, WR.ORGANIZATION_ID
, WR.WORK_REQUEST_STATUS_ID
, LV1.MEANING WORK_REQUEST_STATUS
, WR.WORK_REQUEST_PRIORITY_ID
, LV2.MEANING WORK_REQUEST_PRIORITY
, WR.WORK_REQUEST_OWNING_DEPT
, BD.DEPARTMENT_CODE
, WR.EXPECTED_RESOLUTION_DATE
, WR.WIP_ENTITY_ID
, WE.WIP_ENTITY_NAME
, WR.ATTRIBUTE_CATEGORY
, WR.ATTRIBUTE1
, WR.ATTRIBUTE2
, WR.ATTRIBUTE3
, WR.ATTRIBUTE4
, WR.ATTRIBUTE5
, WR.ATTRIBUTE6
, WR.ATTRIBUTE7
, WR.ATTRIBUTE8
, WR.ATTRIBUTE9
, WR.ATTRIBUTE10
, WR.ATTRIBUTE11
, WR.ATTRIBUTE12
, WR.ATTRIBUTE13
, WR.ATTRIBUTE14
, WR.ATTRIBUTE15
, WR.WORK_REQUEST_AUTO_APPROVE
, WR.WORK_REQUEST_TYPE_ID
, LV3.MEANING WORK_REQUEST_TYPE
, WR.WORK_REQUEST_CREATED_BY
, CII.INSTANCE_DESCRIPTION
, EOMD.AREA_ID
, MEL.LOCATION_CODES
, CII.CATEGORY_ID
FROM WIP_EAM_WORK_REQUESTS WR
, CSI_ITEM_INSTANCES CII
, EAM_ORG_MAINT_DEFAULTS EOMD
, MTL_EAM_LOCATIONS MEL
, MFG_LOOKUPS LV1
, MFG_LOOKUPS LV2
, MFG_LOOKUPS LV3
, WIP_ENTITIES WE
, BOM_DEPARTMENTS BD
WHERE WR.MAINTENANCE_OBJECT_TYPE = 3
AND WR.MAINTENANCE_OBJECT_ID = CII.INSTANCE_ID
AND WE.WIP_ENTITY_ID (+) = WR.WIP_ENTITY_ID
AND WE.ORGANIZATION_ID (+) = WR.ORGANIZATION_ID
AND CII.INSTANCE_ID = EOMD.OBJECT_ID (+)
AND EOMD.OBJECT_TYPE(+) = 50
AND (EOMD.ORGANIZATION_ID IS NULL OR EOMD.ORGANIZATION_ID = WR.ORGANIZATION_ID)
AND MEL.LOCATION_ID (+) = EOMD.AREA_ID
AND BD.DEPARTMENT_ID (+) = WR.WORK_REQUEST_OWNING_DEPT
AND LV1.LOOKUP_TYPE (+) = 'WIP_EAM_WORK_REQ_STATUS'
AND LV1.LOOKUP_CODE (+) = WR.WORK_REQUEST_STATUS_ID
AND LV2.LOOKUP_TYPE (+) = 'WIP_EAM_ACTIVITY_PRIORITY'
AND LV2.LOOKUP_CODE (+) = WR.WORK_REQUEST_PRIORITY_ID
AND LV3.LOOKUP_TYPE (+) = 'WIP_EAM_WORK_REQ_TYPE'
AND LV3.LOOKUP_CODE (+) = WR.WORK_REQUEST_TYPE_ID