[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | HZ_CLASS_CATEGORY_GROUPINGS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  AR.HZ_CLASS_CATEGORY_GROUPINGS_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view lists all Classification Categories grouped by
Category Group. This view only shows active data. That is, the Category
Group must be active as well as the Classification Category assignment to the
group.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CATEGORY_GROUP_CODE | VARCHAR2 | (30) | Yes | Code to uniquely identify a class category group |
| CATEGORY_GROUP_MEANING | VARCHAR2 | (80) | Yes | Class category group meaning |
| CATEGORY_GROUP_DESCRIPTION | VARCHAR2 | (240) | Class category group description | |
| CLASS_CATEGORY | VARCHAR2 | (30) | Yes | Class category that belongs to the group |
| CATEGORY_MEANING | VARCHAR2 | (80) | Yes | Class category meaning |
| CATEGORY_DESCRIPTION | VARCHAR2 | (240) | Class category description | |
| GROUPING_START_DATE | DATE | Yes | Date the class category became a member of the class category group | |
| GROUPING_END_DATE | DATE | Date the class category ceased to be a member of the class category group | ||
| GROUP_START_DATE | DATE | Date the class category became valid | ||
| GROUP_END_DATE | DATE | Date the class category ceased to be valid | ||
| ALLOW_MULTI_ASSIGN_FLAG | VARCHAR2 | (1) | Yes | Y or N indicates whether codes under this category can be assigned to an object more than once or not |
| ALLOW_MULTI_PARENT_FLAG | VARCHAR2 | (1) | Yes | Y or N indicates whether codes under this category can have multiple parent codes or not |
| ALLOW_LEAF_NODE_ONLY_FLAG | VARCHAR2 | (1) | Y or N indicates whether or not the instances of those entities associated with this particular CLASS_CATEGORY can only be assigned to leaf node class codes of that particular CLASS_CATEGORY | |
| OBJECT_VERSION_NUMBER | NUMBER | Used for locking purposes | ||
| DELIMITER | VARCHAR2 | (1) | Used for concatenated class code in the HZ_CLASS_CODE_DENORM table | |
| FROZEN_FLAG | VARCHAR2 | (1) | Y or N indicates whether the data in the HZ_CLASS_CODE_DENORM table for this class category is valid or not. The Refresh of Classification Denormalization program refreshes the data |
Cut, paste (and edit) the following text to query this object:
SELECT CATEGORY_GROUP_CODE
, CATEGORY_GROUP_MEANING
, CATEGORY_GROUP_DESCRIPTION
, CLASS_CATEGORY
, CATEGORY_MEANING
, CATEGORY_DESCRIPTION
, GROUPING_START_DATE
, GROUPING_END_DATE
, GROUP_START_DATE
, GROUP_END_DATE
, ALLOW_MULTI_ASSIGN_FLAG
, ALLOW_MULTI_PARENT_FLAG
, ALLOW_LEAF_NODE_ONLY_FLAG
, OBJECT_VERSION_NUMBER
, DELIMITER
, FROZEN_FLAG
FROM APPS.HZ_CLASS_CATEGORY_GROUPINGS_V;
APPS
FND_LOOKUP_TYPES_VL
FND_LOOKUP_VALUES_VL
HZ_CLASS_CATEGORIES
HZ_CODE_ASSIGNMENTS
APPS.HZ_CLASS_CATEGORY_GROUPINGS_V is not referenced by any database object
|
|
|
|