View: WIP_EAM_CST_HEADER_V

Product:	WIP - Work in Process
Description:	Cost information for EAM work orders
Implementation/DBA Data:	APPS.WIP_EAM_CST_HEADER_V

View Text

SELECT WDJ.WIP_ENTITY_ID
, WDJ.ORGANIZATION_ID
, EWODV.USER_DEFINED_STATUS_ID
, EWODV.WORK_ORDER_STATUS AS JOB_STATUS
, WDJ.PRIMARY_ITEM_ID
, WDJ.SCHEDULED_COMPLETION_DATE
, WDJ.ASSET_GROUP_ID
, DECODE(WDJ.ASSET_GROUP_ID
, NULL
, NULL
, CII.INSTANCE_NUMBER)
, M5.MEANING AS ESTIMATION_STATUS
, B1.DEPARTMENT_CODE AS OWNING_DEPARTMENT
, WDJ.REBUILD_ITEM_ID
, DECODE(WDJ.ASSET_GROUP_ID
, NULL
, CII.INSTANCE_NUMBER
, NULL)
, WE.WIP_ENTITY_NAME AS PARENT_WIP_ENTITY_NAME
, WDJ.LAST_ESTIMATION_REQ_ID
, WDJ.LAST_ESTIMATION_DATE
, WDJ.ESTIMATION_STATUS
, CII.SERIAL_NUMBER
FROM WIP_DISCRETE_JOBS WDJ
, WIP_ENTITIES WE
, BOM_DEPARTMENTS B1
, MFG_LOOKUPS M5
, CSI_ITEM_INSTANCES CII
, EAM_WORK_ORDER_DETAILS_V EWODV
WHERE WDJ.PARENT_WIP_ENTITY_ID = WE.WIP_ENTITY_ID (+)
AND WDJ.ORGANIZATION_ID =WE.ORGANIZATION_ID(+)
AND WDJ.OWNING_DEPARTMENT = B1.DEPARTMENT_ID (+)
AND B1.ORGANIZATION_ID(+) = WDJ.ORGANIZATION_ID
AND DECODE(WDJ.ESTIMATION_STATUS
, 1
, 1
, 2
, 2
, 3
, 3
, 7
, 7
, 8
, 8
, 1) = M5.LOOKUP_CODE
AND M5.LOOKUP_TYPE LIKE 'CST_EAM_ESTIMATION_STATUS'
AND WDJ.MAINTENANCE_OBJECT_TYPE = 3
AND CII.INSTANCE_ID = WDJ.MAINTENANCE_OBJECT_ID
AND EWODV.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
AND EWODV.ORGANIZATION_ID = WDJ.ORGANIZATION_ID UNION ALL SELECT WDJ.WIP_ENTITY_ID
, WDJ.ORGANIZATION_ID
, WDJ.STATUS_TYPE
, EWODV.WORK_ORDER_STATUS AS JOB_STATUS
, WDJ.PRIMARY_ITEM_ID
, WDJ.SCHEDULED_COMPLETION_DATE
, WDJ.ASSET_GROUP_ID
, NULL
, M5.MEANING AS ESTIMATION_STATUS
, B1.DEPARTMENT_CODE AS OWNING_DEPARTMENT
, WDJ.REBUILD_ITEM_ID
, NULL
, WE.WIP_ENTITY_NAME AS PARENT_WIP_ENTITY_NAME
, WDJ.LAST_ESTIMATION_REQ_ID
, WDJ.LAST_ESTIMATION_DATE
, WDJ.ESTIMATION_STATUS
, NULL
FROM WIP_DISCRETE_JOBS WDJ
, WIP_ENTITIES WE
, BOM_DEPARTMENTS B1
, MFG_LOOKUPS M5
, EAM_WORK_ORDER_DETAILS_V EWODV
WHERE WDJ.PARENT_WIP_ENTITY_ID = WE.WIP_ENTITY_ID (+)
AND WDJ.ORGANIZATION_ID =WE.ORGANIZATION_ID(+)
AND WDJ.OWNING_DEPARTMENT = B1.DEPARTMENT_ID (+)
AND B1.ORGANIZATION_ID(+) = WDJ.ORGANIZATION_ID
AND DECODE(WDJ.ESTIMATION_STATUS
, 1
, 1
, 2
, 2
, 3
, 3
, 7
, 7
, 8
, 8
, 1) = M5.LOOKUP_CODE
AND M5.LOOKUP_TYPE LIKE 'CST_EAM_ESTIMATION_STATUS'
AND WDJ.MAINTENANCE_OBJECT_TYPE = 2
AND EWODV.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
AND EWODV.ORGANIZATION_ID = WDJ.ORGANIZATION_ID

Columns