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.

[Home] [Help]

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

Columns

Name
ROW_ID
WORK_REQUEST_ID
WORK_REQUEST_NUMBER
DESCRIPTION
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
ASSET_NUMBER
ASSET_GROUP_ID
ORGANIZATION_ID
WORK_REQUEST_STATUS_ID
WORK_REQUEST_STATUS
WORK_REQUEST_PRIORITY_ID
WORK_REQUEST_PRIORITY
WORK_REQUEST_OWNING_DEPT_ID
WORK_REQUEST_OWNING_DEPT
EXPECTED_RESOLUTION_DATE
WIP_ENTITY_ID
WIP_ENTITY_NAME
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
WORK_REQUEST_AUTO_APPROVE
WORK_REQUEST_TYPE_ID
WORK_REQUEST_TYPE
WORK_REQUEST_CREATED_BY
ASSET_NUMBER_DESCRIPTION
ASSET_LOCATION_ID
ASSET_LOCATION
ASSET_CATEGORY_ID