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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.HZ_RELATIONSHIP_GROUPINGS_V

Object Details

Object Name:	HZ_RELATIONSHIP_GROUPINGS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AR.HZ_RELATIONSHIP_GROUPINGS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
REL_GROUP_CODE	VARCHAR2	(30)	Yes	Classification code
START_DATE_ACTIVE	DATE		Yes	The date that the class code applies to the organization.
END_DATE_ACTIVE	DATE			The date when the class code is no longer applied.
RELATIONSHIP_TYPE_ID	NUMBER	(15)		Identifies the owner of the class code
RELATIONSHIP_TYPE	VARCHAR2	(30)	Yes	The relationship type name. For example, CUSTOMER_SUPPLIER
FORWARD_REL_CODE	VARCHAR2	(30)	Yes	The forward relationship code used to describe relationships. For example, CUSTOMER_OF
BACKWARD_REL_CODE	VARCHAR2	(30)	Yes	The backward relationship code used to describe relationships. For example, SUPPLIER_OF
ROLE	VARCHAR2	(30)		Unique relationship role lookup code based on relationship type and phrase. In the HZ_RELATIONSHIP_ROLE lookup type meaning is the plural role and description is the singular role.
ROLE_MEANING_SINGULAR	VARCHAR2	(240)		Defines in detail the meaning of a Quickcode
ROLE_MEANING_PLURAL	VARCHAR2	(80)	Yes	Description of the Quickcode
DIRECTION_CODE	VARCHAR2	(30)	Yes	Validated by DIRECTION_CODE lookup type. P for Parent, C for Child, and N for Not Directional
HIERARCHICAL_FLAG	VARCHAR2	(1)	Yes	Indicates a hierarchical relationship type
CREATE_PARTY_FLAG	VARCHAR2	(1)	Yes	Indicates if a party relationship party will be created
ALLOW_RELATE_TO_SELF_FLAG	VARCHAR2	(1)	Yes	Indicates if a party can be related to itself
SUBJECT_TYPE	VARCHAR2	(30)	Yes	Subject type of the relationship type
OBJECT_TYPE	VARCHAR2	(30)	Yes	Object type of the relationship type

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REL_GROUP_CODE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      RELATIONSHIP_TYPE_ID
,      RELATIONSHIP_TYPE
,      FORWARD_REL_CODE
,      BACKWARD_REL_CODE
,      ROLE
,      ROLE_MEANING_SINGULAR
,      ROLE_MEANING_PLURAL
,      DIRECTION_CODE
,      HIERARCHICAL_FLAG
,      CREATE_PARTY_FLAG
,      ALLOW_RELATE_TO_SELF_FLAG
,      SUBJECT_TYPE
,      OBJECT_TYPE
FROM APPS.HZ_RELATIONSHIP_GROUPINGS_V;

Dependencies

[top of page]

APPS.HZ_RELATIONSHIP_GROUPINGS_V references the following:

APPS: AR_LOOKUPS; HZ_CODE_ASSIGNMENTS; HZ_RELATIONSHIP_TYPES

APPS.HZ_RELATIONSHIP_GROUPINGS_V is not referenced by any database object