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_ORG_ADV_V

Object Details

Object Name:	CSC_GS_CUSTOMERS_ORG_ADV_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CSC.CSC_GS_CUSTOMERS_ORG_ADV_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)	Relatonship's Party Id
PTY_PARTY_NAME	VARCHAR2	(360)	Relatonship's Party Name
PTY_PARTY_NUMBER	VARCHAR2	(30)	Relatonship's Party number
PTY_PARTY_TYPE	VARCHAR2	(30)	Relatonship's Party type.
PTY_CUST_ACCOUNT_ID	NUMBER	(15)	Account Id of the Relatonship
PTY_ACCOUNT_NUMBER	VARCHAR2	(30)	Account number of the Relationship
PTY_ACCOUNT_NAME	VARCHAR2	(240)	Account name of the Relatonship
PTY_CUST_ID_LAST_UPDATE_DATE	DATE		Last update date of the record in HZ_CUST_ACCOUNTS_ALL of the relationship.
PTY_GROUP_TYPE	VARCHAR2	(30)	Group type of the relationship
PTY_TITLE	VARCHAR2	(30)	Refers to PERSON_PRE_NAME_ADJUNCT in HZ_PARTIES of the relationship
PTY_FIRST_NAME	VARCHAR2	(150)	Refers to PERSON_FIRST_NAME in HZ_PARTIES of the relationship
PTY_MIDDLE_NAME	VARCHAR2	(60)	Refers to PERSON_MIDDLE_NAME in HZ_PARTIES of the relationship
PTY_LAST_NAME	VARCHAR2	(150)	Refers to PERSON_LAST_NAME in HZ_PARTIES of the 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 relationship
PTY_CONTACT_POINT_ID	NUMBER	(15)	References CONTACT_POINT_ID of HZ_CONTACT_POINTS where CONTACT_TYPE is PHONE of the relationship
PTY_EMAIL_ID	NUMBER	(15)	References CONTACT_POINT_ID of HZ_CONTACT_POINTS where CONTACT_TYPE is EMAIL of the relationship
PTY_PHONE_COUNTRY_CODE	VARCHAR2	(10)	eferences COUNTRY_CODE of HZ_CONTACT_POINTS of the relationship
PTY_PHONE_AREA_CODE	VARCHAR2	(10)	References PHONE_AREA_CODE of HZ_CONTACT_POINTS of the relationship
PTY_PHONE_NUMBER	VARCHAR2	(40)	References PHONE_NUMBER of HZ_CONTACT_POINTS of the relationship
PTY_AREA_CODE_PHONE_NUMBER	VARCHAR2	(50)	Relationship Area Code and Phone number
PTY_PHONE_EXTENSION	VARCHAR2	(20)	References PHONE_EXTENSION of HZ_CONTACT_POINTS of the relationship
PTY_PHONE_TYPE	VARCHAR2	(30)	References TELEPHONE_TYPE of HZ_CONTACT_POINTS of the relationship
PTY_CONT_LAST_UPDATE_DATE	DATE		Last Update Date of the record in HZ_CONTACT_POINTS of the relationship
PTY_EMAIL_LAST_UPDATE_DATE	DATE		Relationship's EMAIL_LAST_UPDATE_DATE
PTY_PARTIAL_ADDRESS	VARCHAR2	(964)	Concatenation of ADDRESS1, ADDRESS2, ADDRESS3 and ADDRESS4 from HZ_LOCATIONS of the relationship
PTY_ADDRESS1	VARCHAR2	(240)	First line identifying address of relationship
PTY_ADDRESS2	VARCHAR2	(240)	Second line for identifying address of relationship
PTY_ADDRESS3	VARCHAR2	(240)	Third line for identifying address of relationship
PTY_ADDRESS4	VARCHAR2	(240)	Fourth line for identifying address of relationship
PTY_CITY	VARCHAR2	(60)	References CITY of HZ_LOCATIONS of the relationship
PTY_STATE	VARCHAR2	(60)	References STATE of HZ_LOCATIONS of the relationship
PTY_POSTAL_CODE	VARCHAR2	(60)	References POSTAL_CODE of HZ_LOCATIONS of the relationship
PTY_PROVINCE	VARCHAR2	(60)	References PROVINCE of HZ_LOCATIONS of the relationship
PTY_COUNTRY	VARCHAR2	(60)	References COUNTRY of HZ_LOCATIONS of the relationship
PTY_FULL_ADDRESS	VARCHAR2	(1213)	Concatenation of ADDRESS1, 2, 3 , 4, CITY, STATE, POSTAL_CODE and COUNTRY of HZ_LOCATIONS of the relationship
PTY_EMAIL_ADDRESS	VARCHAR2	(2000)	References EMAIL-ADDRESS of HZ_CONTACT_POINTS of the relationship
SUB_PARTY_ID	NUMBER	(15)	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)	eferences COUNTRY_CODE of HZ_CONTACT_POINTS of the subject
SUB_PHONE_AREA_CODE	VARCHAR2	(10)	References 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)	Subject's 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		Subject's EMAIL_LAST_UPDATE_DATE
SUB_PARTIAL_ADDRESS	VARCHAR2	(964)	Concatenation of ADDRESS1, ADDRESS2, ADDRESS3 and ADDRESS4 from HZ_LOCATIONS of the subject
SUB_ADDRESS1	VARCHAR2	(240)	First line identifying address of subject
SUB_ADDRESS2	VARCHAR2	(240)	Second line for identifying address of subject
SUB_ADDRESS3	VARCHAR2	(240)	Third line for identifying address of subject
SUB_ADDRESS4	VARCHAR2	(240)	Fourth line for identifying address of subject
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
SUB_STATUS	VARCHAR2	(1)	Status 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		Object's EMAIL_LAST_UPDATE_DATE
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 of object
OBJ_ADDRESS2	VARCHAR2	(240)	Second line for identifying address of object
OBJ_ADDRESS3	VARCHAR2	(240)	Third line for identifying address of object
OBJ_ADDRESS4	VARCHAR2	(240)	Fourth line for identifying address of object
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 relationship between the object and the subject. eg. Mr. A is a CONTACT FOR company B.
OBJ_STATUS	VARCHAR2	(1)	Object status flag.
OBJ_ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Descriptive Flexfield Structure Defining column
OBJ_ATTRIBUTE1	VARCHAR2	(150)	Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE2	VARCHAR2	(150)	Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE3	VARCHAR2	(150)	Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE4	VARCHAR2	(150)	Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE5	VARCHAR2	(150)	Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE6	VARCHAR2	(150)	Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE7	VARCHAR2	(150)	Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE8	VARCHAR2	(150)	Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE9	VARCHAR2	(150)	Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE10	VARCHAR2	(150)	Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE11	VARCHAR2	(150)	Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE12	VARCHAR2	(150)	Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE13	VARCHAR2	(150)	Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE14	VARCHAR2	(150)	Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE15	VARCHAR2	(150)	Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE16	VARCHAR2	(150)	Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE17	VARCHAR2	(150)	Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE18	VARCHAR2	(150)	Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE19	VARCHAR2	(150)	Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE20	VARCHAR2	(150)	Descriptive Flexfield Segment Column

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
,      SUB_STATUS
,      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
,      OBJ_STATUS
,      OBJ_ATTRIBUTE_CATEGORY
,      OBJ_ATTRIBUTE1
,      OBJ_ATTRIBUTE2
,      OBJ_ATTRIBUTE3
,      OBJ_ATTRIBUTE4
,      OBJ_ATTRIBUTE5
,      OBJ_ATTRIBUTE6
,      OBJ_ATTRIBUTE7
,      OBJ_ATTRIBUTE8
,      OBJ_ATTRIBUTE9
,      OBJ_ATTRIBUTE10
,      OBJ_ATTRIBUTE11
,      OBJ_ATTRIBUTE12
,      OBJ_ATTRIBUTE13
,      OBJ_ATTRIBUTE14
,      OBJ_ATTRIBUTE15
,      OBJ_ATTRIBUTE16
,      OBJ_ATTRIBUTE17
,      OBJ_ATTRIBUTE18
,      OBJ_ATTRIBUTE19
,      OBJ_ATTRIBUTE20
FROM APPS.CSC_GS_CUSTOMERS_ORG_ADV_V;

Dependencies

[top of page]

APPS.CSC_GS_CUSTOMERS_ORG_ADV_V references the following:

APPS: AR_LOOKUPS; CSC_GS_CONTACTS_V; HZ_CUST_ACCOUNTS; HZ_PARTIES; HZ_RELATIONSHIPS

APPS.CSC_GS_CUSTOMERS_ORG_ADV_V is not referenced by any database object