View: AMW_OBJ_CLASSIFICATION_V

Product:	AMW - Internal Controls Manager
Description:	View for all the classifications
Implementation/DBA Data:	APPS.AMW_OBJ_CLASSIFICATION_V

View Text

SELECT TYPES.WORK_TYPE_ID WORK_TYPE_ID
, TYPES.WORK_TYPE_NAME WORK_TYPE_NAME
, CAT.CATEGORY_CODE CATEGORY_CODE
FROM AMW_WORK_TYPES_VL TYPES
, AMW_WORK_CATEGORIES_B CAT
WHERE TYPES.PROJECT_TYPE_ID IS NULL
AND TYPES.START_DATE <= SYSDATE
AND (TYPES.END_DATE > SYSDATE OR TYPES.END_DATE IS NULL)
AND TYPES.CATEGORY_ID = CAT.CATEGORY_ID

Columns