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

VIEW: APPS.JTF_RS_RESOURCE_EXTNS_VL

Object Details
Object Name: JTF_RS_RESOURCE_EXTNS_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJTF.JTF_RS_RESOURCE_EXTNS_VL
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.


[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
SOURCE_JOB_ID NUMBER

Source Job Id
PERSON_PARTY_ID NUMBER

Party Id
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
,      SOURCE_JOB_ID
,      PERSON_PARTY_ID
FROM APPS.JTF_RS_RESOURCE_EXTNS_VL;

Dependencies

[top of page]

APPS.JTF_RS_RESOURCE_EXTNS_VL references the following:

SchemaAPPS
SynonymJTF_RS_RESOURCE_EXTNS
SynonymJTF_RS_RESOURCE_EXTNS_TL
APPS.JTF_RS_RESOURCE_EXTNS_VL is referenced by following:

SchemaAPPS
ViewAMS_DS_ACCESSES_ALL_V
ViewAMS_PROGRAM_COMPONENTS_V
Package BodyAR_CMGT_UTIL - show dependent code
Package BodyAR_CMGT_WF_ENGINE - show dependent code
ViewASO_PVT_VIEW_SALESCREDIT_UI_V
ViewASO_SALES_CREDITS_V
Package BodyASP_SERVICE_CONTENT_PROVIDER - show dependent code
ViewAST_ORDER_HEADERS_V
Package BodyBIX_CAMP_PERF_REPORT - show dependent code
ViewBIX_DM_AGENT_SEC_PARAM_V
ViewBIX_DM_EMAIL_AGENTS_V
ViewBIX_DM_GROUP_BIN_PARAM_V
ViewBIX_DM_GROUP_RPT_PARAM_V
Package BodyBIX_REAL_TIME_RPTS_PKG - show dependent code
ViewCAC_CAL_RESOURCES
Package BodyCN_GET_TX_DATA_PUB - show dependent code
Package BodyCN_PAYMENT_SECURITY_PVT - show dependent code
Package BodyCN_PSUM_PVT - show dependent code
ViewCN_SALESREPS
ViewCN_SRP_HR_DATA
ViewCSC_INTERACTIONS_V
Package BodyCSF_RESOURCE_PUB - show dependent code
Package BodyCSP_SHIP_TO_ADDRESS_PVT - show dependent code
Package BodyCSZ_SERVICEREQUEST_UTIL_PVT - show dependent code
ViewCS_JTF_RS_RESOURCE_EXTNS_SEC
ViewCS_SR_INTERACTIONS_V
ViewCS_SR_MEMBERS_V
ViewCS_SR_MEMBERS_V_SEC
ViewCS_SR_REPORT_V
Package BodyCS_TZ_GET_DETAILS_PVT - show dependent code
Package BodyCS_WF_AUTO_NTFY_UPDATE_PKG - show dependent code
Package BodyCS_WF_EVENT_PKG - show dependent code
ViewHZ_SITE_USES_V
PL/SQL PackageIEM_AGENT_INBOX_MGMT_PVT - show dependent code
Package BodyIEM_AGENT_INBOX_MGMT_PVT - show dependent code
Package BodyIEU_DIAG_AUDIT_TRACK_PVT - show dependent code
ViewIEU_WP_TASK_OWNR_LOV_V
PL/SQL PackageIEX_CALL_HISTORY - show dependent code
Package BodyIEX_CALL_HISTORY - show dependent code
ViewIEX_CUST_INTERACTION_HISTORY_V
ViewIEX_INTERACTION_HISTORY_V
Package BodyIEX_PROCESS_ACCOUNT_WINNERS - show dependent code
PL/SQL PackageIEX_PROFILE - show dependent code
Package BodyIEX_TERR_PUB - show dependent code
Package BodyJTF_ASSIGN_PUB - show dependent code
ViewJTF_IH_ACTIVITIES_VL
ViewJTF_IH_ACTIVITIES_VL3
ViewJTF_IH_INTERACTIONS_ONLY_VL
ViewJTF_IH_INTERACTIONS_VL
ViewJTF_IH_INTERACTIONS_VL2
Package BodyJTF_RS_CONC_RES_PUB - show dependent code
Package BodyJTF_RS_CONC_WF_PUB - show dependent code
Package BodyJTF_RS_DBI_CONC_PUB - show dependent code
ViewJTF_RS_DEFRESOURCES_V
ViewJTF_RS_DEFRESOURCES_VL
ViewJTF_RS_EMP_DTLS_VL
ViewJTF_RS_GROUP_MEMBERS_VL
Package BodyJTF_RS_GROUP_REPORT_PUB - show dependent code
Package BodyJTF_RS_GRP_MEMBERSHIP_PUB - show dependent code
Package BodyJTF_RS_JSP_LOV_RECS_PUB - show dependent code
ViewJTF_RS_OTHER_DTLS_VL
ViewJTF_RS_PARTNER_DTLS_VL
ViewJTF_RS_PARTY_DTLS_VL
ViewJTF_RS_RESOURCE_DTLS_VL
Package BodyJTF_RS_RESOURCE_EXTNS_AUD_PVT - show dependent code
Package BodyJTF_RS_RESOURCE_EXTNS_PKG - show dependent code
PL/SQL PackageJTF_RS_RESOURCE_PVT - show dependent code
Package BodyJTF_RS_RESOURCE_PVT - show dependent code
PL/SQL PackageJTF_RS_RESOURCE_WF_PUB - show dependent code
Package BodyJTF_RS_RESOURCE_WF_PUB - show dependent code
Package BodyJTF_RS_RES_SSWA_PUB - show dependent code
Package BodyJTF_RS_SKILLS_REPORT_PUB - show dependent code
ViewJTF_RS_SUPPLIER_DTLS_VL
ViewJTF_RS_VENUE_DTLS_VL
ViewJTF_RS_WEB_AVAILABLE_V
Package BodyJTF_RS_WF_EVENTS_PUB - show dependent code
Package BodyJTF_RS_WF_INTEGRATION_PUB - show dependent code
ViewJTF_TASK_RESOURCES_VL
Package BodyJTF_TERR_ENGINE_GEN_PVT - show dependent code
ViewJTF_TERR_QLFY_RSC_DST_V
Package BodyJTF_TTY_ALIGN_WEBADI_INT_PKG - show dependent code
ViewJTF_TTY_ALL_RESOURCES_V
Package BodyJTF_TTY_EXCEL_NAORG_PVT - show dependent code
ViewJTF_TTY_GEO_TERR_OWNER_LOV_V
Package BodyJTF_TTY_MAINTAIN_NA_PVT - show dependent code
ViewJTF_TTY_MY_DIRECTS_V
ViewJTF_TTY_MY_RESOURCES_V
ViewJTF_TTY_SRCH_MY_RESOURCES_V
Package BodyJTF_TTY_WEBADI_NADOC_PKG - show dependent code
Package BodyJTF_TTY_WEBADI_SALSTEAM_UPDATE - show dependent code
Package BodyJTY_TERR_ENGINE_GEN_PVT - show dependent code
ViewOE_AS_ORDER_HEADERS_V
ViewOKC_LAUNCH_COMMGRID_V
ViewOKC_REL_OBJ_QUOTE_HEADERS_V
Package BodyOKC_REP_UPD_CON_ADMIN_PVT - show dependent code
ViewOKI_JTF_TERRITORIES_V
ViewOKI_RES_OLTP_V
Package BodyOKS_CUSTOMER_ACCEPTANCE_PVT - show dependent code
Package BodyOKS_IB_UTIL_PVT - show dependent code
Package BodyOKS_IMPORT_TEST_INSERT - show dependent code
Package BodyOKS_RENEW_CONTRACT_PVT - show dependent code
ViewOKS_REP_V
ViewOKX_SALESREPS_V
ViewPRP_PROP_CUSTOMERS_V
ViewPRP_PROP_OBJECTS_V
Package BodyPV_ASSIGNMENT_PVT - show dependent code
Package BodyPV_PG_NOTIF_UTILITY_PVT - show dependent code
Package BodyPV_PRGM_APPROVAL_PVT - show dependent code
Package BodyQOT_DEFAULT_PVT - show dependent code
ViewRA_SALESREPS