[Home] [Help] [Dependency Information]
Object Name: | CSC_CUSTOMER_RESPONSE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CSC.CSC_CUSTOMER_RESPONSE_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
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.
Name | Datatype | Length | Mandatory | 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) |
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;
APPS.CSC_CUSTOMER_RESPONSE_V is not referenced by any database object
|
|
|