DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.CSC_SEARCH_DUMMY_V

Object Details
Object Name: CSC_SEARCH_DUMMY_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCSC.CSC_SEARCH_DUMMY_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

Internal

[View Source]

Columns
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
EMAIL 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)
Query Text

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;

Dependencies

[top of page]

APPS.CSC_SEARCH_DUMMY_V references the following:

SchemaPUBLIC
SynonymDUAL

APPS.CSC_SEARCH_DUMMY_V is not referenced by any database object