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]

TABLE: AR.HZ_BUS_OBJ_DEFINITIONS

Object Details

Object Name:	HZ_BUS_OBJ_DEFINITIONS
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.HZ_BUS_OBJ_DEFINITIONS
Subobject Name:
Status:	VALID

The HZ_BUS_OBJ_DEFINITIONS table provides detailed information regarding the structure of Trading Community Architecture (TCA) business objects. Each business object is described by its underlying root TCA entity, child TCA entities, and child TCA business objects. The table also includes information regarding the cardinality of embedded entities and objects for a given business object, as well as details indicating the mandatory elements of a business object.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HZ_BUS_OBJ_DEFINITIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BUSINESS_OBJECT_CODE CHILD_BO_CODE ENTITY_NAME ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
BUSINESS_OBJECT_CODE	VARCHAR2	(30)	Yes	Lookup code of parent business object, from HZ_BUSINESS_OBJECTS lookup type
CHILD_BO_CODE	VARCHAR2	(30)		Lookup code of child business object, from HZ_BUSINESS_OBJECTS lookup type
ENTITY_NAME	VARCHAR2	(40)	Yes	Table name of child entity
TCA_MANDATED_FLAG	VARCHAR2	(1)	Yes	Indicates if child entity or object is mandatory for this business object by default. Y for yes, N or no.
USER_MANDATED_FLAG	VARCHAR2	(1)	Yes	Indicates if child entity or object is mandatory for this business object. Y for yes, N for no.
ROOT_NODE_FLAG	VARCHAR2	(1)	Yes	Indicates if child entity or object is root node for the business object. Y for yes, N for no. One root per business object.
BO_INDICATOR_FLAG	VARCHAR2	(1)	Yes	Indicates if child is a business object or entity. Y for business object, N for entity
DISPLAY_FLAG	VARCHAR2	(1)	Yes	Indicates if child entity or object is displayed in Administration UI. Y for yes, N or null for no.
MULTIPLE_FLAG	VARCHAR2	(1)	Yes	Indicates if child entity or object can exist multiple times in business object. Y for yes, N for no.
BO_VERSION_NUMBER	NUMBER	(15)		Version of business object definition
OBJECT_VERSION_NUMBER	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)		Standard Who column
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT BUSINESS_OBJECT_CODE
,      CHILD_BO_CODE
,      ENTITY_NAME
,      TCA_MANDATED_FLAG
,      USER_MANDATED_FLAG
,      ROOT_NODE_FLAG
,      BO_INDICATOR_FLAG
,      DISPLAY_FLAG
,      MULTIPLE_FLAG
,      BO_VERSION_NUMBER
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      ZD_EDITION_NAME
FROM AR.HZ_BUS_OBJ_DEFINITIONS;

Dependencies

[top of page]

AR.HZ_BUS_OBJ_DEFINITIONS does not reference any database object

AR.HZ_BUS_OBJ_DEFINITIONS is referenced by following:

AR: HZ_BUS_OBJ_DEFINITIONS#