View: WIP_SCHEDULING_EXCEPTIONS_V

Product:	WIP - Work in Process
Description:	This view is used to select exceptions that occur during scheduling.
Implementation/DBA Data:	APPS.WIP_SCHEDULING_EXCEPTIONS_V

View Text

SELECT WE.WIP_ENTITY_NAME
, WDJ.DESCRIPTION
, MSI.CONCATENATED_SEGMENTS
, MSI.DESCRIPTION
, MSI.INVENTORY_ITEM_ID
, WSE.SCHEDULING_SOURCE
, WSE.SCHEDULING_SOURCE_ID
, WSE.MESG_SEQUENCE
, WSE.MESSAGE_TYPE
, WSE.MESSAGE_TEXT
, WSE.MARKED_FLAG
, WSE.REPORTED_DATE
, WDJ.STATUS_TYPE
, WDJ.SCHEDULED_COMPLETION_DATE
, WDJ.DUE_DATE
, WDJ.PRIORITY
, WE.WIP_ENTITY_ID
, WE.ORGANIZATION_ID
, WSE.OPERATION_SEQ_NUM
, WSE.RESOURCE_SEQ_NUM
, BR.RESOURCE_CODE
, WSE.RESOURCE_ID
, MSI2.CONCATENATED_SEGMENTS COMPONENT_NAME
, WSE.INVENTORY_ITEM_ID COMPONENT_ID
, WSE.INSTANCE_ID
, WSE.SERIAL_NUMBER
, WOR.START_DATE
FROM WIP_ENTITIES WE
, WIP_DISCRETE_JOBS WDJ
, WIP_SCHEDULING_EXCEPTIONS WSE
, MTL_SYSTEM_ITEMS_KFV MSI
, BOM_RESOURCES BR
, MTL_SYSTEM_ITEMS_KFV MSI2
, WIP_OPERATION_RESOURCES WOR
WHERE WDJ.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
AND WDJ.ORGANIZATION_ID = WE.ORGANIZATION_ID
AND WSE.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
AND WSE.ORGANIZATION_ID = WE.ORGANIZATION_ID
AND WOR.WIP_ENTITY_ID (+)= WSE.WIP_ENTITY_ID
AND WOR.OPERATION_SEQ_NUM (+)= WSE.OPERATION_SEQ_NUM
AND WOR.RESOURCE_SEQ_NUM (+)= WSE.RESOURCE_SEQ_NUM
AND MSI.INVENTORY_ITEM_ID(+) = WE.PRIMARY_ITEM_ID
AND MSI.ORGANIZATION_ID(+) = WE.ORGANIZATION_ID
AND WSE.RESOURCE_ID = BR.RESOURCE_ID(+)
AND WSE.INVENTORY_ITEM_ID = MSI2.INVENTORY_ITEM_ID(+)
AND WSE.ORGANIZATION_ID = MSI2.ORGANIZATION_ID(+)

Columns