[Home] [Help] [Dependency Information]

VIEW: APPS.OTA_CUSTOMER_CONTACTS_V

Object Details

Object Name:	OTA_CUSTOMER_CONTACTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OTA.OTA_CUSTOMER_CONTACTS_V
Subobject Name:
Status:	VALID

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

Query Text

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

SELECT CUSTOMER_ID
,      CONTACT_ID
,      FIRST_NAME
,      LAST_NAME
,      TITLE
,      TITLE_MEANING
,      FULL_NAME
,      STATUS
,      ROLE
,      MAIL_STOP
,      ADDRESS_ID
,      ADDRESS
,      FIRST_NAME_ALT
,      LAST_NAME_ALT
FROM APPS.OTA_CUSTOMER_CONTACTS_V;

Dependencies

[top of page]

APPS

AR_LOOKUPS

FND_PROFILE - show dependent code

HZ_CUST_ACCOUNTS

HZ_CUST_ACCOUNT_ROLES

HZ_CUST_ACCT_SITES_ALL

HZ_LOCATIONS

HZ_ORG_CONTACTS

HZ_PARTIES

HZ_PARTY_SITES

HZ_RELATIONSHIPS

HZ_ROLE_RESPONSIBILITY

OTA_TDB_BUS - show dependent code

APPS

OTA_OM_UPD_API - show dependent code

OTA_TFH_API_BUSINESS_RULES - show dependent code

OTA_UTILITY - show dependent code

PUBLIC

OTA_CUSTOMER_CONTACTS_V