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 |
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 |
|
|
|