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_SEARCH_DUMMY_V

Object Details

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

PUBLIC: DUAL

APPS.CSC_SEARCH_DUMMY_V is not referenced by any database object