FND Design Data [Home] [Help]

View: OEFV_HOLD_REASONS

Product: ONT - Order Management
Description: Full BIS Business View for Order Hold Reasons.
Implementation/DBA Data: ViewAPPS.OEFV_HOLD_REASONS
View Text

SELECT HOLD.NAME
, '_LA:TYPE_CODE:OE_LOOKUPS:HOLD_TYPE:MEANING'
, HOLD.DESCRIPTION
, HOLD.START_DATE_ACTIVE
, HOLD.END_DATE_ACTIVE
, '_DF:ONT:OE_HOLD_DEFINITIONS:HOLD'
, HOLD.HOLD_ID
, HOLD.ITEM_TYPE
, HOLD.ACTIVITY_NAME
, HOLD.LAST_UPDATE_DATE
, HOLD.LAST_UPDATED_BY
, HOLD.CREATION_DATE
, HOLD.CREATED_BY
FROM OE_HOLD_DEFINITIONS HOLD WITH READ ONLY

Columns

Name
NAME
"_LA:HOLD_TYPE"
DESCRIPTION
START_DATE
END_DATE
"_DF"
HOLD_ID
ITEM_TYPE
ACTIVITY_NAME
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY