PO_UN_NUMBERS_VAL_V

Details

• Schema: FUSION

• Object owner: PO

• Object type: VIEW

Columns

Name
UN_NUMBER DESCRIPTION HAZARD_CLASS HAZARD_CLASS_ID UN_NUMBER_ID

Query

SQL_Statement

SELECT PUN.UN_NUMBER, PUN.DESCRIPTION, POH.HAZARD_CLASS, PUN.HAZARD_CLASS_ID, PUN.UN_NUMBER_ID FROM PO_UN_NUMBERS_VL PUN, PO_HAZARD_CLASSES_VL POH WHERE SYSDATE < NVL(PUN.INACTIVE_DATE, SYSDATE +1) AND PUN.HAZARD_CLASS_ID IS NOT NULL AND PUN.HAZARD_CLASS_ID = POH.HAZARD_CLASS_ID UNION SELECT PUN.UN_NUMBER, PUN.DESCRIPTION, NULL, PUN.HAZARD_CLASS_ID, PUN.UN_NUMBER_ID FROM PO_UN_NUMBERS_VL PUN WHERE PUN.HAZARD_CLASS_ID IS NULL AND SYSDATE < NVL(PUN.INACTIVE_DATE, SYSDATE +1)