VIEW: APPS.OE_ORDER_HOLDS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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