SELECT phc.hazard_class, pun.un_number from po_hazard_classes phc, po_un_numbers pun where sysdate < nvl(phc.INACTIVE_DATE, sysdate+1) and sysdate < nvl(pun.INACTIVE_DATE, sysdate+1) and phc.hazard_class_id = pun.hazard_class_id
SELECT PHC.HAZARD_CLASS
, PUN.UN_NUMBER
FROM PO_HAZARD_CLASSES PHC
, PO_UN_NUMBERS PUN
WHERE SYSDATE < NVL(PHC.INACTIVE_DATE
, SYSDATE+1)
AND SYSDATE < NVL(PUN.INACTIVE_DATE
, SYSDATE+1)
AND PHC.HAZARD_CLASS_ID = PUN.HAZARD_CLASS_ID
|
|
|