View: WIP_EAM_WORK_REQUESTS_V

Product:	WIP - Work in Process
Description:	View for Work Request information
Implementation/DBA Data:	APPS.WIP_EAM_WORK_REQUESTS_V

View Text

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_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

Columns