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_TRACKING

Object Details

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

The HZ_BUS_OBJ_TRACKING table is an internal TCA table that tracks the granular (V2) entities that have been created or updated. The stored information includes information about updated or created parent and child entities, as well as last update date and creation date for child entities. These granularmodifications are collected so that the appropriate Business Object Event can be raised.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HZ_BUS_OBJ_TRACKING_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EVENT_ID CHILD_ENTITY_NAME CHILD_ID CHILD_BO_CODE PARENT_BO_CODE
HZ_BUS_OBJ_TRACKING_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_ID PARENT_BO_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
CHILD_ENTITY_NAME	VARCHAR2	(40)	Yes	Table name of child entity
CHILD_ID	NUMBER	(15)	Yes	TCA identifier of child entity
CHILD_OPERATION_FLAG	VARCHAR2	(1)	Yes	Indicates operation performed on child entity. C for create, U for update, and P for populate as part of the update branch.
POPULATED_FLAG	VARCHAR2	(1)	Yes	Indicates if record is populated as part of finding missing links. Y for yes, N for no.
LAST_UPDATE_DATE	DATE		Yes	Last update date of child entity
CREATION_DATE	DATE		Yes	Creation date of child entity
PARENT_BO_CODE	VARCHAR2	(30)		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
PARENT_ENTITY_NAME	VARCHAR2	(40)		Lookup code of child business object, from HZ_BUSINESS_OBJECTS lookup type
PARENT_ID	NUMBER	(15)		TCA identifier of parent entity
PARENT_EVENT_FLAG	VARCHAR2	(1)		Indicates event type for parent business object. C for create, U for update, null for no event identified.
EVENT_ID	NUMBER	(15)		Identifier for objects Business Object event
CHILD_EVENT_ID	NUMBER	(15)		Not currently used
DELETE_FLAG	VARCHAR2	(1)		Indicates if event was already raised and processed for business object, and object is ready for deletion.

Query Text

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


SELECT CHILD_ENTITY_NAME
,      CHILD_ID
,      CHILD_OPERATION_FLAG
,      POPULATED_FLAG
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      PARENT_BO_CODE
,      CHILD_BO_CODE
,      PARENT_ENTITY_NAME
,      PARENT_ID
,      PARENT_EVENT_FLAG
,      EVENT_ID
,      CHILD_EVENT_ID
,      DELETE_FLAG
FROM AR.HZ_BUS_OBJ_TRACKING;

Dependencies

[top of page]

AR.HZ_BUS_OBJ_TRACKING does not reference any database object

AR.HZ_BUS_OBJ_TRACKING is referenced by following:

AR: HZ_BUS_OBJ_TRACKING#