View: SO_ORDER_HOLDS_VIEW_HOLD_V

Product:	OE - Order Entry
Description:
Implementation/DBA Data:	APPS.SO_ORDER_HOLDS_VIEW_HOLD_V

View Text

SELECT SOH.ORDER_HOLD_ID ORDER_HOLD_ID
, SH.NAME NAME
, SOENT.NAME CRITERIA
, SE.NAME HOLD_LEVEL
, SA.NAME ACTION
, SHS.HOLD_UNTIL_DATE HOLD_UNTIL_DATE
, SHR.CREATION_DATE RELEASE_DATE
, FDU.USER_NAME RELEASER
, SOH.LINE_ID LINE_ID
, SOH.HOLD_SOURCE_ID
, SHS.HOLD_ENTITY_CODE
, SHS.HOLD_ENTITY_ID HOLD_ENTITY_ID
, SOH.HEADER_ID
, SOH.CREATION_DATE
, SOH.CREATED_BY
, SOH.LAST_UPDATE_DATE
, SOH.LAST_UPDATED_BY
, SOH.LAST_UPDATE_LOGIN
, SOH.ROWID ROW_ID
FROM SO_ORDER_HOLDS SOH
, SO_HOLDS SH
, SO_HOLD_SOURCES SHS
, SO_ENTITIES SE
, SO_ACTIONS SA
, SO_HOLD_RELEASES SHR
, SO_ENTITIES SOENT
, FND_USER FDU
WHERE SHS.HOLD_SOURCE_ID (+) = SOH.HOLD_SOURCE_ID
AND SH.HOLD_ID(+)= SHS.HOLD_ID
AND SE.ENTITY_CODE(+) = SHS.HOLD_ENTITY_CODE
AND SA.ACTION_ID(+) = SH.ACTION_ID
AND SHR.HOLD_RELEASE_ID(+) = NVL(SOH.HOLD_RELEASE_ID
, -1 )
AND FDU.USER_ID(+) = SHR.CREATED_BY
AND SOENT.ENTITY_CODE(+) = SHS.HOLD_ENTITY_CODE

Columns