eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: JTF_RS_RESOURCE_EXTNS

Product:	JTF - CRM Foundation
Description:	This is table stores all important information about Resources. These Resources are coming from HR or HZ or Vonder table etc. Primary key is resource_id. Resource_number, user_id sre also unique keys.
Implementation/DBA Data:	JTF.JTF_RS_RESOURCE_EXTNS

Primary Key: JTF_RS_RESOURCE_EXTNS_PK

RESOURCE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
JTF_RS_RESOURCE_EXTNS	JTF_OBJECTS_B	JTF_RS_RESOURCE_EXTNS.CATEGORY
JTF_RS_RESOURCE_EXTNS	HZ_PARTY_SITES	JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID
JTF_RS_RESOURCE_EXTNS	HZ_ORG_CONTACTS	JTF_RS_RESOURCE_EXTNS.CONTACT_ID
AMS_ACT_ACCESS_DENORM	JTF_RS_RESOURCE_EXTNS	AMS_ACT_ACCESS_DENORM.RESOURCE_ID
AMS_ACT_RESOURCES	JTF_RS_RESOURCE_EXTNS	AMS_ACT_RESOURCES.RESOURCE_ID
AMS_CAMPAIGNS_ALL_B	JTF_RS_RESOURCE_EXTNS	AMS_CAMPAIGNS_ALL_B.OWNER_USER_ID
AMS_CAMPAIGN_SCHEDULES_B	JTF_RS_RESOURCE_EXTNS	AMS_CAMPAIGN_SCHEDULES_B.OWNER_USER_ID
AMS_CAMPAIGN_SCHEDULES_B	JTF_RS_RESOURCE_EXTNS	AMS_CAMPAIGN_SCHEDULES_B.APPROVER_USER_ID
AMS_CAMPAIGN_SCHEDULES_B	JTF_RS_RESOURCE_EXTNS	AMS_CAMPAIGN_SCHEDULES_B.NOTIFY_USER_ID
AMS_CELLS_ALL_B	JTF_RS_RESOURCE_EXTNS	AMS_CELLS_ALL_B.OWNER_ID
AMS_DELIVERABLES_ALL_B	JTF_RS_RESOURCE_EXTNS	AMS_DELIVERABLES_ALL_B.OWNER_USER_ID
AMS_DIALOGS_ALL_B	JTF_RS_RESOURCE_EXTNS	AMS_DIALOGS_ALL_B.OWNER_ID
AMS_DM_MODELS_ALL_B	JTF_RS_RESOURCE_EXTNS	AMS_DM_MODELS_ALL_B.OWNER_USER_ID
AMS_EVENT_HEADERS_ALL_B	JTF_RS_RESOURCE_EXTNS	AMS_EVENT_HEADERS_ALL_B.OWNER_USER_ID
AMS_EVENT_HEADERS_ALL_B	JTF_RS_RESOURCE_EXTNS	AMS_EVENT_HEADERS_ALL_B.COORDINATOR_ID
AMS_EVENT_OFFERS_ALL_B	JTF_RS_RESOURCE_EXTNS	AMS_EVENT_OFFERS_ALL_B.COORDINATOR_ID
AMS_EVENT_OFFERS_ALL_B	JTF_RS_RESOURCE_EXTNS	AMS_EVENT_OFFERS_ALL_B.OWNER_USER_ID
AMS_EVENT_REGISTRATIONS	JTF_RS_RESOURCE_EXTNS	AMS_EVENT_REGISTRATIONS.OWNER_USER_ID
AMS_IMP_LIST_HEADERS_ALL	JTF_RS_RESOURCE_EXTNS	AMS_IMP_LIST_HEADERS_ALL.OWNER_USER_ID
AMS_ITEM_ATTRIBUTES	JTF_RS_RESOURCE_EXTNS	AMS_ITEM_ATTRIBUTES.OWNER_ID
AMS_MESSAGES_B	JTF_RS_RESOURCE_EXTNS	AMS_MESSAGES_B.OWNER_USER_ID
AMS_OFFERS	JTF_RS_RESOURCE_EXTNS	AMS_OFFERS.OWNER_ID
AMS_PRICE_LIST_ATTRIBUTES	JTF_RS_RESOURCE_EXTNS	AMS_PRICE_LIST_ATTRIBUTES.OWNER_ID
AMS_TRIGGER_ACTIONS	JTF_RS_RESOURCE_EXTNS	AMS_TRIGGER_ACTIONS.ACTION_APPROVER_USER_ID
AMV_C_CHANNELS_B	JTF_RS_RESOURCE_EXTNS	AMV_C_CHANNELS_B.OWNER_USER_ID
AMV_C_CHANNELS_B	JTF_RS_RESOURCE_EXTNS	AMV_C_CHANNELS_B.DEFAULT_APPROVER_USER_ID
AMV_USER_TICKER	JTF_RS_RESOURCE_EXTNS	AMV_USER_TICKER.USER_ID
AMV_U_ACCESS	JTF_RS_RESOURCE_EXTNS	AMV_U_ACCESS.USER_OR_GROUP_ID
AMV_U_MY_CHANNELS	JTF_RS_RESOURCE_EXTNS	AMV_U_MY_CHANNELS.USER_OR_GROUP_ID
AR_COLLECTORS	JTF_RS_RESOURCE_EXTNS	AR_COLLECTORS.RESOURCE_ID
ASG_DEVICE_USERS	JTF_RS_RESOURCE_EXTNS	ASG_DEVICE_USERS.RESOURCE_ID
ASO_APR_APPROVAL_DET_B	JTF_RS_RESOURCE_EXTNS	ASO_APR_APPROVAL_DET_B.JTF_RS_APPROVER_ID
ASO_SALES_CREDITS	JTF_RS_RESOURCE_EXTNS	ASO_SALES_CREDITS.RESOURCE_ID
AS_ACCESSES_ALL_ALL	JTF_RS_RESOURCE_EXTNS	AS_ACCESSES_ALL_ALL.SALESFORCE_ID
AS_AP_STRTGC_OBJECTIVES	JTF_RS_RESOURCE_EXTNS	AS_AP_STRTGC_OBJECTIVES.OWNER_SALESFORCE_ID
AS_AP_TRACKING_OBJECTIVES	JTF_RS_RESOURCE_EXTNS	AS_AP_TRACKING_OBJECTIVES.OWNER_SALESFORCE_ID
AS_FORECAST_ACTUALS	JTF_RS_RESOURCE_EXTNS	AS_FORECAST_ACTUALS.SALESFORCE_ID
AS_INTERNAL_FORECASTS	JTF_RS_RESOURCE_EXTNS	AS_INTERNAL_FORECASTS.SALESFORCE_ID
AS_LEADS_ALL	JTF_RS_RESOURCE_EXTNS	AS_LEADS_ALL.OWNER_SALESFORCE_ID
AS_REF_ASSET_USAGES	JTF_RS_RESOURCE_EXTNS	AS_REF_ASSET_USAGES.RESOURCE_ID
AS_SALES_CREDITS_DENORM	JTF_RS_RESOURCE_EXTNS	AS_SALES_CREDITS_DENORM.SALESFORCE_ID
AS_SALES_CREDITS	JTF_RS_RESOURCE_EXTNS	AS_SALES_CREDITS.SALESFORCE_ID
AS_SALES_LEADS	JTF_RS_RESOURCE_EXTNS	AS_SALES_LEADS.ASSIGN_TO_SALESFORCE_ID
AS_TERR_RESOURCES_TMP	JTF_RS_RESOURCE_EXTNS	AS_TERR_RESOURCES_TMP.RESOURCE_ID
CSD_REPAIRS	JTF_RS_RESOURCE_EXTNS	CSD_REPAIRS.RESOURCE_ID
CSD_REPAIRS	JTF_RS_RESOURCE_EXTNS	CSD_REPAIRS.RESOURCE_ID
CSS_DEF_DEFECTS_B	JTF_RS_RESOURCE_EXTNS	CSS_DEF_DEFECTS_B.PHASE_OWNER_ID
CSS_DEF_DEF_CONTACTS	JTF_RS_RESOURCE_EXTNS	CSS_DEF_DEF_CONTACTS.OBJECT_ID
CS_CONTACTS	JTF_RS_RESOURCE_EXTNS	CS_CONTACTS.CONTACT_ID
CS_INCIDENTS_ALL_B	JTF_RS_RESOURCE_EXTNS	CS_INCIDENTS_ALL_B.INCIDENT_OWNER_ID
CUG_SR_TASK_TYPE_DETS_B	JTF_RS_RESOURCE_EXTNS	CUG_SR_TASK_TYPE_DETS_B.OWNER_ID
CUG_SR_TYPE_DUP_CHK_INFO	JTF_RS_RESOURCE_EXTNS	CUG_SR_TYPE_DUP_CHK_INFO.RESOURCE_ID
IEU_MSG_MESSAGES	JTF_RS_RESOURCE_EXTNS	IEU_MSG_MESSAGES.RESOURCE_ID
IEU_UWQM_ITEMS	JTF_RS_RESOURCE_EXTNS	IEU_UWQM_ITEMS.ASSIGNEE_ID
IEU_UWQM_ITEMS	JTF_RS_RESOURCE_EXTNS	IEU_UWQM_ITEMS.OWNER_ID
JTF_CAL_ADDRESSES	JTF_RS_RESOURCE_EXTNS	JTF_CAL_ADDRESSES.RESOURCE_ID
JTF_IH_INTERACTIONS	JTF_RS_RESOURCE_EXTNS	JTF_IH_INTERACTIONS.RESOURCE_ID
JTF_RS_ACTIVE_GRP_MBRS	JTF_RS_RESOURCE_EXTNS	JTF_RS_ACTIVE_GRP_MBRS.RESOURCE_ID
JTF_RS_RESOURCE_EXTNS_TL	JTF_RS_RESOURCE_EXTNS	JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_ID
JTF_RS_GROUP_MEMBERS	JTF_RS_RESOURCE_EXTNS	JTF_RS_GROUP_MEMBERS.RESOURCE_ID
JTF_RS_REP_MANAGERS	JTF_RS_RESOURCE_EXTNS	JTF_RS_REP_MANAGERS.RESOURCE_ID
JTF_RS_RESOURCE_DENORM	JTF_RS_RESOURCE_EXTNS	JTF_RS_RESOURCE_DENORM.RESOURCE_ID
JTF_RS_RESOURCE_DENORM	JTF_RS_RESOURCE_EXTNS	JTF_RS_RESOURCE_DENORM.PARENT_RESOURCE_ID
JTF_RS_RESOURCE_EXTN_AUD	JTF_RS_RESOURCE_EXTNS	JTF_RS_RESOURCE_EXTN_AUD.RESOURCE_ID
JTF_RS_RESOURCE_VALUES	JTF_RS_RESOURCE_EXTNS	JTF_RS_RESOURCE_VALUES.RESOURCE_ID
JTF_RS_ROLE_RELATIONS	JTF_RS_RESOURCE_EXTNS	JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID
JTF_RS_SALESREPS	JTF_RS_RESOURCE_EXTNS	JTF_RS_SALESREPS.RESOURCE_ID
JTF_RS_TEAM_MEMBERS	JTF_RS_RESOURCE_EXTNS	JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID
JTF_TERR_RSC_ALL	JTF_RS_RESOURCE_EXTNS	JTF_TERR_RSC_ALL.RESOURCE_ID
JTF_TTY_ACCT_RSC_DN	JTF_RS_RESOURCE_EXTNS	JTF_TTY_ACCT_RSC_DN.RESOURCE_ID
JTF_TTY_ALIGNMENTS	JTF_RS_RESOURCE_EXTNS	JTF_TTY_ALIGNMENTS.OWNER_RESOURCE_ID
JTF_TTY_ALIGN_PTERR	JTF_RS_RESOURCE_EXTNS	JTF_TTY_ALIGN_PTERR.RESOURCE_ID
JTF_TTY_NAMED_ACCT_RSC	JTF_RS_RESOURCE_EXTNS	JTF_TTY_NAMED_ACCT_RSC.RESOURCE_ID
JTF_TTY_RSC_ACCT_SUMM	JTF_RS_RESOURCE_EXTNS	JTF_TTY_RSC_ACCT_SUMM.RESOURCE_ID
JTF_TTY_TERR_GRP_OWNERS	JTF_RS_RESOURCE_EXTNS	JTF_TTY_TERR_GRP_OWNERS.RESOURCE_ID
LNS_LOAN_HEADERS_ALL	JTF_RS_RESOURCE_EXTNS	LNS_LOAN_HEADERS_ALL.LOAN_ASSIGNED_TO
LNS_LOAN_HEADERS_ALL	JTF_RS_RESOURCE_EXTNS	LNS_LOAN_HEADERS_ALL.LOAN_APPROVED_BY
PV_REFERRALS_B	JTF_RS_RESOURCE_EXTNS	PV_REFERRALS_B.PARTNER_CONTACT_RESOURCE_ID
OKC_K_ACCESSES	JTF_RS_RESOURCE_EXTNS	OKC_K_ACCESSES.RESOURCE_ID
OKC_REP_CONTRACT_ACCESS	JTF_RS_RESOURCE_EXTNS	OKC_REP_CONTRACT_ACCESS.RESOURCE_ID
OKL_INS_POLICIES_ALL_B	JTF_RS_RESOURCE_EXTNS	OKL_INS_POLICIES_ALL_B.ADJUSTED_BY_ID
OKL_INS_POLICIES_ALL_B	JTF_RS_RESOURCE_EXTNS	OKL_INS_POLICIES_ALL_B.SALES_REP_ID
OKL_INS_POLICIES_B	JTF_RS_RESOURCE_EXTNS	OKL_INS_POLICIES_B.ADJUSTED_BY_ID
OKL_INS_POLICIES_B	JTF_RS_RESOURCE_EXTNS	OKL_INS_POLICIES_B.SALES_REP_ID
OZF_OFFERS	JTF_RS_RESOURCE_EXTNS	OZF_OFFERS.OWNER_ID
OZF_PRICE_LIST_ATTRIBUTES	JTF_RS_RESOURCE_EXTNS	OZF_PRICE_LIST_ATTRIBUTES.OWNER_ID
PA_RESOURCES	JTF_RS_RESOURCE_EXTNS	PA_RESOURCES.RESOURCE_ID
PV_COUNTRY_RSBLTS	JTF_RS_RESOURCE_EXTNS	PV_COUNTRY_RSBLTS.RESOURCE_ID
PV_LEAD_ASSIGNMENTS	JTF_RS_RESOURCE_EXTNS	PV_LEAD_ASSIGNMENTS.CM_ID
PV_MDF_OWNERS	JTF_RS_RESOURCE_EXTNS	PV_MDF_OWNERS.CMM_RESOURCE_ID
PV_PARTNER_PROFILES	JTF_RS_RESOURCE_EXTNS	PV_PARTNER_PROFILES.CM_ID
PV_PARTNER_PROFILES	JTF_RS_RESOURCE_EXTNS	PV_PARTNER_PROFILES.PH_SUPPORT_REP
PV_PARTY_NOTIFICATIONS	JTF_RS_RESOURCE_EXTNS	PV_PARTY_NOTIFICATIONS.RESOURCE_ID
PV_PG_ENRL_REQUESTS	JTF_RS_RESOURCE_EXTNS	PV_PG_ENRL_REQUESTS.REQUESTOR_RESOURCE_ID
PV_RELATIONSHIPS	JTF_RS_RESOURCE_EXTNS	PV_RELATIONSHIPS.SUBJECT_ID
AST_RS_CAMPAIGNS	JTF_RS_RESOURCE_EXTNS	AST_RS_CAMPAIGNS.RESOURCE_ID