View: OE_ORDER_HOLDS_V

Product:	ONT - Order Management
Description:	View for releasing orders from hold.
Implementation/DBA Data:	APPS.OE_ORDER_HOLDS_V

View Text

SELECT OH.ORDER_HOLD_ID
, OH.CREATION_DATE
, OH.CREATED_BY
, FU.USER_NAME
, OH.LAST_UPDATE_DATE
, OH.LAST_UPDATED_BY
, OH.LAST_UPDATE_LOGIN
, OH.PROGRAM_APPLICATION_ID
, OH.PROGRAM_ID
, OH.PROGRAM_UPDATE_DATE
, OH.REQUEST_ID
, OH.HOLD_SOURCE_ID
, OH.HOLD_RELEASE_ID
, OH.HEADER_ID
, OH.LINE_ID
, HD.ITEM_TYPE
, HS.HOLD_ID
, HD.NAME
, OH.RELEASED_FLAG
, HD.PROGRESS_WF_ON_RELEASE_FLAG
, OH.CONTEXT
, OH.ATTRIBUTE1
, OH.ATTRIBUTE2
, OH.ATTRIBUTE3
, OH.ATTRIBUTE4
, OH.ATTRIBUTE5
, OH.ATTRIBUTE6
, OH.ATTRIBUTE7
, OH.ATTRIBUTE8
, OH.ATTRIBUTE9
, OH.ATTRIBUTE10
, OH.ATTRIBUTE11
, OH.ATTRIBUTE12
, OH.ATTRIBUTE13
, OH.ATTRIBUTE14
, OH.ATTRIBUTE15
, OH.ORG_ID
FROM OE_ORDER_HOLDS OH
, OE_HOLD_SOURCES HS
, OE_HOLD_DEFINITIONS HD
, FND_USER FU
WHERE OH.HOLD_SOURCE_ID = HS.HOLD_SOURCE_ID
AND OH.RELEASED_FLAG = 'N'
AND HS.HOLD_ID = HD.HOLD_ID
AND OH.CREATED_BY = FU.USER_ID

Columns