VIEW: APPS.EAM_REBUILD_COMPLETION_JOBS_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)