View: OEFV_ORDER_HOLDS

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

View Text

SELECT '_DF:OE:SO_ORDER_HOLDS:SO_ORDER_HOLDS_ALL'
, LOOKUP.MEANING
, HEADER.ORDER_NUMBER
, LINE.LINE_NUMBER
, ORG.NAME
, PARA.ORGANIZATION_CODE
, ORDHOLD.ORDER_HOLD_ID
, ORDHOLD.HOLD_SOURCE_ID
, ORDHOLD.HOLD_RELEASE_ID
, ORDHOLD.HEADER_ID
, ORDHOLD.LINE_ID
, ORDHOLD.ORG_ID
, ORDHOLD.LAST_UPDATE_DATE
, ORDHOLD.LAST_UPDATED_BY
, ORDHOLD.CREATION_DATE
, ORDHOLD.CREATED_BY
FROM SO_ORDER_HOLDS_ALL ORDHOLD
, SO_HOLD_SOURCES_ALL SRC
, SO_HEADERS_ALL HEADER
, SO_LINES_ALL LINE
, SO_HOLD_RELEASES RELEASE
, MTL_PARAMETERS PARA
, HR_ALL_ORGANIZATION_UNITS ORG
, SO_LOOKUPS LOOKUP
WHERE ORDHOLD.HOLD_SOURCE_ID = SRC.HOLD_SOURCE_ID
AND ORDHOLD.HEADER_ID = HEADER.HEADER_ID
AND PARA.ORGANIZATION_ID(+) = ORDHOLD.ORG_ID
AND ORG.ORGANIZATION_ID(+) = ORDHOLD.ORG_ID
AND ORDHOLD.HOLD_RELEASE_ID = RELEASE.HOLD_RELEASE_ID(+)
AND ORDHOLD.LINE_ID = LINE.LINE_ID(+)
AND LOOKUP.LOOKUP_TYPE(+) = 'RELEASE_REASON'
AND LOOKUP.LOOKUP_CODE(+) = RELEASE.RELEASE_REASON_CODE WITH READ ONLY

Columns