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

VIEW: APPS.HZ_DQM_ORG_CONTACT_INFO_V

Object Details
Object Name: HZ_DQM_ORG_CONTACT_INFO_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.HZ_DQM_ORG_CONTACT_INFO_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
Name Datatype Length Mandatory Comments
DQORG_CONTACT_ID NUMBER (15) Yes
DQTITLE VARCHAR2 (30)
DQJOB_TITLE VARCHAR2 (100)
DQPTY_ID NUMBER (15) Yes
DQPARTY_ID NUMBER (15) Yes
DQTITLE_NAME VARCHAR2 (360) Yes
DQROLE_TYPE VARCHAR2 (30)
DQCONTACT_POINT_PURPOSE VARCHAR2 (30)
DQMEANING VARCHAR2 (80)
DQCONTACT_POINT_TYPE VARCHAR2 (30)
DQSTATUS VARCHAR2 (30)
DQSTATUSM VARCHAR2 (4000)
DQPRIMARY_FLAG VARCHAR2 (1)
DQPRIMARY_BY_PURPOSE VARCHAR2 (30)
DQCONTACT_POINT_ID NUMBER (15)
DQCONTACT_INFO VARCHAR2 (2000)
Query Text

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


SELECT DQORG_CONTACT_ID
,      DQTITLE
,      DQJOB_TITLE
,      DQPTY_ID
,      DQPARTY_ID
,      DQTITLE_NAME
,      DQROLE_TYPE
,      DQCONTACT_POINT_PURPOSE
,      DQMEANING
,      DQCONTACT_POINT_TYPE
,      DQSTATUS
,      DQSTATUSM
,      DQPRIMARY_FLAG
,      DQPRIMARY_BY_PURPOSE
,      DQCONTACT_POINT_ID
,      DQCONTACT_INFO
FROM APPS.HZ_DQM_ORG_CONTACT_INFO_V;

Dependencies

[top of page]

APPS.HZ_DQM_ORG_CONTACT_INFO_V references the following:

SchemaAPPS
PL/SQL PackageARPT_SQL_FUNC_UTIL - show dependent code
ViewAR_LOOKUPS
SynonymHZ_CONTACT_POINTS
SynonymHZ_CUST_ACCOUNT_ROLES
SynonymHZ_ORG_CONTACTS
SynonymHZ_PARTIES
SynonymHZ_RELATIONSHIPS

APPS.HZ_DQM_ORG_CONTACT_INFO_V is not referenced by any database object