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_PARTY_SITE_USES

Object Details

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

The HZ_PARTY_SITE_USES table stores information about how a party site is used. Party sites can have multiple uses, for example Ship-To and Bill-To.
.
The primary key for this table is PARTY_SITE_USE_ID.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: HZ_PARTY_SITE_USES_PK

PARTY_SITE_USE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
HZ_PARTY_SITE_USES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PARTY_SITE_USE_ID
HZ_PARTY_SITE_USES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARTY_SITE_ID SITE_USE_TYPE PRIMARY_PER_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
PARTY_SITE_USE_ID	NUMBER	(15)	Yes	Party site use identifier
BEGIN_DATE	DATE			No longer used
COMMENTS	VARCHAR2	(240)		A textual description of the possible use of a site by a party
END_DATE	DATE			No longer used
PARTY_SITE_ID	NUMBER	(15)	Yes	Identifier for the party site. Foreign key to the HZ_PARTY_SITES table
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
PROGRAM_ID	NUMBER	(15)		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
WH_UPDATE_DATE	DATE			No longer used
SITE_USE_TYPE	VARCHAR2	(30)	Yes	Site use type
PRIMARY_PER_TYPE	VARCHAR2	(1)		Indicates if this is the primary use for this site. Y for the primary site, N for all other sites.
STATUS	VARCHAR2	(1)		Indicates if this is an Active or Inactive site. A for active, I for inactive.
OBJECT_VERSION_NUMBER	NUMBER			This column is used for locking purposes
CREATED_BY_MODULE	VARCHAR2	(150)		TCA Who column
APPLICATION_ID	NUMBER			TCA Who column

Query Text

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


SELECT PARTY_SITE_USE_ID
,      BEGIN_DATE
,      COMMENTS
,      END_DATE
,      PARTY_SITE_ID
,      LAST_UPDATE_DATE
,      REQUEST_ID
,      LAST_UPDATED_BY
,      PROGRAM_APPLICATION_ID
,      CREATION_DATE
,      PROGRAM_ID
,      CREATED_BY
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      WH_UPDATE_DATE
,      SITE_USE_TYPE
,      PRIMARY_PER_TYPE
,      STATUS
,      OBJECT_VERSION_NUMBER
,      CREATED_BY_MODULE
,      APPLICATION_ID
FROM AR.HZ_PARTY_SITE_USES;

Dependencies

[top of page]

AR.HZ_PARTY_SITE_USES does not reference any database object

AR.HZ_PARTY_SITE_USES is referenced by following:

APPS: HZ_PARTY_SITE_USES