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

VIEW: APPS.JTF_RS_PARTY_DTLS_VL

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

View Type

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


This view has the details of all the resources whose category='PARTY'


[View Source]

Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER
Yes The resource id
RESOURCE_NUMBER VARCHAR2 (30) Yes Resource Number
SOURCE_ID NUMBER

Source Identifier
ADDRESS_ID NUMBER

Address Identifier
CONTACT_ID NUMBER

Contact Identifier
START_DATE_ACTIVE DATE
Yes Date this Resource becomes active
END_DATE_ACTIVE DATE

Date this Resource becomes active, if limited
TIME_ZONE NUMBER

This field is used by Service for time zone information (foreign key to HZ_TIMEZONES)
COST_PER_HR NUMBER

This field is used by Service for cost per hour information
PRIMARY_LANGUAGE VARCHAR2 (30)
Primary language for the resource
SECONDARY_LANGUAGE VARCHAR2 (30)
Secondary language for the resource
SUPPORT_SITE_ID NUMBER

Support site from service
IES_AGENT_LOGIN VARCHAR2 (240)
Email Center Agent Login
SERVER_GROUP_ID NUMBER

Server group identifier
ASSIGNED_TO_GROUP_ID NUMBER

Assigned to group id
COST_CENTER VARCHAR2 (30)
Cost Center
CHARGE_TO_COST_CENTER VARCHAR2 (30)
Charge to Cost Center
COMPENSATION_CURRENCY_CODE VARCHAR2 (15)
Compensation Currency code
COMMISSIONABLE_FLAG VARCHAR2 (1)
Commissionable flag
HOLD_REASON_CODE VARCHAR2 (30)
Hold Reason code
HOLD_PAYMENT VARCHAR2 (1)
Hold Payment
COMP_SERVICE_TEAM_ID NUMBER

Comp Service team Id
TRANSACTION_NUMBER NUMBER

Transaction Number. This will use at the time of import Resources.
PHONE VARCHAR2 (2000)
Phone Number
PARTY_NAME VARCHAR2 (360)
Party Name
ORG_ID NUMBER

Organization identifier
ORG_NAME VARCHAR2 (360)
Organization Name
EMAIL VARCHAR2 (2000)
Email
USER_ID NUMBER

User Id
RESOURCE_NAME VARCHAR2 (360)
Resource Name.
Query Text

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


SELECT RESOURCE_ID
,      RESOURCE_NUMBER
,      SOURCE_ID
,      ADDRESS_ID
,      CONTACT_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      TIME_ZONE
,      COST_PER_HR
,      PRIMARY_LANGUAGE
,      SECONDARY_LANGUAGE
,      SUPPORT_SITE_ID
,      IES_AGENT_LOGIN
,      SERVER_GROUP_ID
,      ASSIGNED_TO_GROUP_ID
,      COST_CENTER
,      CHARGE_TO_COST_CENTER
,      COMPENSATION_CURRENCY_CODE
,      COMMISSIONABLE_FLAG
,      HOLD_REASON_CODE
,      HOLD_PAYMENT
,      COMP_SERVICE_TEAM_ID
,      TRANSACTION_NUMBER
,      PHONE
,      PARTY_NAME
,      ORG_ID
,      ORG_NAME
,      EMAIL
,      USER_ID
,      RESOURCE_NAME
FROM APPS.JTF_RS_PARTY_DTLS_VL;

Dependencies

[top of page]

APPS.JTF_RS_PARTY_DTLS_VL references the following:

SchemaAPPS
ViewJTF_RS_RESOURCE_EXTNS_VL

APPS.JTF_RS_PARTY_DTLS_VL is not referenced by any database object