VIEW: APPS.SO_ORDER_HOLDS_VIEW_HOLD_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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