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

VIEW: APPS.JTF_RS_VENUE_DTLS_VL

Object Details
Object Name: JTF_RS_VENUE_DTLS_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJTF.JTF_RS_VENUE_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='VENUE'


[View Source]

Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER
Yes Resource id of the resource
RESOURCE_NUMBER VARCHAR2 (30) Yes Resource number for the venue resource
SOURCE_ID NUMBER

The venue_id of the venue resource
ADDRESS_ID NUMBER

Address identifier
CONTACT_ID NUMBER

Contact identifier
START_DATE_ACTIVE DATE
Yes Date this Resource becomes active, if limited
END_DATE_ACTIVE DATE

Date this Resource becomes inactive, 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 of the resource
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 Identifier (Foreign key to HZ_PARTY_SITES)
IES_AGENT_LOGIN VARCHAR2 (240)
Email Center Agent Login
SERVER_GROUP_ID NUMBER

Server Group Identifier to which this resource is attached. FK to IEO_SVR_GROUPS , used by interaction centers.
ASSIGNED_TO_GROUP_ID NUMBER

Assigned to User Identifier , Foreign Key to FND_USER.
COST_CENTER VARCHAR2 (30)
Cost Center to which this resource is attached
CHARGE_TO_COST_CENTER VARCHAR2 (30)
Cost center which will be charged for this resource
COMPENSATION_CURRENCY_CODE VARCHAR2 (15)
The currency code in which ther resource will be compensated.
COMMISSIONABLE_FLAG VARCHAR2 (1)
Flag indicating whether the resource is commissionable or not
HOLD_REASON_CODE VARCHAR2 (30)
Reason Code why the payment will be hold
HOLD_PAYMENT VARCHAR2 (1)
Flag indicating whther the payment for the resource is on hold or not.
COMP_SERVICE_TEAM_ID NUMBER

Comp Service Team Id , FK to jtf_rs_teams_vl
TRANSACTION_NUMBER NUMBER

Transaction Number. This will use at the time of import Resources.
SOURCE_NAME VARCHAR2 (2000)
Venue name
ORG_ID VARCHAR2 (360)
Organization identifier
ORG_NAME NUMBER

Organization name
PHONE VARCHAR2 (360)
Phone number
EMAIL VARCHAR2 (2000)
Email address
USER_ID NUMBER

User Id which is assigned to Resource (Foreign key to FND_USER)
RESOURCE_NAME VARCHAR2 (360)
Resource preferred 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
,      SOURCE_NAME
,      ORG_ID
,      ORG_NAME
,      PHONE
,      EMAIL
,      USER_ID
,      RESOURCE_NAME
FROM APPS.JTF_RS_VENUE_DTLS_VL;

Dependencies

[top of page]

APPS.JTF_RS_VENUE_DTLS_VL references the following:

SchemaAPPS
ViewJTF_RS_RESOURCE_EXTNS_VL

APPS.JTF_RS_VENUE_DTLS_VL is not referenced by any database object