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

VIEW: APPS.CS_SR_PARTY_ADDRESS_V

Object Details
Object Name: CS_SR_PARTY_ADDRESS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCS.CS_SR_PARTY_ADDRESS_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
ADDRESS VARCHAR2 (963)
Concatenated address of the party.
CITY VARCHAR2 (60)
City of the party.
STATE VARCHAR2 (60)
State of the party.
PROVINCE VARCHAR2 (60)
Province of the party.
COUNTY VARCHAR2 (60)
POSTAL_CODE VARCHAR2 (60)
Postal code of the party.
PARTY_ID NUMBER (15) Yes The party identifier.
PARTY_TYPE VARCHAR2 (30) Yes The type of the party.
STATUS VARCHAR2 (1) Yes Status of the party.
PARTY_NAME VARCHAR2 (360) Yes The party name.
PARTY_NUMBER VARCHAR2 (30) Yes The party number.
EMAIL_ADDRESS VARCHAR2 (2000)
The email address of the party.
PERSON_LAST_NAME VARCHAR2 (150)
The last name of the party of type PERSON.
PERSON_FIRST_NAME VARCHAR2 (150)
The first name of the party of type PERSON.
PERSON_PRE_NAME_ADJUNCT VARCHAR2 (30)
The pre name adjunct of the party of type PERSON.
COUNTRY VARCHAR2 (60)
Country of the party.
KNOWN_AS VARCHAR2 (240)
Party known as
Query Text

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


SELECT ADDRESS
,      CITY
,      STATE
,      PROVINCE
,      COUNTY
,      POSTAL_CODE
,      PARTY_ID
,      PARTY_TYPE
,      STATUS
,      PARTY_NAME
,      PARTY_NUMBER
,      EMAIL_ADDRESS
,      PERSON_LAST_NAME
,      PERSON_FIRST_NAME
,      PERSON_PRE_NAME_ADJUNCT
,      COUNTRY
,      KNOWN_AS
FROM APPS.CS_SR_PARTY_ADDRESS_V;

Dependencies

[top of page]

APPS.CS_SR_PARTY_ADDRESS_V references the following:

SchemaAPPS
SynonymHZ_PARTIES

APPS.CS_SR_PARTY_ADDRESS_V is not referenced by any database object