eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: HZ_CLASS_CATEGORY_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.HZ_CLASS_CATEGORY_V

View Text

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

Columns

Name
CLASS_CATEGORY
ALLOW_MULTI_ASSIGN_FLAG
ALLOW_MULTI_PARENT_FLAG
ALLOW_LEAF_NODE_ONLY_FLAG
DELIMITER
MEANING
DESCRIPTION
CREATED_BY
CREATION_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATED_BY_MODULE
APPLICATION_ID
FROZEN_FLAG
LAST_UPDATE_LOGIN
CUSTOMIZATION_LEVEL
SECURITY_GROUP_ID
VIEW_APPLICATION_ID
OBJECT_VERSION_NUMBER