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: EAM_REBUILD_COMPLETION_JOBS_V

Product:	EAM - Enterprise Asset Management
Description:	Rebuild Work Order Completion View
Implementation/DBA Data:	APPS.EAM_REBUILD_COMPLETION_JOBS_V

View Text

SELECT WE1.WIP_ENTITY_NAME
, WDJ.DESCRIPTION
, WDJ.WIP_ENTITY_ID
, WDJ.REBUILD_ITEM_ID
, WDJ.REBUILD_SERIAL_NUMBER
, WDJ.SCHEDULED_START_DATE
, WDJ.SCHEDULED_COMPLETION_DATE
, WDJ.PRIMARY_ITEM_ID REBUILD_ACTIVITY_ID
, (WDJ.SCHEDULED_COMPLETION_DATE - WDJ.SCHEDULED_START_DATE)
, WE2.WIP_ENTITY_NAME PARENT_WORK_ORDER
, WDJ.ASSET_NUMBER
, WDJ.ASSET_GROUP_ID
, WDJ.COMPLETION_SUBINVENTORY
, WDJ.COMPLETION_LOCATOR_ID
, WDJ.LOT_NUMBER
, WDJ.MANUAL_REBUILD_FLAG
, WDJ.STATUS_TYPE
, WDJ.PROJECT_ID
, WDJ.TASK_ID
, WDJ.PARENT_WIP_ENTITY_ID
, WDJ.ORGANIZATION_ID
, WDJ.ACTIVITY_TYPE
FROM WIP_DISCRETE_JOBS WDJ
, WIP_ENTITIES WE1
, WIP_ENTITIES WE2
WHERE WDJ.WIP_ENTITY_ID = WE1.WIP_ENTITY_ID
AND WDJ.PARENT_WIP_ENTITY_ID = WE2.WIP_ENTITY_ID(+)
AND WE1.ENTITY_TYPE = 6
AND WDJ.REBUILD_ITEM_ID IS NOT NULL
AND STATUS_TYPE IN (3
, 4)

Columns

Name
WORK_ORDER
DESCRIPTION
WIP_ENTITY_ID
REBUILD_ITEM_ID
REBUILD_SERIAL_NUMBER
SCHEDULED_START_DATE
SCHEDULED_COMPLETION_DATE
REBUILD_ACTIVITY_ID
DURATION1
PARENT_WORK_ORDER
ASSET_NUMBER
ASSET_GROUP_ID
COMPLETION_SUBINVENTORY
COMPLETION_LOCATOR_ID
LOT_NUMBER
MANUAL_REBUILD_FLAG
STATUS_TYPE
PROJECT_ID
TASK_ID
PARENT_WIP_ENTITY_ID
ORGANIZATION_ID
ACTIVITY_TYPE