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

VIEW: APPS.AMS_PERSON_SITE_USES_V

Object Details
Object Name: AMS_PERSON_SITE_USES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMS.AMS_PERSON_SITE_USES_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
PARTY_SITE_USE_ID NUMBER (15) Yes Party site use identifier
PARTY_SITE_ID NUMBER (15) Yes Identifier for the party site. Foreign key to the HZ_PARTY_SITES table
SITE_USE_TYPE VARCHAR2 (30) Yes Site use type
BEGIN_DATE DATE

The planned or actual date when a party begins the use of a site
END_DATE DATE

The planned or actual date when the use of a site by a party will end
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.
REGION VARCHAR2 (30)
User-defined geographical region
MAILSTOP VARCHAR2 (60)
A user-defined code to indicate a mail drop point within their organization
LANGUAGE VARCHAR2 (4)
The primary language spoken and written of the party site.
Query Text

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


SELECT PARTY_SITE_USE_ID
,      PARTY_SITE_ID
,      SITE_USE_TYPE
,      BEGIN_DATE
,      END_DATE
,      PRIMARY_PER_TYPE
,      REGION
,      MAILSTOP
,      LANGUAGE
FROM APPS.AMS_PERSON_SITE_USES_V;

Dependencies

[top of page]

APPS.AMS_PERSON_SITE_USES_V references the following:

SchemaAPPS
SynonymHZ_LOCATIONS
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES
SynonymHZ_PARTY_SITE_USES

APPS.AMS_PERSON_SITE_USES_V is not referenced by any database object