VIEW: APPS.OEFV_HOLD_REASONS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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