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

TABLE: AR.HZ_IMP_WORK_UNITS

Object Details
Object Name: HZ_IMP_WORK_UNITS
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.HZ_IMP_WORK_UNITS
Subobject Name:
Status: VALID


The TCA import process uses the HZ_IMP_WORK_UNITS table to manage work units. Each batch is broken into several sets of records, called work units. The work unit concept is used to improve import performance


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER (15)
Unique identifier for the batch
ORIG_SYSTEM VARCHAR2 (30)
Unique identifier for the original system
FROM_ORIG_SYSTEM_REF VARCHAR2 (240)
Indicates the value of the first original system reference in the work unit range
TO_ORIG_SYSTEM_REF VARCHAR2 (240)
Value of the last original system reference in the work unit range
BATCH_DEDUP_STAGE NUMBER

Indicates the stage of the work unit for De-Duplication
BATCH_DEDUP_STATUS VARCHAR2 (30)
Indicates the status of the work unit for De-Duplication
STATUS VARCHAR2 (30)
Indicates the status of the work unit
STAGE NUMBER

Indicates the stage of the work unit
HWM_STAGE NUMBER

Indicates the high water mark stage of the work unit
POSTPROCESS_STATUS VARCHAR2 (30)
Status of the work unit for postprocessing.
Query Text

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


SELECT BATCH_ID
,      ORIG_SYSTEM
,      FROM_ORIG_SYSTEM_REF
,      TO_ORIG_SYSTEM_REF
,      BATCH_DEDUP_STAGE
,      BATCH_DEDUP_STATUS
,      STATUS
,      STAGE
,      HWM_STAGE
,      POSTPROCESS_STATUS
FROM AR.HZ_IMP_WORK_UNITS;

Dependencies

[top of page]

AR.HZ_IMP_WORK_UNITS does not reference any database object

AR.HZ_IMP_WORK_UNITS is referenced by following:

SchemaAR
ViewHZ_IMP_WORK_UNITS#