[Home] [Help]
View: OEFV_HOLD_REASONS
| Product: | ONT - Order Management |
| Description: | Full BIS Business View for Order Hold Reasons. |
| Implementation/DBA Data: |
APPS.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 |