View: WSH_EXCEPTIONS_DLVY_V

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSH_EXCEPTIONS_DLVY_V

View Text

SELECT XC.ROWID
, XC.EXCEPTION_ID
, XC.LOGGED_AT_LOCATION_ID
, WLAL.UI_LOCATION_CODE
, XC.LOGGING_ENTITY
, WSH_XC_UTIL.GET_LOOKUP_MEANING(XC.LOGGING_ENTITY
, 'LOGGING_ENTITY')
, XC.LOGGING_ENTITY_ID
, XC.EXCEPTION_NAME
, XC_DF.DESCRIPTION
, FLV.MEANING
, XC.EXCEPTION_LOCATION_ID
, WLO.UI_LOCATION_CODE
, MP.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, XC.MESSAGE
, DECODE(XC.SEVERITY
, 'HIGH'
, 'ERROR'
, 'MEDIUM'
, 'WARNING'
, 'LOW'
, 'INFO'
, XC.SEVERITY) SEVERITY
, WSH_XC_UTIL.GET_LOOKUP_MEANING(DECODE(XC.SEVERITY
, 'HIGH'
, 'ERROR'
, 'MEDIUM'
, 'WARNING'
, 'LOW'
, 'INFO'
, XC.SEVERITY)
, 'EXCEPTION_BEHAVIOR')
, XC.MANUALLY_LOGGED
, DECODE(XC.STATUS
, 'MANUAL'
, 'OPEN'
, 'LOGGED'
, 'OPEN'
, 'IN_PROCESS'
, 'OPEN'
, 'ERROR'
, 'OPEN'
, 'NOT_HANDLED'
, 'NO_ACTION_REQUIRED'
, NULL
, 'NO_ACTION_REQUIRED'
, XC.STATUS) STATUS
, XC.TRIP_ID
, XC.TRIP_NAME
, XC.TRIP_STOP_ID
, XC.DELIVERY_ID
, XC.DELIVERY_NAME
, XC.DELIVERY_DETAIL_ID
, XC.DELIVERY_ASSIGNMENT_ID
, XC.CONTAINER_NAME
, XC.INVENTORY_ITEM_ID
, XC.LOT_NUMBER
, XC.REVISION
, XC.SERIAL_NUMBER
, XC.UNIT_OF_MEASURE
, XC.QUANTITY
, XC.SUBINVENTORY
, XC.LOCATOR_ID
, XC.ARRIVAL_DATE
, XC.DEPARTURE_DATE
, XC.ERROR_MESSAGE
, XC.ATTRIBUTE_CATEGORY
, XC.ATTRIBUTE1
, XC.ATTRIBUTE2
, XC.ATTRIBUTE3
, XC.ATTRIBUTE4
, XC.ATTRIBUTE5
, XC.ATTRIBUTE6
, XC.ATTRIBUTE7
, XC.ATTRIBUTE8
, XC.ATTRIBUTE9
, XC.ATTRIBUTE10
, XC.ATTRIBUTE11
, XC.ATTRIBUTE12
, XC.ATTRIBUTE13
, XC.ATTRIBUTE14
, XC.ATTRIBUTE15
, XC.CREATION_DATE
, XC.CREATED_BY
, XC.LAST_UPDATE_DATE
, XC.LAST_UPDATED_BY
, XC.LAST_UPDATE_LOGIN
, XC.REQUEST_ID
, XC.PROGRAM_APPLICATION_ID
, XC.PROGRAM_ID
, XC.PROGRAM_UPDATE_DATE
, XC.QUANTITY2
, XC.UNIT_OF_MEASURE2
, NULL
, NULL
, NULL
, XC.BATCH_ID
FROM WSH_EXCEPTIONS XC
, WSH_EXCEPTION_DEFINITIONS_TL XC_DF
, WSH_EXCEPTION_DEFINITIONS_B XB
, FND_LOOKUP_VALUES FLV
, WSH_LOCATIONS WLO
, WSH_LOCATIONS WLAL
, HR_LOCATIONS_ALL HLA
, MTL_PARAMETERS MP
WHERE XC.EXCEPTION_NAME = XC_DF.EXCEPTION_NAME (+)
AND XC.EXCEPTION_LOCATION_ID = WLO.WSH_LOCATION_ID (+)
AND XC.LOGGED_AT_LOCATION_ID = WLAL.WSH_LOCATION_ID (+)
AND WLO.SOURCE_LOCATION_ID = HLA.LOCATION_ID (+)
AND HLA.INVENTORY_ORGANIZATION_ID = MP.ORGANIZATION_ID (+)
AND ( HLA.INVENTORY_ORGANIZATION_ID IS NULL OR (HLA.INVENTORY_ORGANIZATION_ID IS NOT NULL
AND WLO.LOCATION_SOURCE_CODE='HR') )
AND XC_DF.EXCEPTION_DEFINITION_ID = XB.EXCEPTION_DEFINITION_ID
AND XC_DF.LANGUAGE = USERENV('LANG')
AND XB.EXCEPTION_TYPE = FLV.LOOKUP_CODE
AND FLV.LOOKUP_TYPE = 'EXCEPTION_TYPE'
AND FLV.LANGUAGE = USERENV('LANG') UNION SELECT XC.ROWID
, XC.EXCEPTION_ID
, XC.LOGGED_AT_LOCATION_ID
, WLAL.UI_LOCATION_CODE
, XC.LOGGING_ENTITY
, WSH_XC_UTIL.GET_LOOKUP_MEANING(XC.LOGGING_ENTITY
, 'LOGGING_ENTITY')
, XC.LOGGING_ENTITY_ID
, XC.EXCEPTION_NAME
, XC_DF.DESCRIPTION
, FLV.MEANING
, XC.EXCEPTION_LOCATION_ID
, WLO.UI_LOCATION_CODE
, MP.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, XC.MESSAGE
, DECODE(XC.SEVERITY
, 'HIGH'
, 'ERROR'
, 'MEDIUM'
, 'WARNING'
, 'LOW'
, 'INFO'
, XC.SEVERITY) SEVERITY
, WSH_XC_UTIL.GET_LOOKUP_MEANING(DECODE(XC.SEVERITY
, 'HIGH'
, 'ERROR'
, 'MEDIUM'
, 'WARNING'
, 'LOW'
, 'INFO'
, XC.SEVERITY)
, 'EXCEPTION_BEHAVIOR')
, XC.MANUALLY_LOGGED
, DECODE(XC.STATUS
, 'MANUAL'
, 'OPEN'
, 'LOGGED'
, 'OPEN'
, 'IN_PROCESS'
, 'OPEN'
, 'ERROR'
, 'OPEN'
, 'NOT_HANDLED'
, 'NO_ACTION_REQUIRED'
, NULL
, 'NO_ACTION_REQUIRED'
, XC.STATUS) STATUS
, XC.TRIP_ID
, XC.TRIP_NAME
, XC.TRIP_STOP_ID
, WDA.DELIVERY_ID
, XC.DELIVERY_NAME
, XC.DELIVERY_DETAIL_ID
, XC.DELIVERY_ASSIGNMENT_ID
, XC.CONTAINER_NAME
, XC.INVENTORY_ITEM_ID
, XC.LOT_NUMBER
, XC.REVISION
, XC.SERIAL_NUMBER
, XC.UNIT_OF_MEASURE
, XC.QUANTITY
, XC.SUBINVENTORY
, XC.LOCATOR_ID
, XC.ARRIVAL_DATE
, XC.DEPARTURE_DATE
, XC.ERROR_MESSAGE
, XC.ATTRIBUTE_CATEGORY
, XC.ATTRIBUTE1
, XC.ATTRIBUTE2
, XC.ATTRIBUTE3
, XC.ATTRIBUTE4
, XC.ATTRIBUTE5
, XC.ATTRIBUTE6
, XC.ATTRIBUTE7
, XC.ATTRIBUTE8
, XC.ATTRIBUTE9
, XC.ATTRIBUTE10
, XC.ATTRIBUTE11
, XC.ATTRIBUTE12
, XC.ATTRIBUTE13
, XC.ATTRIBUTE14
, XC.ATTRIBUTE15
, XC.CREATION_DATE
, XC.CREATED_BY
, XC.LAST_UPDATE_DATE
, XC.LAST_UPDATED_BY
, XC.LAST_UPDATE_LOGIN
, XC.REQUEST_ID
, XC.PROGRAM_APPLICATION_ID
, XC.PROGRAM_ID
, XC.PROGRAM_UPDATE_DATE
, XC.QUANTITY2
, XC.UNIT_OF_MEASURE2
, NULL
, NULL
, NULL
, XC.BATCH_ID
FROM WSH_EXCEPTIONS XC
, WSH_EXCEPTION_DEFINITIONS_TL XC_DF
, WSH_EXCEPTION_DEFINITIONS_B XB
, FND_LOOKUP_VALUES FLV
, WSH_LOCATIONS WLO
, WSH_LOCATIONS WLAL
, HR_LOCATIONS_ALL HLA
, MTL_PARAMETERS MP
, WSH_DELIVERY_ASSIGNMENTS WDA
WHERE XC.EXCEPTION_NAME = XC_DF.EXCEPTION_NAME (+)
AND XC.EXCEPTION_LOCATION_ID = WLO.WSH_LOCATION_ID(+)
AND XC.LOGGED_AT_LOCATION_ID = WLAL.WSH_LOCATION_ID(+)
AND WLO.SOURCE_LOCATION_ID = HLA.LOCATION_ID (+)
AND HLA.INVENTORY_ORGANIZATION_ID = MP.ORGANIZATION_ID (+)
AND ( HLA.INVENTORY_ORGANIZATION_ID IS NULL OR (HLA.INVENTORY_ORGANIZATION_ID IS NOT NULL
AND WLO.LOCATION_SOURCE_CODE='HR') )
AND XC.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
AND XC_DF.EXCEPTION_DEFINITION_ID = XB.EXCEPTION_DEFINITION_ID
AND XC_DF.LANGUAGE = USERENV('LANG')
AND XB.EXCEPTION_TYPE = FLV.LOOKUP_CODE
AND FLV.LOOKUP_TYPE = 'EXCEPTION_TYPE'
AND FLV.LANGUAGE = USERENV('LANG') UNION SELECT XC.ROWID
, XC.EXCEPTION_ID
, XC.LOGGED_AT_LOCATION_ID
, WLAL.UI_LOCATION_CODE
, XC.LOGGING_ENTITY
, WSH_XC_UTIL.GET_LOOKUP_MEANING(XC.LOGGING_ENTITY
, 'LOGGING_ENTITY')
, XC.LOGGING_ENTITY_ID
, XC.EXCEPTION_NAME
, XC_DF.DESCRIPTION
, FLV.MEANING
, XC.EXCEPTION_LOCATION_ID
, WLO.UI_LOCATION_CODE
, MP.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, XC.MESSAGE
, DECODE(XC.SEVERITY
, 'HIGH'
, 'ERROR'
, 'MEDIUM'
, 'WARNING'
, 'LOW'
, 'INFO'
, XC.SEVERITY) SEVERITY
, WSH_XC_UTIL.GET_LOOKUP_MEANING(DECODE(XC.SEVERITY
, 'HIGH'
, 'ERROR'
, 'MEDIUM'
, 'WARNING'
, 'LOW'
, 'INFO'
, XC.SEVERITY)
, 'EXCEPTION_BEHAVIOR')
, XC.MANUALLY_LOGGED
, DECODE(XC.STATUS
, 'MANUAL'
, 'OPEN'
, 'LOGGED'
, 'OPEN'
, 'IN_PROCESS'
, 'OPEN'
, 'ERROR'
, 'OPEN'
, 'NOT_HANDLED'
, 'NO_ACTION_REQUIRED'
, NULL
, 'NO_ACTION_REQUIRED'
, XC.STATUS) STATUS
, XC.TRIP_ID
, XC.TRIP_NAME
, XC.TRIP_STOP_ID
, WDA.DELIVERY_ID
, XC.DELIVERY_NAME
, XC.DELIVERY_DETAIL_ID
, XC.DELIVERY_ASSIGNMENT_ID
, XC.CONTAINER_NAME
, XC.INVENTORY_ITEM_ID
, XC.LOT_NUMBER
, XC.REVISION
, XC.SERIAL_NUMBER
, XC.UNIT_OF_MEASURE
, XC.QUANTITY
, XC.SUBINVENTORY
, XC.LOCATOR_ID
, XC.ARRIVAL_DATE
, XC.DEPARTURE_DATE
, XC.ERROR_MESSAGE
, XC.ATTRIBUTE_CATEGORY
, XC.ATTRIBUTE1
, XC.ATTRIBUTE2
, XC.ATTRIBUTE3
, XC.ATTRIBUTE4
, XC.ATTRIBUTE5
, XC.ATTRIBUTE6
, XC.ATTRIBUTE7
, XC.ATTRIBUTE8
, XC.ATTRIBUTE9
, XC.ATTRIBUTE10
, XC.ATTRIBUTE11
, XC.ATTRIBUTE12
, XC.ATTRIBUTE13
, XC.ATTRIBUTE14
, XC.ATTRIBUTE15
, XC.CREATION_DATE
, XC.CREATED_BY
, XC.LAST_UPDATE_DATE
, XC.LAST_UPDATED_BY
, XC.LAST_UPDATE_LOGIN
, XC.REQUEST_ID
, XC.PROGRAM_APPLICATION_ID
, XC.PROGRAM_ID
, XC.PROGRAM_UPDATE_DATE
, XC.QUANTITY2
, XC.UNIT_OF_MEASURE2
, NULL
, NULL
, NULL
, XC.BATCH_ID
FROM WSH_EXCEPTIONS XC
, WSH_EXCEPTION_DEFINITIONS_TL XC_DF
, WSH_EXCEPTION_DEFINITIONS_B XB
, FND_LOOKUP_VALUES FLV
, WSH_LOCATIONS WLO
, WSH_LOCATIONS WLAL
, HR_LOCATIONS_ALL HLA
, MTL_PARAMETERS MP
, WSH_DELIVERY_ASSIGNMENTS WDA
, WSH_DELIVERY_DETAILS WDD
WHERE XC.EXCEPTION_NAME = XC_DF.EXCEPTION_NAME (+)
AND XC.EXCEPTION_LOCATION_ID = WLO.WSH_LOCATION_ID(+)
AND XC.LOGGED_AT_LOCATION_ID = WLAL.WSH_LOCATION_ID(+)
AND WLO.SOURCE_LOCATION_ID = HLA.LOCATION_ID (+)
AND HLA.INVENTORY_ORGANIZATION_ID = MP.ORGANIZATION_ID (+)
AND ( HLA.INVENTORY_ORGANIZATION_ID IS NULL OR (HLA.INVENTORY_ORGANIZATION_ID IS NOT NULL
AND WLO.LOCATION_SOURCE_CODE='HR') )
AND XC.CONTAINER_NAME = WDD.CONTAINER_NAME
AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
AND XC_DF.EXCEPTION_DEFINITION_ID = XB.EXCEPTION_DEFINITION_ID
AND XC_DF.LANGUAGE = USERENV('LANG')
AND XB.EXCEPTION_TYPE = FLV.LOOKUP_CODE
AND FLV.LOOKUP_TYPE = 'EXCEPTION_TYPE'
AND FLV.LANGUAGE = USERENV('LANG')

Columns