機械翻訳について

PO_UN_NUMBERS_VAL_V

詳細

• スキーマ: FUSION

• オブジェクト所有者: PO

• オブジェクト・タイプ: VIEW

列

名前
UN_NUMBER DESCRIPTION HAZARD_CLASS HAZARD_CLASS_ID UN_NUMBER_ID

問合せ

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)