View: OE_HOLD_SOURCES_V

Product:	ONT - Order Management
Description:	This view is used in the Holds form to display all the holds.
Implementation/DBA Data:	APPS.OE_HOLD_SOURCES_V

View Text

SELECT HS.HOLD_SOURCE_ID
, HS.LAST_UPDATE_DATE
, HS.LAST_UPDATED_BY
, HS.CREATION_DATE
, HS.CREATED_BY
, FU.USER_NAME
, HS.LAST_UPDATE_LOGIN
, HS.PROGRAM_APPLICATION_ID
, HS.PROGRAM_ID
, HS.PROGRAM_UPDATE_DATE
, HS.REQUEST_ID
, HS.HOLD_ID
, HD.NAME
, HS.HOLD_ENTITY_CODE
, FLV.MEANING
, HS.HOLD_ENTITY_ID
, OE_HOLDS_PVT.ENTITY_ID_VALUE ( HS.HOLD_ENTITY_CODE
, HS.HOLD_ENTITY_ID) HOLD_ENTITY_ID_VALUE
, HS.HOLD_UNTIL_DATE
, HS.RELEASED_FLAG
, HS.HOLD_COMMENT
, HS.CONTEXT
, HS.ATTRIBUTE1
, HS.ATTRIBUTE2
, HS.ATTRIBUTE3
, HS.ATTRIBUTE4
, HS.ATTRIBUTE5
, HS.ATTRIBUTE6
, HS.ATTRIBUTE7
, HS.ATTRIBUTE8
, HS.ATTRIBUTE9
, HS.ATTRIBUTE10
, HS.ATTRIBUTE11
, HS.ATTRIBUTE12
, HS.ATTRIBUTE13
, HS.ATTRIBUTE14
, HS.ATTRIBUTE15
, HS.ORG_ID
, HS.HOLD_RELEASE_ID
, HS.HOLD_ENTITY_CODE2
, FLV2.MEANING
, HS.HOLD_ENTITY_ID2
, OE_HOLDS_PVT.ENTITY_ID_VALUE ( HS.HOLD_ENTITY_CODE2
, HS.HOLD_ENTITY_ID2) HOLD_ENTITY_ID2_VALUE
FROM OE_HOLD_SOURCES HS
, OE_HOLD_DEFINITIONS HD
, FND_USER FU
, FND_LOOKUP_VALUES FLV
, FND_LOOKUP_VALUES FLV2
WHERE HS.HOLD_ID = HD.HOLD_ID
AND HS.HOLD_RELEASE_ID IS NULL
AND HS.CREATED_BY = FU.USER_ID
AND FLV.LOOKUP_CODE = HS.HOLD_ENTITY_CODE
AND FLV.LOOKUP_TYPE = 'HOLD_ENTITY_DESC'
AND FLV.LANGUAGE = USERENV('LANG')
AND FLV.VIEW_APPLICATION_ID = 660
AND FLV.SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(FLV.LOOKUP_TYPE
, FLV.VIEW_APPLICATION_ID)
AND FLV2.LOOKUP_CODE(+) = HS.HOLD_ENTITY_CODE2
AND FLV2.LOOKUP_TYPE(+) = 'HOLD_ENTITY_DESC'
AND FLV2.LANGUAGE(+) = USERENV('LANG')
AND FLV2.VIEW_APPLICATION_ID(+) = 660
AND FLV2.SECURITY_GROUP_ID(+) = FND_GLOBAL.LOOKUP_SECURITY_GROUP('HOLD_ENTITY_DESC'
, 660)

Columns