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_PER_V

Object Details

Object Name:	CSC_GS_CUSTOMERS_PER_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CSC.CSC_GS_CUSTOMERS_PER_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	Mandatory	Comments
OBJ_PARTY_ID	NUMBER	(15)	Yes	References PARY_ID of HZ_PARTIES. Id of the object.
OBJ_PARTY_NAME	VARCHAR2	(360)	Yes	Party name of the object.
OBJ_PARTY_NUMBER	VARCHAR2	(30)	Yes	Party number of the object.
OBJ_PARTY_TYPE	VARCHAR2	(30)	Yes	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		Yes	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	(50)		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 for identifying address. (where
OBJ_ADDRESS3	VARCHAR2	(240)		Second line for identifying address. (where
OBJ_ADDRESS4	VARCHAR2	(240)		Fourth line for 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	CHAR	(4)		Defines the relationship between the object and the subject. eg. Mr. A is a CONTACT FOR company B.
OBJ_STATUS	VARCHAR2	(1)	Yes	Party 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 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
,      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_PER_V;

Dependencies

[top of page]

APPS.CSC_GS_CUSTOMERS_PER_V references the following:

APPS: HZ_CONTACT_POINTS; HZ_CUST_ACCOUNTS; HZ_PARTIES

APPS.CSC_GS_CUSTOMERS_PER_V is not referenced by any database object