[Home] [Help]
View: OEBV_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'
, 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_LOOKUPS LOOKUP
WHERE 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" |
HOLD_ID |
ACTION_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |