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]

VIEW: APPS.CSC_GS_CUSTOMERS_V

Object Details

Object Name:	CSC_GS_CUSTOMERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CSC.CSC_GS_CUSTOMERS_V
Subobject Name:
Status:	VALID

View Type

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

View used to perform search operation on customer information in the contact center form.
This view has all information about customers at all levels, ie. at Object, Subject and Party level.
Customer search metadata spreadtable defnitions are based on this view.

[View Source]

Columns

Name	Datatype	Length	Comments
PTY_PARTY_ID	NUMBER	(15)	References PARY_ID of HZ_PARTIES. Id of the party relationship.
PTY_PARTY_NAME	VARCHAR2	(360)	Party name of the Party relationship.
PTY_PARTY_NUMBER	VARCHAR2	(30)	Party Number of the party relationship.
PTY_PARTY_TYPE	VARCHAR2	(30)	Party Type of the party relationship.
PTY_CUST_ACCOUNT_ID	NUMBER	(15)	Account Id of the party relationship. References CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS.
PTY_ACCOUNT_NUMBER	VARCHAR2	(30)	Account Number of the party relationship.
PTY_ACCOUNT_NAME	VARCHAR2	(240)	Account Name of the party relationship.
PTY_CUST_ID_LAST_UPDATE_DATE	DATE		Last update date of the record in HZ_CUST_ACCOUNTS_ALL of the party relationship.
PTY_GROUP_TYPE	VARCHAR2	(30)	Group type of the party relationship.
PTY_TITLE	VARCHAR2	(30)	Refers to PERSON_PRE_NAME_ADJUNCT in HZ_PARTIES of the party relationship.
PTY_FIRST_NAME	VARCHAR2	(150)	Refers to PERSON_FIRST_NAME in HZ_PARTIES of the party relationship.
PTY_MIDDLE_NAME	VARCHAR2	(60)	Refers to PERSON_MIDDLE_NAME in HZ_PARTIES of the party relationship.
PTY_LAST_NAME	VARCHAR2	(150)	Refers to PERSON_LAST_NAME in HZ_PARTIES of the party relationship.
PTY_FULL_NAME	VARCHAR2	(301)	Concatenation of PTY_FIRST_NAME and PTY_LAST_NAME.
PTY_LAST_UPDATE_DATE	DATE		Last Update Date of the record in HZ_PARTIES of the party relationship.
PTY_CONTACT_POINT_ID	NUMBER	(15)	References CONTACT_POINT_ID of HZ_CONTACT_POINTS where CONTACT_TYPE is PHONE of the party relationship.
PTY_EMAIL_ID	NUMBER	(15)	References CONTACT_POINT_ID of HZ_CONTACT_POINTS where CONTACT_TYPE is EMAIL of the party relationship.
PTY_PHONE_COUNTRY_CODE	VARCHAR2	(10)	References COUNTRY_CODE of HZ_CONTACT_POINTS of the party relationship.
PTY_PHONE_AREA_CODE	VARCHAR2	(10)	References PHONE_AREA_CODE of HZ_CONTACT_POINTS of the party relationship.
PTY_PHONE_NUMBER	VARCHAR2	(40)	References PHONE_NUMBER of HZ_CONTACT_POINTS of the party relationship.
PTY_AREA_CODE_PHONE_NUMBER	VARCHAR2	(50)	Area Code and Phone number
PTY_PHONE_EXTENSION	VARCHAR2	(20)	References PHONE_EXTENSION of HZ_CONTACT_POINTS of the party relationship.
PTY_PHONE_TYPE	VARCHAR2	(30)	References TELEPHONE_TYPE of HZ_CONTACT_POINTS of the party relationship.
PTY_CONT_LAST_UPDATE_DATE	DATE		Last Update Date of the record in HZ_CONTACT_POINTS of the party relationship.
PTY_EMAIL_LAST_UPDATE_DATE	DATE		Standard Who column
PTY_PARTIAL_ADDRESS	VARCHAR2	(963)	Concatenation of ADDRESS1, ADDRESS2, ADDRESS3 and ADDRESS4 from HZ_LOCATIONS of the party relationship.
PTY_ADDRESS1	VARCHAR2	(240)	First line identifying address. (where
PTY_ADDRESS2	VARCHAR2	(240)	Second line identifying address. (where
PTY_ADDRESS3	VARCHAR2	(240)	Thrid line identifying address. (where
PTY_ADDRESS4	VARCHAR2	(240)	Fourth line identifying address. (where
PTY_CITY	VARCHAR2	(60)	References CITY of HZ_LOCATIONS of the party relationship.
PTY_STATE	VARCHAR2	(60)	References STATE of HZ_LOCATIONS of the party relationship.
PTY_POSTAL_CODE	VARCHAR2	(60)	References POSTAL_CODE of HZ_LOCATIONS of the party relationship.
PTY_PROVINCE	VARCHAR2	(60)	References PROVINCE of HZ_LOCATIONS of the party relationship.
PTY_COUNTRY	VARCHAR2	(60)	References COUNTRY of HZ_LOCATIONS of the party relationship.
PTY_FULL_ADDRESS	VARCHAR2	(1213)	Concatenation of ADDRESS1, 2, 3 , 4, CITY, STATE, POSTAL_CODE and COUNTRY of HZ_LOCATIONS of the part relationship.
PTY_EMAIL_ADDRESS	VARCHAR2	(2000)	References EMAIL-ADDRESS of HZ_CONTACT_POINTS of the party relationship.
SUB_PARTY_ID	NUMBER	(15)	References PARY_ID of HZ_PARTIES. Id of the subject.
SUB_PARTY_NAME	VARCHAR2	(360)	Party name of the subject.
SUB_PARTY_NUMBER	VARCHAR2	(30)	Party number of the subject.
SUB_PARTY_TYPE	VARCHAR2	(30)	Party type of the subject.
SUB_CUST_ACCOUNT_ID	NUMBER	(15)	Account Id of the subject. References CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS_ALL
SUB_ACCOUNT_NUMBER	VARCHAR2	(30)	Account number of the subject.
SUB_ACCOUNT_NAME	VARCHAR2	(240)	Account name of the subject.
SUB_CUST_ID_LAST_UPDATE_DATE	DATE		Last update date of the record in HZ_CUST_ACCOUNTS_ALL of the subject.
SUB_GROUP_TYPE	VARCHAR2	(30)	Group type of the subject.
SUB_TITLE	VARCHAR2	(30)	Refers to PERSON_PRE_NAME_ADJUNCT in HZ_PARTIES of the subject.
SUB_FIRST_NAME	VARCHAR2	(150)	Refers to PERSON_FIRST_NAME in HZ_PARTIES of the subject.
SUB_MIDDLE_NAME	VARCHAR2	(60)	Refers to PERSON_MIDDLE_NAME in HZ_PARTIES of the subject.
SUB_LAST_NAME	VARCHAR2	(150)	Refers to PERSON_LAST_NAME in HZ_PARTIES of the subject.
SUB_FULL_NAME	VARCHAR2	(301)	Concatenation of SUB_FIRST_NAME and SUB_LAST_NAME.
SUB_LAST_UPDATE_DATE	DATE		Last Update Date of the record in HZ_PARTIES of the subject.
SUB_CONTACT_POINT_ID	NUMBER	(15)	References CONTACT_POINT_ID of HZ_CONTACT_POINTS where CONTACT_TYPE is PHONE of the subject.
SUB_EMAIL_ID	NUMBER	(15)	References CONTACT_POINT_ID of HZ_CONTACT_POINTS where CONTACT_TYPE is EMAIL of the subject.
SUB_PHONE_COUNTRY_CODE	VARCHAR2	(10)	References COUNTRY_CODE of HZ_CONTACT_POINTS of the subject.
SUB_PHONE_AREA_CODE	VARCHAR2	(10)	eferences PHONE_AREA_CODE of HZ_CONTACT_POINTS of the subject.
SUB_PHONE_NUMBER	VARCHAR2	(51)	References PHONE_NUMBER of HZ_CONTACT_POINTS of the subject.
SUB_AREA_CODE_PHONE_NUMBER	VARCHAR2	(51)	Area Code and Phone number
SUB_PHONE_EXTENSION	VARCHAR2	(20)	References PHONE_EXTENSION of HZ_CONTACT_POINTS of the subject.
SUB_PHONE_TYPE	VARCHAR2	(30)	References TELEPHONE_TYPE of HZ_CONTACT_POINTS of the subject.
SUB_CONT_LAST_UPDATE_DATE	DATE		Last Update Date of the record in HZ_CONTACT_POINTS of the subject.
SUB_EMAIL_LAST_UPDATE_DATE	DATE		Standard Who column
SUB_PARTIAL_ADDRESS	VARCHAR2	(963)	Concatenation of ADDRESS1, ADDRESS2, ADDRESS3 and ADDRESS4 from HZ_LOCATIONS of the subject.
SUB_ADDRESS1	VARCHAR2	(240)	First line identifying address. (where
SUB_ADDRESS2	VARCHAR2	(240)	Second line identifying address. (where
SUB_ADDRESS3	VARCHAR2	(240)	Thrid line identifying address. (where
SUB_ADDRESS4	VARCHAR2	(240)	Fourth line identifying address. (where
SUB_CITY	VARCHAR2	(60)	References CITY of HZ_LOCATIONS of the subject.
SUB_STATE	VARCHAR2	(60)	References STATE of HZ_LOCATIONS of the subject..
SUB_POSTAL_CODE	VARCHAR2	(60)	References POSTAL_CODE of HZ_LOCATIONS of the subject.
SUB_PROVINCE	VARCHAR2	(60)	References PROVINCE of HZ_LOCATIONS of the subject.
SUB_COUNTRY	VARCHAR2	(60)	References COUNTRY of HZ_LOCATIONS of the subject.
SUB_FULL_ADDRESS	VARCHAR2	(1213)	Concatenation of ADDRESS1, 2, 3 , 4, CITY, STATE, POSTAL_CODE and COUNTRY of HZ_LOCATIONS of the subject.
SUB_EMAIL_ADDRESS	VARCHAR2	(2000)	References EMAIL-ADDRESS of HZ_CONTACT_POINTS of the subject.
OBJ_PARTY_ID	NUMBER	(15)	References PARY_ID of HZ_PARTIES. Id of the object.
OBJ_PARTY_NAME	VARCHAR2	(360)	Party name of the object.
OBJ_PARTY_NUMBER	VARCHAR2	(30)	Party number of the object.
OBJ_PARTY_TYPE	VARCHAR2	(30)	Party type of the object.
OBJ_CUST_ACCOUNT_ID	NUMBER	(15)	Account Id of the object. References CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS_ALL
OBJ_ACCOUNT_NUMBER	VARCHAR2	(30)	Account number of the object.
OBJ_ACCOUNT_NAME	VARCHAR2	(240)	Account name of the object.
OBJ_CUST_ID_LAST_UPDATE_DATE	DATE		Last update date of the record in HZ_CUST_ACCOUNTS_ALL of the object.
OBJ_GROUP_TYPE	VARCHAR2	(30)	Group type of the object.
OBJ_TITLE	VARCHAR2	(30)	Refers to PERSON_PRE_NAME_ADJUNCT in HZ_PARTIES of the object.
OBJ_FIRST_NAME	VARCHAR2	(150)	Refers to PERSON_FIRST_NAME in HZ_PARTIES of the object.
OBJ_MIDDLE_NAME	VARCHAR2	(60)	Refers to PERSON_MIDDLE_NAME in HZ_PARTIES of the object.
OBJ_LAST_NAME	VARCHAR2	(150)	Refers to PERSON_LAST_NAME in HZ_PARTIES of the object.
OBJ_FULL_NAME	VARCHAR2	(301)	Concatenation of OBJ_FIRST_NAME and OBJ_LAST_NAME.
OBJ_LAST_UPDATE_DATE	DATE		Last Update Date of the record in HZ_PARTIES of the object.
OBJ_CONTACT_POINT_ID	NUMBER	(15)	References CONTACT_POINT_ID of HZ_CONTACT_POINTS where CONTACT_TYPE is PHONE of the object.
OBJ_EMAIL_ID	NUMBER	(15)	References CONTACT_POINT_ID of HZ_CONTACT_POINTS where CONTACT_TYPE is EMAIL of the object.
OBJ_PHONE_COUNTRY_CODE	VARCHAR2	(10)	eferences COUNTRY_CODE of HZ_CONTACT_POINTS of the object.
OBJ_PHONE_AREA_CODE	VARCHAR2	(10)	References PHONE_AREA_CODE of HZ_CONTACT_POINTS of the object.
OBJ_PHONE_NUMBER	VARCHAR2	(40)	References PHONE_NUMBER of HZ_CONTACT_POINTS of the object.
OBJ_AREA_CODE_PHONE_NUMBER	VARCHAR2	(51)	Area Code and Phone number
OBJ_PHONE_EXTENSION	VARCHAR2	(20)	References PHONE_EXTENSION of HZ_CONTACT_POINTS of the object.
OBJ_PHONE_TYPE	VARCHAR2	(30)	References TELEPHONE_TYPE of HZ_CONTACT_POINTS of the object.
OBJ_CONT_LAST_UPDATE_DATE	DATE		Last Update Date of the record in HZ_CONTACT_POINTS of the object.
OBJ_EMAIL_LAST_UPDATE_DATE	DATE		Standard Who column
OBJ_PARTIAL_ADDRESS	VARCHAR2	(963)	Concatenation of ADDRESS1, ADDRESS2, ADDRESS3 and ADDRESS4 from HZ_LOCATIONS of the object.
OBJ_ADDRESS1	VARCHAR2	(240)	First line identifying address. (where
OBJ_ADDRESS2	VARCHAR2	(240)	Second line identifying address. (where
OBJ_ADDRESS3	VARCHAR2	(240)	Thrid line identifying address. (where HZ_PARTY_SITES.IDENTIFYING_ADDRESS_FLAG = Y)
OBJ_ADDRESS4	VARCHAR2	(240)	Fourth line identifying address. (where
OBJ_CITY	VARCHAR2	(60)	References CITY of HZ_LOCATIONS of the object.
OBJ_STATE	VARCHAR2	(60)	References STATE of HZ_LOCATIONS of the object.
OBJ_POSTAL_CODE	VARCHAR2	(60)	References POSTAL_CODE of HZ_LOCATIONS of the object.
OBJ_PROVINCE	VARCHAR2	(60)	References PROVINCE of HZ_LOCATIONS of the object.
OBJ_COUNTRY	VARCHAR2	(60)	References COUNTRY of HZ_LOCATIONS of the object.
OBJ_FULL_ADDRESS	VARCHAR2	(1213)	Concatenation of ADDRESS1, 2, 3 , 4, CITY, STATE, POSTAL_CODE and COUNTRY of HZ_LOCATIONS of the object.
OBJ_EMAIL_ADDRESS	VARCHAR2	(2000)	References EMAIL-ADDRESS of HZ_CONTACT_POINTS of the object.
RELATION	VARCHAR2	(30)	Defines the relationship between the object and the subject. eg. Mr. A is a CONTACT FOR company B.
RELATION_MEANING	VARCHAR2	(80)	Defines the meaning of relationship between the object and the subject.

Query Text

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


SELECT PTY_PARTY_ID
,      PTY_PARTY_NAME
,      PTY_PARTY_NUMBER
,      PTY_PARTY_TYPE
,      PTY_CUST_ACCOUNT_ID
,      PTY_ACCOUNT_NUMBER
,      PTY_ACCOUNT_NAME
,      PTY_CUST_ID_LAST_UPDATE_DATE
,      PTY_GROUP_TYPE
,      PTY_TITLE
,      PTY_FIRST_NAME
,      PTY_MIDDLE_NAME
,      PTY_LAST_NAME
,      PTY_FULL_NAME
,      PTY_LAST_UPDATE_DATE
,      PTY_CONTACT_POINT_ID
,      PTY_EMAIL_ID
,      PTY_PHONE_COUNTRY_CODE
,      PTY_PHONE_AREA_CODE
,      PTY_PHONE_NUMBER
,      PTY_AREA_CODE_PHONE_NUMBER
,      PTY_PHONE_EXTENSION
,      PTY_PHONE_TYPE
,      PTY_CONT_LAST_UPDATE_DATE
,      PTY_EMAIL_LAST_UPDATE_DATE
,      PTY_PARTIAL_ADDRESS
,      PTY_ADDRESS1
,      PTY_ADDRESS2
,      PTY_ADDRESS3
,      PTY_ADDRESS4
,      PTY_CITY
,      PTY_STATE
,      PTY_POSTAL_CODE
,      PTY_PROVINCE
,      PTY_COUNTRY
,      PTY_FULL_ADDRESS
,      PTY_EMAIL_ADDRESS
,      SUB_PARTY_ID
,      SUB_PARTY_NAME
,      SUB_PARTY_NUMBER
,      SUB_PARTY_TYPE
,      SUB_CUST_ACCOUNT_ID
,      SUB_ACCOUNT_NUMBER
,      SUB_ACCOUNT_NAME
,      SUB_CUST_ID_LAST_UPDATE_DATE
,      SUB_GROUP_TYPE
,      SUB_TITLE
,      SUB_FIRST_NAME
,      SUB_MIDDLE_NAME
,      SUB_LAST_NAME
,      SUB_FULL_NAME
,      SUB_LAST_UPDATE_DATE
,      SUB_CONTACT_POINT_ID
,      SUB_EMAIL_ID
,      SUB_PHONE_COUNTRY_CODE
,      SUB_PHONE_AREA_CODE
,      SUB_PHONE_NUMBER
,      SUB_AREA_CODE_PHONE_NUMBER
,      SUB_PHONE_EXTENSION
,      SUB_PHONE_TYPE
,      SUB_CONT_LAST_UPDATE_DATE
,      SUB_EMAIL_LAST_UPDATE_DATE
,      SUB_PARTIAL_ADDRESS
,      SUB_ADDRESS1
,      SUB_ADDRESS2
,      SUB_ADDRESS3
,      SUB_ADDRESS4
,      SUB_CITY
,      SUB_STATE
,      SUB_POSTAL_CODE
,      SUB_PROVINCE
,      SUB_COUNTRY
,      SUB_FULL_ADDRESS
,      SUB_EMAIL_ADDRESS
,      OBJ_PARTY_ID
,      OBJ_PARTY_NAME
,      OBJ_PARTY_NUMBER
,      OBJ_PARTY_TYPE
,      OBJ_CUST_ACCOUNT_ID
,      OBJ_ACCOUNT_NUMBER
,      OBJ_ACCOUNT_NAME
,      OBJ_CUST_ID_LAST_UPDATE_DATE
,      OBJ_GROUP_TYPE
,      OBJ_TITLE
,      OBJ_FIRST_NAME
,      OBJ_MIDDLE_NAME
,      OBJ_LAST_NAME
,      OBJ_FULL_NAME
,      OBJ_LAST_UPDATE_DATE
,      OBJ_CONTACT_POINT_ID
,      OBJ_EMAIL_ID
,      OBJ_PHONE_COUNTRY_CODE
,      OBJ_PHONE_AREA_CODE
,      OBJ_PHONE_NUMBER
,      OBJ_AREA_CODE_PHONE_NUMBER
,      OBJ_PHONE_EXTENSION
,      OBJ_PHONE_TYPE
,      OBJ_CONT_LAST_UPDATE_DATE
,      OBJ_EMAIL_LAST_UPDATE_DATE
,      OBJ_PARTIAL_ADDRESS
,      OBJ_ADDRESS1
,      OBJ_ADDRESS2
,      OBJ_ADDRESS3
,      OBJ_ADDRESS4
,      OBJ_CITY
,      OBJ_STATE
,      OBJ_POSTAL_CODE
,      OBJ_PROVINCE
,      OBJ_COUNTRY
,      OBJ_FULL_ADDRESS
,      OBJ_EMAIL_ADDRESS
,      RELATION
,      RELATION_MEANING
FROM APPS.CSC_GS_CUSTOMERS_V;

Dependencies

[top of page]

APPS.CSC_GS_CUSTOMERS_V references the following:

APPS: AR_LOOKUPS; CSC_GS_CONTACTS_V; HZ_CUST_ACCOUNTS; HZ_PARTIES; HZ_RELATIONSHIPS

APPS.CSC_GS_CUSTOMERS_V is not referenced by any database object