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

VIEW: APPS.JTF_RS_PARTNER_DTLS_VL

Object Details
Object Name: JTF_RS_PARTNER_DTLS_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJTF.JTF_RS_PARTNER_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='PARTNER'


[View Source]

Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER
Yes 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 inactive(if limited)
TIME_ZONE NUMBER

This field is used by Service for time zone information
COST_PER_HR NUMBER

This field is used by Service for cost per hour information
PRIMARY_LANGUAGE VARCHAR2 (30)
This field is used by Service for the primary language of the resource
SECONDARY_LANGUAGE VARCHAR2 (30)
This field is used by Service for the secondary language of 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 Sevice team id
TRANSACTION_NUMBER NUMBER

Transaction Number. This will use at the time of import Resources.
PARTNER_NAME VARCHAR2 (360)
Partner name
ORG_ID NUMBER

Organization identifier
ORG_NAME VARCHAR2 (360)
Organization Name
EMAIL VARCHAR2 (2000)
Email
PHONE VARCHAR2 (2000)
Phone number
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
,      PARTNER_NAME
,      ORG_ID
,      ORG_NAME
,      EMAIL
,      PHONE
,      USER_ID
,      RESOURCE_NAME
FROM APPS.JTF_RS_PARTNER_DTLS_VL;

Dependencies

[top of page]

APPS.JTF_RS_PARTNER_DTLS_VL references the following:

SchemaAPPS
ViewJTF_RS_RESOURCE_EXTNS_VL

APPS.JTF_RS_PARTNER_DTLS_VL is not referenced by any database object