[Home] [Help]
View: POFV_UN_NUMBERS
View Text
SELECT UN.UN_NUMBER_ID
, UN.UN_NUMBER
, UN.DESCRIPTION
, UN.INACTIVE_DATE
, '_DF:PO:PO_UN_NUMBERS:UN'
, UN.HAZARD_CLASS_ID
, HC.HAZARD_CLASS
, UN.CREATION_DATE
, UN.CREATED_BY
, UN.LAST_UPDATE_DATE
, UN.LAST_UPDATED_BY
FROM PO_UN_NUMBERS UN
, PO_HAZARD_CLASSES HC
WHERE UN.HAZARD_CLASS_ID = HC.HAZARD_CLASS_ID(+) WITH READ ONLY
Columns
Name |
UN_NUMBER_ID |
UN_NUMBER |
DESCRIPTION |
INACTIVE_DATE |
"_DF" |
HAZARD_CLASS_ID |
HAZARD_CLASS |
CREATED_DATE |
CREATED_BY |
LAST_UPDATED_DATE |
LAST_UPDATED_BY |