View: OEFV_ORDER_HOLDS

Product:	ONT - Order Management
Description:	Full BIS Business View for Order Holds.
Implementation/DBA Data:	APPS.OEFV_ORDER_HOLDS

View Text

SELECT HEADER.ORDER_NUMBER
, '_LA:RELEASE.RELEASE_REASON_CODE:OE_LOOKUPS:RELEASE_REASON:MEANING'
, ORDHOLD.ORDER_HOLD_ID
, ORDHOLD.HOLD_SOURCE_ID
, ORDHOLD.HOLD_RELEASE_ID
, ORDHOLD.HEADER_ID
, ORDHOLD.LINE_ID
, ORDHOLD.ORG_ID
, '_LA:SRC.HOLD_ENTITY_CODE:OE_LOOKUPS:HOLD_ENTITY_TYPE:MEANING'
, SRC.HOLD_ENTITY_ID
, ORDHOLD.LAST_UPDATE_DATE
, ORDHOLD.LAST_UPDATED_BY
, ORDHOLD.CREATION_DATE
, ORDHOLD.CREATED_BY
FROM OE_ORDER_HOLDS_ALL ORDHOLD
, OE_HOLD_SOURCES_ALL SRC
, OE_ORDER_HEADERS_ALL HEADER
, OE_HOLD_RELEASES RELEASE
, MTL_PARAMETERS PARA
WHERE ORDHOLD.HEADER_ID = HEADER.HEADER_ID
AND ORDHOLD.HOLD_SOURCE_ID = SRC.HOLD_SOURCE_ID
AND ORDHOLD.ORG_ID = PARA.ORGANIZATION_ID(+)
AND ORDHOLD.HOLD_RELEASE_ID = RELEASE.HOLD_RELEASE_ID(+)
AND '_SEC:ORDHOLD.ORG_ID' IS NOT NULL WITH READ ONLY

Columns