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

VIEW: APPS.JTF_RS_PARTNERS_VL

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

View Type

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


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


[View Source]

Columns
Name Datatype Length Mandatory Comments
PARTY_ID NUMBER (15)
Party Id
PARTY_NUMBER VARCHAR2 (30)
Party Number
PARTY_NAME VARCHAR2 (360)
Party Name
PARTY_SITE_ID NUMBER (15)
Address id for the partner
PARTY_SITE_LOCATION_ID NUMBER (15)
Location Id for the partner
ADDRESS1 VARCHAR2 (240)
Address line 1
ADDRESS2 VARCHAR2 (240)
Address line 2
ADDRESS3 VARCHAR2 (240)
Address line 3
ADDRESS4 VARCHAR2 (240)
Address line 4
CITY VARCHAR2 (60)
City
ZIP_CODE VARCHAR2 (60)
Zip Code
STATE VARCHAR2 (60)
State
PROVINCE VARCHAR2 (60)
Province
COUNTY VARCHAR2 (60)
County
COUNTRY VARCHAR2 (60)
Country
EMAIL VARCHAR2 (2000)
Email address
PHONE VARCHAR2 (50)
Phone number
PHONE_EXTENSION VARCHAR2 (20)
Extension for phone number
PHONE_COUNTRY_CODE VARCHAR2 (10)
Country code for phone number
ORG_ID NUMBER (15)
Organization identifier
ORG_NAME VARCHAR2 (360)
Organization Name
Query Text

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


SELECT PARTY_ID
,      PARTY_NUMBER
,      PARTY_NAME
,      PARTY_SITE_ID
,      PARTY_SITE_LOCATION_ID
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      ZIP_CODE
,      STATE
,      PROVINCE
,      COUNTY
,      COUNTRY
,      EMAIL
,      PHONE
,      PHONE_EXTENSION
,      PHONE_COUNTRY_CODE
,      ORG_ID
,      ORG_NAME
FROM APPS.JTF_RS_PARTNERS_VL;

Dependencies

[top of page]

APPS.JTF_RS_PARTNERS_VL references the following:

SchemaAPPS
SynonymHZ_CONTACT_POINTS
SynonymHZ_LOCATIONS
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES
SynonymHZ_RELATIONSHIPS

APPS.JTF_RS_PARTNERS_VL is not referenced by any database object