[Home] [Help] [Dependency Information]

TABLE: AR.HZ_ORG_PROFILES_EXT_SG

Object Details

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

The HZ_ORG_PROFILES_EXT_SG staging table stores organization profile tracking
data to use for copying extensions data.

Depending on the HZ: Profile Version Method for Updates profile option
setting, when organization profiles are updated, the existing profile record
can be set with an end date, and a new profile record created with the newly
entered information.
Extensions are custom attributes that extend the data model and store
additional information, in this case, for organization profile. The Copy
Organization Extensions Data for Profile Versioning program uses this staging
table to copy extensions data associated with the old profile identifier and
create new rows associated with the new profile record, in the extensions
tables. This staging table stores identifiers of all old and new profile
versions that need this processing.

For example, the old profile identifier is 123, and there are five rows in
the HZ_ORG_PROFILES_EXT tables with extended attribute values for that
profile (the ORGANIZATION_ PROFILE_ID column is 123). The user updates the
profile information and creates a new version with identifier 456. The
extensions data is still linked to record 123. This staging table would store
123 as the old identifier and 456 as the new identifier. When the Copy
Organization Extensions Data for Profile Versioning program runs, it copies
the extensions data for 123 and creates new extensions records with
ORGANIZATION_ PROFILE_ID column as 456.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Query Text

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

SELECT OLD_PROFILE_ID
,      NEW_PROFILE_ID
,      WORK_UNIT_NUMBER
,      STATUS
FROM AR.HZ_ORG_PROFILES_EXT_SG;

Dependencies

[top of page]

AR.HZ_ORG_PROFILES_EXT_SG does not reference any database object

AR.HZ_ORG_PROFILES_EXT_SG is referenced by following:

AR

HZ_ORG_PROFILES_EXT_SG#