VIEW: APPS.HZ_CLASS_CATEGORY_V

Source

View Text - Preformatted

SELECT HzClassCategories.CLASS_CATEGORY , HzClassCategories.ALLOW_MULTI_ASSIGN_FLAG , HzClassCategories.ALLOW_MULTI_PARENT_FLAG , HzClassCategories.ALLOW_LEAF_NODE_ONLY_FLAG , HzClassCategories.DELIMITER , FndLookupTypesVl.MEANING , FndLookupTypesVl.DESCRIPTION , HzClassCategories.CREATED_BY , HzClassCategories.CREATION_DATE , HzClassCategories.LAST_UPDATE_DATE , HzClassCategories.LAST_UPDATED_BY , HzClassCategories.CREATED_BY_MODULE , HzClassCategories.APPLICATION_ID , HzClassCategories.FROZEN_FLAG , HzClassCategories.LAST_UPDATE_LOGIN , FndLookupTypesVl.CUSTOMIZATION_LEVEL, FndLookupTypesVl.SECURITY_GROUP_ID, FndLookupTypesVl.VIEW_APPLICATION_ID, HzClassCategories.OBJECT_VERSION_NUMBER FROM FND_LOOKUP_TYPES_VL FndLookupTypesVl, HZ_CLASS_CATEGORIES HzClassCategories WHERE HzClassCategories.CLASS_CATEGORY = FndLookupTypesVl.LOOKUP_TYPE

View Text - HTML Formatted

SELECT HZCLASSCATEGORIES.CLASS_CATEGORY
, HZCLASSCATEGORIES.ALLOW_MULTI_ASSIGN_FLAG
, HZCLASSCATEGORIES.ALLOW_MULTI_PARENT_FLAG
, HZCLASSCATEGORIES.ALLOW_LEAF_NODE_ONLY_FLAG
, HZCLASSCATEGORIES.DELIMITER
, FNDLOOKUPTYPESVL.MEANING
, FNDLOOKUPTYPESVL.DESCRIPTION
, HZCLASSCATEGORIES.CREATED_BY
, HZCLASSCATEGORIES.CREATION_DATE
, HZCLASSCATEGORIES.LAST_UPDATE_DATE
, HZCLASSCATEGORIES.LAST_UPDATED_BY
, HZCLASSCATEGORIES.CREATED_BY_MODULE
, HZCLASSCATEGORIES.APPLICATION_ID
, HZCLASSCATEGORIES.FROZEN_FLAG
, HZCLASSCATEGORIES.LAST_UPDATE_LOGIN
, FNDLOOKUPTYPESVL.CUSTOMIZATION_LEVEL
, FNDLOOKUPTYPESVL.SECURITY_GROUP_ID
, FNDLOOKUPTYPESVL.VIEW_APPLICATION_ID
, HZCLASSCATEGORIES.OBJECT_VERSION_NUMBER
FROM FND_LOOKUP_TYPES_VL FNDLOOKUPTYPESVL
, HZ_CLASS_CATEGORIES HZCLASSCATEGORIES
WHERE HZCLASSCATEGORIES.CLASS_CATEGORY = FNDLOOKUPTYPESVL.LOOKUP_TYPE