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
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
|
|
|