VIEW: APPS.HZ_DSS_SECURED_CLASSES_V

Source

View Text - Preformatted

SELECT HDC.SECURED_ITEM_ID, HDC.STATUS, HDC.DSS_GROUP_CODE, HDC.OWNER_TABLE_ID1 CLASS_CATEGORY, CAT.MEANING CLASS_CATEGORY_NAME, HDC.OWNER_TABLE_ID2 CLASS_CODE, CC.MEANING CLASS_NAME, CCD.CONCAT_CLASS_CODE, CCD.CONCAT_CLASS_CODE_MEANING CONCAT_CLASS_NAME, HDC.OBJECT_VERSION_NUMBER, HDC.LAST_UPDATE_DATE, HDC.LAST_UPDATED_BY, HDC.CREATION_DATE, HDC.CREATED_BY, HDC.LAST_UPDATE_LOGIN FROM HZ_DSS_CRITERIA HDC, FND_LOOKUP_TYPES_TL CAT, FND_LOOKUP_VALUES_VL CC, HZ_CLASS_CODE_DENORM CCD WHERE HDC.OWNER_TABLE_NAME = 'FND_LOOKUP_VALUES' AND CAT.LOOKUP_TYPE = HDC.OWNER_TABLE_ID1 AND CAT.LANGUAGE = USERENV('LANG') AND CC.LOOKUP_TYPE = HDC.OWNER_TABLE_ID1 AND CC.LOOKUP_CODE = HDC.OWNER_TABLE_ID2 AND CCD.CLASS_CATEGORY (+) = HDC.OWNER_TABLE_ID1 AND CCD.CLASS_CODE (+) = HDC.OWNER_TABLE_ID2 AND CCD.LANGUAGE (+) = USERENV('LANG')

View Text - HTML Formatted

SELECT HDC.SECURED_ITEM_ID
, HDC.STATUS
, HDC.DSS_GROUP_CODE
, HDC.OWNER_TABLE_ID1 CLASS_CATEGORY
, CAT.MEANING CLASS_CATEGORY_NAME
, HDC.OWNER_TABLE_ID2 CLASS_CODE
, CC.MEANING CLASS_NAME
, CCD.CONCAT_CLASS_CODE
, CCD.CONCAT_CLASS_CODE_MEANING CONCAT_CLASS_NAME
, HDC.OBJECT_VERSION_NUMBER
, HDC.LAST_UPDATE_DATE
, HDC.LAST_UPDATED_BY
, HDC.CREATION_DATE
, HDC.CREATED_BY
, HDC.LAST_UPDATE_LOGIN
FROM HZ_DSS_CRITERIA HDC
, FND_LOOKUP_TYPES_TL CAT
, FND_LOOKUP_VALUES_VL CC
, HZ_CLASS_CODE_DENORM CCD
WHERE HDC.OWNER_TABLE_NAME = 'FND_LOOKUP_VALUES'
AND CAT.LOOKUP_TYPE = HDC.OWNER_TABLE_ID1
AND CAT.LANGUAGE = USERENV('LANG')
AND CC.LOOKUP_TYPE = HDC.OWNER_TABLE_ID1
AND CC.LOOKUP_CODE = HDC.OWNER_TABLE_ID2
AND CCD.CLASS_CATEGORY (+) = HDC.OWNER_TABLE_ID1
AND CCD.CLASS_CODE (+) = HDC.OWNER_TABLE_ID2
AND CCD.LANGUAGE (+) = USERENV('LANG')