[Home] [Help]
[Dependency Information]
Object Name: | CSC_SEARCH_DUMMY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PER_TITLE | VARCHAR2 | (0) | Contact's Title | |
PER_FULL_NAME | VARCHAR2 | (0) | Contact 'sFull Name | |
PER_FIRST_NAME | VARCHAR2 | (0) | Contact's First Name | |
PER_LAST_NAME | VARCHAR2 | (0) | Contact's Last Name | |
PER_FIRST_NAME_PHONETIC | VARCHAR2 | (0) | Phonetic first name of a contact | |
PER_LAST_NAME_PHONETIC | VARCHAR2 | (0) | Phonetic last name of a contact | |
PER_PARTY_ID | NUMBER | Identification of a contact | ||
PER_OBJ_VER_NUMBER | NUMBER | Object Version Number of a contact | ||
CONT_PARTY_NUMBER | VARCHAR2 | (0) | Number of a contact | |
CONT_PARTY_ID | NUMBER | Identification of a contact | ||
CONT_OBJ_VER_NUMBER | NUMBER | Object Version Number of a contact | ||
RELATION_MEANING | VARCHAR2 | (0) | Meaning of a relationship | |
RELATION_CODE | VARCHAR2 | (0) | Code of a relationship | |
RELATIONSHIP_ID | NUMBER | Identification of a relationship | ||
RELATION_OBJ_VER_NUMBER | NUMBER | Object Version Number of a relationship | ||
CUST_PARTY_NAME | VARCHAR2 | (0) | Name of a customer | |
CUST_FIRST_NAME | VARCHAR2 | (0) | First Name of a customer | |
CUST_LAST_NAME | VARCHAR2 | (0) | Last Name of a customer | |
CUST_FIRST_NAME_PHONETIC | VARCHAR2 | (0) | Phonetic first name of a customer | |
CUST_LAST_NAME_PHONETIC | VARCHAR2 | (0) | Phonetic Last name of a customer | |
CUST_PARTY_TYPE | VARCHAR2 | (0) | Type of a customer | |
CUST_PARTY_NUMBER | VARCHAR2 | (0) | Number of a customer | |
CUST_PARTY_ID | NUMBER | Identification of a customer | ||
CUST_OBJ_VER_NUMBER | NUMBER | Object Version Number of a customer | ||
ACCOUNT_NUMBER | VARCHAR2 | (0) | Account Number of a customer | |
ACCOUNT_NAME | VARCHAR2 | (0) | Account Name of a Customer | |
CUST_ACCOUNT_ID | NUMBER | Account Id of a customer | ||
ACCT_OBJ_VER_NUMBER | NUMBER | Object Version Number of an account of a customer | ||
PHONE_COUNTRY_CODE | VARCHAR2 | (0) | Country code for the phone of a customer | |
PHONE_AREA_CODE | VARCHAR2 | (0) | Area code for the phone of a customer | |
PHONE_NUMBER | VARCHAR2 | (0) | Phone number for a customer | |
PHONE_LINE_TYPE | VARCHAR2 | (0) | Phone line type of a customer | |
PHONE_ID | NUMBER | Identification of a phone of a customer | ||
PHONE_OBJ_VER_NUMBER | NUMBER | Object Version Number of phone of a customer | ||
VARCHAR2 | (0) | Email of a customer | ||
EMAIL_ID | NUMBER | Identification of Email of a customer | ||
EMAIL_OBJ_VER_NUMBER | NUMBER | Object Version Number of email of a customer | ||
URL | VARCHAR2 | (0) | URL of a customer | |
URL_ID | NUMBER | Identification of URL of a customer | ||
URL_OBJ_VER_NUMBER | NUMBER | Object Version Number of URL of a customer | ||
SITE_NAME | VARCHAR2 | (0) | Site Name of a customer | |
SITE_ID | NUMBER | Identification of site of a customer | ||
SITE_OBJ_VER_NUMBER | NUMBER | Object Version Number of site of a customer | ||
ADDRESS | VARCHAR2 | (0) | Address of a customer | |
ADDRESS1 | VARCHAR2 | (0) | Address of a customer | |
ADDRESS2 | VARCHAR2 | (0) | Address of a customer | |
ADDRESS3 | VARCHAR2 | (0) | Address of a customer | |
ADDRESS4 | VARCHAR2 | (0) | Address of a customer | |
CITY | VARCHAR2 | (0) | City of a customer | |
STATE | VARCHAR2 | (0) | State of a customer | |
POSTAL_CODE | VARCHAR2 | (0) | Postal code of a customer | |
PROVINCE | VARCHAR2 | (0) | Province of a customer | |
COUNTY | VARCHAR2 | (0) | County of a customer | |
COUNTRY | VARCHAR2 | (0) | Country of a customer | |
LOCATION_ID | NUMBER | Identification of lication of a customer | ||
LOC_OBJ_VER_NUMBER | NUMBER | Object Version Number of location of a customer | ||
SITE_PHONE_COUNTRY_CODE | VARCHAR2 | (0) | ||
SITE_PHONE_AREA_CODE | VARCHAR2 | (0) | ||
SITE_PHONE | VARCHAR2 | (0) | ||
SITE_PHONE_LINE_TYPE | VARCHAR2 | (0) | ||
SITE_PHONE_ID | NUMBER | |||
SITE_PHONE_OBJ_VER_NUMBER | NUMBER | |||
SITE_NUMBER | VARCHAR2 | (0) | ||
ADDRESSEE | VARCHAR2 | (0) | ||
PER_MIDDLE_NAME | VARCHAR2 | (0) |
Cut, paste (and edit) the following text to query this object:
SELECT PER_TITLE
, PER_FULL_NAME
, PER_FIRST_NAME
, PER_LAST_NAME
, PER_FIRST_NAME_PHONETIC
, PER_LAST_NAME_PHONETIC
, PER_PARTY_ID
, PER_OBJ_VER_NUMBER
, CONT_PARTY_NUMBER
, CONT_PARTY_ID
, CONT_OBJ_VER_NUMBER
, RELATION_MEANING
, RELATION_CODE
, RELATIONSHIP_ID
, RELATION_OBJ_VER_NUMBER
, CUST_PARTY_NAME
, CUST_FIRST_NAME
, CUST_LAST_NAME
, CUST_FIRST_NAME_PHONETIC
, CUST_LAST_NAME_PHONETIC
, CUST_PARTY_TYPE
, CUST_PARTY_NUMBER
, CUST_PARTY_ID
, CUST_OBJ_VER_NUMBER
, ACCOUNT_NUMBER
, ACCOUNT_NAME
, CUST_ACCOUNT_ID
, ACCT_OBJ_VER_NUMBER
, PHONE_COUNTRY_CODE
, PHONE_AREA_CODE
, PHONE_NUMBER
, PHONE_LINE_TYPE
, PHONE_ID
, PHONE_OBJ_VER_NUMBER
, EMAIL
, EMAIL_ID
, EMAIL_OBJ_VER_NUMBER
, URL
, URL_ID
, URL_OBJ_VER_NUMBER
, SITE_NAME
, SITE_ID
, SITE_OBJ_VER_NUMBER
, ADDRESS
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, CITY
, STATE
, POSTAL_CODE
, PROVINCE
, COUNTY
, COUNTRY
, LOCATION_ID
, LOC_OBJ_VER_NUMBER
, SITE_PHONE_COUNTRY_CODE
, SITE_PHONE_AREA_CODE
, SITE_PHONE
, SITE_PHONE_LINE_TYPE
, SITE_PHONE_ID
, SITE_PHONE_OBJ_VER_NUMBER
, SITE_NUMBER
, ADDRESSEE
, PER_MIDDLE_NAME
FROM APPS.CSC_SEARCH_DUMMY_V;
APPS.CSC_SEARCH_DUMMY_V is not referenced by any database object
|
|
|