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_CUSTOMER_RESPONSE_V

Object Details

Object Name:	CSC_CUSTOMER_RESPONSE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CSC.CSC_CUSTOMER_RESPONSE_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

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Comments
ROW_ID	ROWID	(10)
PARTY_ID	NUMBER	(15)	Party Id of the Relationship
PARTY_NUMBER	VARCHAR2	(30)	Party Number of the Relationship
PARTY_TYPE	VARCHAR2	(30)	Party Type of the Relationship
PARTY_NAME	VARCHAR2	(360)	Name of the Party Relationship
SUBJECT_ID	NUMBER	(15)	Caller's Party Id
OBJECT_ID	NUMBER	(15)	(Person/Organization/Group)'s Party Id
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_LOGIN	NUMBER	(15)
CREATION_DATE	DATE
CREATED_BY	NUMBER	(15)
OBJ_PARTY_TYPE	VARCHAR2	(30)	Object's (Person/Organization/Group) Party Type
OBJ_COMPANY_NAME	VARCHAR2	(360)
OBJ_GROUP_NAME	VARCHAR2	(360)
OBJ_GROUP_TYPE	VARCHAR2	(30)
OBJ_FIRST_NAME	VARCHAR2	(150)
OBJ_MIDDLE_NAME	VARCHAR2	(60)
OBJ_LAST_NAME	VARCHAR2	(150)
OBJ_NAME_SUFFIX	VARCHAR2	(30)
OBJ_TITLE	VARCHAR2	(60)
OBJ_ALIAS	VARCHAR2	(240)	Nickname or Known as
OBJ_SIC_CODE	VARCHAR2	(30)
OBJ_ANALYSIS_FY	VARCHAR2	(5)
OBJ_FISCAL_YEAREND_MONTH	VARCHAR2	(30)
OBJ_NUM_OF_EMPLOYEES	NUMBER
OBJ_POT_REVENUE_CURR_FY	NUMBER		Revenue for the Current Year
OBJ_POT_REVENUE_NEXT_FY	NUMBER		Projected Revenue for the next year
OBJ_TAX_REFERENCE	VARCHAR2	(50)
OBJ_YEAR_ESTABLISHED	NUMBER
OBJ_INTERNAL_FLAG	VARCHAR2	(1)	Y for Internal Organization, N otherwise
OBJ_PUB_PRIVATE_OWNER_FLAG	VARCHAR2	(1)	Public or Private Organization
OBJ_DUNS_NUMBER	NUMBER
OBJ_JGZZ_FISCAL_CODE	VARCHAR2	(20)
SUB_PARTY_TYPE	VARCHAR2	(30)	Subject's (Caller) Party Type
SUB_FIRST_NAME	VARCHAR2	(150)
SUB_MIDDLE_NAME	VARCHAR2	(60)
SUB_LAST_NAME	VARCHAR2	(150)
SUB_NAME_SUFFIX	VARCHAR2	(30)
SUB_TITLE	VARCHAR2	(60)
SUB_NICKNAME	VARCHAR2	(240)
SUB_PERSON_NAME_PHONETIC	VARCHAR2	(320)	Pronunciation
SUB_JOB_TITLE	VARCHAR2	(100)
SUB_DECISION_MAKER_FLAG	VARCHAR2	(1)	Whether or not the caller has the decision making authority
SUB_JOB_TITLE_CODE	VARCHAR2	(30)
SUB_MANAGED_BY	NUMBER		Manager's Employee number
SUB_NATIVE_LANGUAGE	VARCHAR2	(30)
SUB_REFERENCE_USE_FLAG	VARCHAR2	(1)	Whether or not the caller is referencible
SUB_OTHER_LANGUAGE_1	VARCHAR2	(30)	Second language
SUB_OTHER_LANGUAGE_2	VARCHAR2	(30)
SUB_RANK	VARCHAR2	(30)
SUB_SALUTATION	VARCHAR2	(30)
SUB_DEPARTMENT_CODE	VARCHAR2	(30)
SUB_DEPARTMENT	VARCHAR2	(60)
RELATION	VARCHAR2	(30)
ADDRESS	VARCHAR2	(962)	Address of the relationship
CITY	VARCHAR2	(60)
STATE	VARCHAR2	(60)
PROVINCE	VARCHAR2	(60)
POSTAL_CODE	VARCHAR2	(60)
COUNTRY	VARCHAR2	(60)
ATTRIBUTE_CATEGORY	VARCHAR2	(30)
ATTRIBUTE1	VARCHAR2	(150)
ATTRIBUTE2	VARCHAR2	(150)
ATTRIBUTE3	VARCHAR2	(150)
ATTRIBUTE4	VARCHAR2	(150)
ATTRIBUTE5	VARCHAR2	(150)
ATTRIBUTE6	VARCHAR2	(150)
ATTRIBUTE7	VARCHAR2	(150)
ATTRIBUTE8	VARCHAR2	(150)
ATTRIBUTE9	VARCHAR2	(150)
ATTRIBUTE10	VARCHAR2	(150)
ATTRIBUTE11	VARCHAR2	(150)
ATTRIBUTE12	VARCHAR2	(150)
ATTRIBUTE13	VARCHAR2	(150)
ATTRIBUTE14	VARCHAR2	(150)
ATTRIBUTE15	VARCHAR2	(150)
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)

Query Text

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


SELECT ROW_ID
,      PARTY_ID
,      PARTY_NUMBER
,      PARTY_TYPE
,      PARTY_NAME
,      SUBJECT_ID
,      OBJECT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      OBJ_PARTY_TYPE
,      OBJ_COMPANY_NAME
,      OBJ_GROUP_NAME
,      OBJ_GROUP_TYPE
,      OBJ_FIRST_NAME
,      OBJ_MIDDLE_NAME
,      OBJ_LAST_NAME
,      OBJ_NAME_SUFFIX
,      OBJ_TITLE
,      OBJ_ALIAS
,      OBJ_SIC_CODE
,      OBJ_ANALYSIS_FY
,      OBJ_FISCAL_YEAREND_MONTH
,      OBJ_NUM_OF_EMPLOYEES
,      OBJ_POT_REVENUE_CURR_FY
,      OBJ_POT_REVENUE_NEXT_FY
,      OBJ_TAX_REFERENCE
,      OBJ_YEAR_ESTABLISHED
,      OBJ_INTERNAL_FLAG
,      OBJ_PUB_PRIVATE_OWNER_FLAG
,      OBJ_DUNS_NUMBER
,      OBJ_JGZZ_FISCAL_CODE
,      SUB_PARTY_TYPE
,      SUB_FIRST_NAME
,      SUB_MIDDLE_NAME
,      SUB_LAST_NAME
,      SUB_NAME_SUFFIX
,      SUB_TITLE
,      SUB_NICKNAME
,      SUB_PERSON_NAME_PHONETIC
,      SUB_JOB_TITLE
,      SUB_DECISION_MAKER_FLAG
,      SUB_JOB_TITLE_CODE
,      SUB_MANAGED_BY
,      SUB_NATIVE_LANGUAGE
,      SUB_REFERENCE_USE_FLAG
,      SUB_OTHER_LANGUAGE_1
,      SUB_OTHER_LANGUAGE_2
,      SUB_RANK
,      SUB_SALUTATION
,      SUB_DEPARTMENT_CODE
,      SUB_DEPARTMENT
,      RELATION
,      ADDRESS
,      CITY
,      STATE
,      PROVINCE
,      POSTAL_CODE
,      COUNTRY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
FROM APPS.CSC_CUSTOMER_RESPONSE_V;

Dependencies

[top of page]

APPS.CSC_CUSTOMER_RESPONSE_V references the following:

APPS: HZ_ORGANIZATION_PROFILES; HZ_ORG_CONTACTS; HZ_PARTIES; HZ_PERSON_PROFILES; HZ_RELATIONSHIPS

APPS.CSC_CUSTOMER_RESPONSE_V is not referenced by any database object