View: OE_HOLDS_HISTORY_V

Product:	ONT - Order Management
Description:
Implementation/DBA Data:	APPS.OE_HOLDS_HISTORY_V

View Text

SELECT OH.HEADER_ID
, OH.LINE_ID
, 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.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
, HR.CREATION_DATE RELEASED_DATE
, OE_HOLDS_PVT.USER_NAME(HR.CREATED_BY) RELEASED_BY
, HR.RELEASE_REASON_CODE
, HR.RELEASE_COMMENT
FROM OE_ORDER_HOLDS_ALL OH
, OE_HOLD_SOURCES HS
, OE_HOLD_RELEASES HR
, OE_HOLD_DEFINITIONS HD
, FND_USER FU
, FND_LOOKUP_VALUES FLV
, FND_LOOKUP_VALUES FLV2
WHERE OH.HOLD_SOURCE_ID = HS.HOLD_SOURCE_ID
AND HS.HOLD_ID = HD.HOLD_ID
AND HS.CREATED_BY = FU.USER_ID
AND OH.HOLD_RELEASE_ID = HR.HOLD_RELEASE_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)
AND HS.ORG_ID = OH.ORG_ID

Columns