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

VIEW: APPS.CS_JTF_RS_RESOURCE_EXTNS_SEC

Object Details
Object Name: CS_JTF_RS_RESOURCE_EXTNS_SEC
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCS.CS_JTF_RS_RESOURCE_EXTNS_SEC
Subobject Name:
Status: VALID

View Type

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


Main resource view that stores all resource data.
XDF utility is used to download/upload security views. View definition is irrelevant over here.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Unique row identifier.
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 for this resource.
ADDRESS_ID NUMBER

Address identifier for this resource.
CONTACT_ID NUMBER

Contact identifier for this resource.
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 to which this resource is associated.
COST_PER_HR NUMBER

Cost Per Hour associated with this resource.
PRIMARY_LANGUAGE VARCHAR2 (30)
Resource's primary language.
SECONDARY_LANGUAGE VARCHAR2 (30)
Resource's secondary language.
IES_AGENT_LOGIN VARCHAR2 (240)
Agent Login identifier.
SERVER_GROUP_ID NUMBER

Server Group identifier.
ASSIGNED_TO_GROUP_ID NUMBER

Group identifier to which this resource is assigned.
COST_CENTER VARCHAR2 (30)
Cost Center to which this resource belongs.
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

Transaction number associated with the import process for this resource.
OBJECT_VERSION_NUMBER NUMBER
Yes Object Version number - for internal use only.
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.
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.
SOURCE_MOBILE_PHONE VARCHAR2 (60)
Source Mobile Phone
SOURCE_PAGER VARCHAR2 (60)
Source Pager
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
,      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
,      SOURCE_MOBILE_PHONE
,      SOURCE_PAGER
FROM APPS.CS_JTF_RS_RESOURCE_EXTNS_SEC;

Dependencies

[top of page]

APPS.CS_JTF_RS_RESOURCE_EXTNS_SEC references the following:

SchemaAPPS
ViewJTF_RS_RESOURCE_EXTNS_VL
APPS.CS_JTF_RS_RESOURCE_EXTNS_SEC is referenced by following:

SchemaAPPS
Package BodyCS_SERVICEREQUEST_UTIL - show dependent code
ViewCS_SR_MEMBERS_V_SEC
ViewCS_SR_OWNERS_SEARCH_V
Package BodyCS_SR_SECURITY_GRP - show dependent code
Package BodyCS_SR_SECURITY_UTIL - show dependent code
Package BodyCS_SR_UTIL_PKG - show dependent code