[Home] [Help]
View: OEFV_ORDER_HOLD_REASONS
| Product: | OE - Order Entry |
|---|
| Description: | - Retrofitted |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT HOLD.NAME
, LOOKUP.MEANING
, HOLD.DESCRIPTION
, HOLD.START_DATE_ACTIVE
, HOLD.END_DATE_ACTIVE
, '_DF:OE:SO_HOLDS:HOLD'
, ACTION.NAME
, HOLD.HOLD_ID
, HOLD.ACTION_ID
, HOLD.LAST_UPDATE_DATE
, HOLD.LAST_UPDATED_BY
, HOLD.CREATION_DATE
, HOLD.CREATED_BY
FROM SO_HOLDS HOLD
, SO_ACTIONS ACTION
, SO_LOOKUPS LOOKUP
WHERE HOLD.ACTION_ID = ACTION.ACTION_ID(+)
AND LOOKUP.LOOKUP_TYPE = 'HOLD_TYPE'
AND LOOKUP.LOOKUP_CODE = HOLD.TYPE_CODE WITH READ ONLY
Columns
| Name |
| NAME |
| TYPE |
| DESCRIPTION |
| START_DATE |
| END_DATE |
| "_DF" |
| ACTION_NAME |
| HOLD_ID |
| ACTION_ID |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| CREATION_DATE |
| CREATED_BY |