View: PO_UN_NUMBERS_VAL_V

Product:	PO - Purchasing
Description:	10SC ONLY - Retrofitted
Implementation/DBA Data:	APPS.PO_UN_NUMBERS_VAL_V

View Text

SELECT PUN.UN_NUMBER
, PUN.DESCRIPTION
, POH.HAZARD_CLASS
, PUN.HAZARD_CLASS_ID
, PUN.UN_NUMBER_ID
FROM PO_UN_NUMBERS PUN
, PO_HAZARD_CLASSES 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 PUN
WHERE PUN.HAZARD_CLASS_ID IS NULL
AND SYSDATE < NVL(PUN.INACTIVE_DATE
, SYSDATE +1)

Columns