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

VIEW: APPS.JTF_RS_ACTIVE_RESOURCES_VL

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

View Type

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


This view stores active resources as of sysdate


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Identifier for internal use only.
RESOURCE_ID NUMBER
Yes Resource Identifier.
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CATEGORY VARCHAR2 (30) Yes Resource Category.
RESOURCE_NUMBER VARCHAR2 (30) Yes Resource Number.
SOURCE_ID NUMBER

Source Identifier.
ADDRESS_ID NUMBER

Address Identifier.
CONTACT_ID NUMBER

Contact Identifier.
MANAGING_EMPLOYEE_ID NUMBER

Managing Employee Identifier.
START_DATE_ACTIVE DATE
Yes Effective start date of this resource.
END_DATE_ACTIVE DATE

Effective end date of this resource.
TIME_ZONE NUMBER

TimeZone associated with this resource.
COST_PER_HR NUMBER

Cost Per Hour for this resource.
PRIMARY_LANGUAGE VARCHAR2 (30)
Primary Language for this resource.
SECONDARY_LANGUAGE VARCHAR2 (30)
Secondary language for this resource.
IES_AGENT_LOGIN VARCHAR2 (240)
Agent Login Identifier.
SERVER_GROUP_ID NUMBER

Server Group Identifier.
ASSIGNED_TO_GROUP_ID NUMBER

Identifier of the Group this resource is assignned to.
COST_CENTER VARCHAR2 (30)
Cost Center for this resource.
CHARGE_TO_COST_CENTER VARCHAR2 (30)
Cost Center that should be charged for this resource.
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

Compensation Service Team Identifier.
TRANSACTION_NUMBER NUMBER

Trasnaction number corresponding to the import process for this resource.
OBJECT_VERSION_NUMBER NUMBER
Yes Object Version Number.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
USER_ID NUMBER

User Identifier - foreign key from FND User.
SUPPORT_SITE_ID NUMBER

Support Site identifier from service.
SECURITY_GROUP_ID NUMBER

For applications hosting stds. - internal use only.
RESOURCE_NAME VARCHAR2 (360)
Resource Name.
SOURCE_NAME VARCHAR2 (360)
Source Name.
SOURCE_NUMBER VARCHAR2 (30)
Source Number.
SOURCE_JOB_TITLE VARCHAR2 (240)
Source Job TItle.
SOURCE_EMAIL VARCHAR2 (2000)
Source Email.
SOURCE_PHONE VARCHAR2 (2000)
Source phone number.
SOURCE_ORG_ID NUMBER

Source organization identifier.
SOURCE_ORG_NAME VARCHAR2 (360)
Source organization name.
SOURCE_ADDRESS1 VARCHAR2 (240)
Source address line 1.
SOURCE_ADDRESS2 VARCHAR2 (240)
Source address line 2.
SOURCE_ADDRESS3 VARCHAR2 (240)
Source address line 3.
SOURCE_ADDRESS4 VARCHAR2 (240)
Source address line 4.
SOURCE_CITY VARCHAR2 (60)
Source city.
SOURCE_POSTAL_CODE VARCHAR2 (60)
Source postal code.
SOURCE_STATE VARCHAR2 (150)
Source state.
SOURCE_PROVINCE VARCHAR2 (150)
Source province.
SOURCE_COUNTY VARCHAR2 (150)
Source county.
SOURCE_COUNTRY VARCHAR2 (60)
Source country.
SOURCE_MGR_ID NUMBER

Source manager identifier.
SOURCE_MGR_NAME VARCHAR2 (360)
Source manager name.
SOURCE_BUSINESS_GRP_ID NUMBER

Source business group identifier.
SOURCE_BUSINESS_GRP_NAME VARCHAR2 (360)
Source business group name.
SOURCE_FIRST_NAME VARCHAR2 (360)
Source first name.
SOURCE_MIDDLE_NAME VARCHAR2 (360)
Source middle name.
SOURCE_LAST_NAME VARCHAR2 (360)
Source last name.
SOURCE_CATEGORY VARCHAR2 (360)
Source category.
SOURCE_STATUS VARCHAR2 (360)
Source status.
USER_NAME VARCHAR2 (100)
User Name.
SOURCE_OFFICE VARCHAR2 (45)
Source office.
SOURCE_LOCATION VARCHAR2 (45)
Source location.
SOURCE_MAILSTOP VARCHAR2 (45)
Source mailstop.
Query Text

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


SELECT ROW_ID
,      RESOURCE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CATEGORY
,      RESOURCE_NUMBER
,      SOURCE_ID
,      ADDRESS_ID
,      CONTACT_ID
,      MANAGING_EMPLOYEE_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      TIME_ZONE
,      COST_PER_HR
,      PRIMARY_LANGUAGE
,      SECONDARY_LANGUAGE
,      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
,      OBJECT_VERSION_NUMBER
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      USER_ID
,      SUPPORT_SITE_ID
,      SECURITY_GROUP_ID
,      RESOURCE_NAME
,      SOURCE_NAME
,      SOURCE_NUMBER
,      SOURCE_JOB_TITLE
,      SOURCE_EMAIL
,      SOURCE_PHONE
,      SOURCE_ORG_ID
,      SOURCE_ORG_NAME
,      SOURCE_ADDRESS1
,      SOURCE_ADDRESS2
,      SOURCE_ADDRESS3
,      SOURCE_ADDRESS4
,      SOURCE_CITY
,      SOURCE_POSTAL_CODE
,      SOURCE_STATE
,      SOURCE_PROVINCE
,      SOURCE_COUNTY
,      SOURCE_COUNTRY
,      SOURCE_MGR_ID
,      SOURCE_MGR_NAME
,      SOURCE_BUSINESS_GRP_ID
,      SOURCE_BUSINESS_GRP_NAME
,      SOURCE_FIRST_NAME
,      SOURCE_MIDDLE_NAME
,      SOURCE_LAST_NAME
,      SOURCE_CATEGORY
,      SOURCE_STATUS
,      USER_NAME
,      SOURCE_OFFICE
,      SOURCE_LOCATION
,      SOURCE_MAILSTOP
FROM APPS.JTF_RS_ACTIVE_RESOURCES_VL;

Dependencies

[top of page]

APPS.JTF_RS_ACTIVE_RESOURCES_VL references the following:

SchemaAPPS
SynonymJTF_RS_RESOURCE_EXTNS
SynonymJTF_RS_RESOURCE_EXTNS_TL

APPS.JTF_RS_ACTIVE_RESOURCES_VL is not referenced by any database object