View: POR_HAZARD_CLASS_LOV_V

Product:	ICX - Oracle iProcurement
Description:	List of values for hazard classes
Implementation/DBA Data:	APPS.POR_HAZARD_CLASS_LOV_V

View Text

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

Columns