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

VIEW: APPS.JTF_RS_PARTIES_VL

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

View Type

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


The details of parties that can be imported as resource or are already present as resource


[View Source]

Columns
Name Datatype Length Mandatory Comments
PARTY_ID NUMBER (15) Yes Unique Identifier for the party
PARTY_NUMBER VARCHAR2 (30) Yes Party Number
PARTY_NAME VARCHAR2 (360) Yes Party name
PARTY_TYPE VARCHAR2 (30) Yes Type of party. This is limited to person, organization or group
EMAIL VARCHAR2 (2000)
Party Email
PHONE VARCHAR2 (50)
Phone number
PHONE_EXTENSION VARCHAR2 (20)
Extension if any for the phone number
PHONE_COUNTRY_CODE VARCHAR2 (10)
Country code for the phone
ORG_ID NUMBER

Organization identifier
ORG_NAME VARCHAR2 (0)
Organization name (null in this case)
Query Text

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


SELECT PARTY_ID
,      PARTY_NUMBER
,      PARTY_NAME
,      PARTY_TYPE
,      EMAIL
,      PHONE
,      PHONE_EXTENSION
,      PHONE_COUNTRY_CODE
,      ORG_ID
,      ORG_NAME
FROM APPS.JTF_RS_PARTIES_VL;

Dependencies

[top of page]

APPS.JTF_RS_PARTIES_VL references the following:

SchemaAPPS
SynonymHZ_CONTACT_POINTS
SynonymHZ_PARTIES

APPS.JTF_RS_PARTIES_VL is not referenced by any database object