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

VIEW: APPS.JTF_RS_PARTY_CONTACTS_VL

Object Details
Object Name: JTF_RS_PARTY_CONTACTS_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJTF.JTF_RS_PARTY_CONTACTS_VL
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


The list of party contacts


[View Source]

Columns
Name Datatype Length Mandatory Comments
PARTY_ID NUMBER (15)
Party Identifier
PARTY_SITE_ID NUMBER (15)
Partt Address id
CONTACT_ID NUMBER (15)
Contact Id
CONTACT_NUMBER VARCHAR2 (30)
Contact Number
CONTACT_NAME VARCHAR2 (360)
Contact Name
PRIMARY_FLAG VARCHAR2 (1)
Primary Contact Flag ( value = 'Y" for primary contacts)
Query Text

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


SELECT PARTY_ID
,      PARTY_SITE_ID
,      CONTACT_ID
,      CONTACT_NUMBER
,      CONTACT_NAME
,      PRIMARY_FLAG
FROM APPS.JTF_RS_PARTY_CONTACTS_VL;

Dependencies

[top of page]

APPS.JTF_RS_PARTY_CONTACTS_VL references the following:

SchemaAPPS
SynonymHZ_ORG_CONTACTS
SynonymHZ_ORG_CONTACT_ROLES
SynonymHZ_PARTIES
SynonymHZ_RELATIONSHIPS
APPS.JTF_RS_PARTY_CONTACTS_VL is referenced by following:

SchemaAPPS
Package BodyJTF_RS_PARTY_MERGE_PUB - show dependent code
Package BodyJTF_RS_RESOURCE_PUB - show dependent code
ViewJTF_TERR_QLFY_RSC_V