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

VIEW: APPS.CSI_CP_ADDRESSES_V

Object Details
Object Name: CSI_CP_ADDRESSES_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Backward Compatible View


[View Source]

Columns
Name Datatype Length Mandatory Comments
LOCATION NUMBER (15) Yes Location Name
DESCRIPTION VARCHAR2 (2000)
Location Description
PARTY_NAME VARCHAR2 (360) Yes Party name
PARTY_SITE_NAME VARCHAR2 (240)
Party site name
ADDRESS1 VARCHAR2 (240) Yes Party address
ADDRESS2 VARCHAR2 (240)
Party address
ADDRESS3 VARCHAR2 (240)
Party address
ADDRESS4 VARCHAR2 (240)
Party address
CITY VARCHAR2 (60)
Party address
STATE VARCHAR2 (60)
Party address
ZIP VARCHAR2 (60)
Party address
COUNTRY VARCHAR2 (60) Yes Party address
PARTY_ID NUMBER (15) Yes Party Identifier
CUST_ACCOUNT_ID NUMBER (15) Yes Customer Account Id
SITE_NUMBER VARCHAR2 (30) Yes Site Number
Query Text

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


SELECT LOCATION
,      DESCRIPTION
,      PARTY_NAME
,      PARTY_SITE_NAME
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      STATE
,      ZIP
,      COUNTRY
,      PARTY_ID
,      CUST_ACCOUNT_ID
,      SITE_NUMBER
FROM APPS.CSI_CP_ADDRESSES_V;

Dependencies

[top of page]

APPS.CSI_CP_ADDRESSES_V references the following:

SchemaAPPS
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_LOCATIONS
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES

APPS.CSI_CP_ADDRESSES_V is not referenced by any database object