JTF Views (364)

JTF - CRM Foundation — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

View	Description
`CAC_SR_PERIODS_VL`	This view contains describing attributes for a period.
`CAC_SR_PERIOD_CATS_VL`
`CAC_SR_PERIOD_DTL_TYPES_VL`	This view contains describing attributes for a period detail type.
`CAC_SR_SCHEDULES_VL`
`CAC_SR_TEMPLATES_VL`
`CAC_TASK_RS_EXTNS_SEC`
`CAC_TASK_RS_GROUPS_SEC`
`CAC_TASK_RS_TEAMS_SEC`
`JTA_UM_MAIL_PREFERENCE_V`
`JTF_AGENDA_TA_V`	Base view for the JTF_AGENDA_TA_V
`JTF_AGENDA_V`	Calculates predicted start and end times of valid assigned tasks
`JTF_AMV_ATTACHMENTS_V`	JTF_AMV_ATTACHMENTS_V is a view on the attachment details
`JTF_AMV_ITEMS_VL`	JTF_AMV_ITEMS_VL is a view on the base and translation tables that contains the translated data based on the current language.
`JTF_AMV_ITEM_AUTHORS_V`	JTF_AMV_ITEM_AUTHORS_V is a view on the item authors
`JTF_AMV_ITEM_KEYWORDS_V`	JTF_AMV_ITEM_KEYWORDS_V is a view based on the item keywords
`JTF_AM_SCREEN_SETUPS_VL`	This is the translated view for JTF Assignment Manager JTF_AM_SCREEN_SETUPS_B and JTF_AM_SCREEN_SETUPS_TL tables
`JTF_AM_TASK_DTLS_V`	This is a view to get task details for Assignments
`JTF_BILLING_PREFERENCES_V`	JTF_BILLING_PREFERENCES_V describes the invoicing format preferred by customer accounts or customer account sites
`JTF_BRM_3D_TASK_V`	3D task view as used by the business rule monitor.
`JTF_BRM_EXPRESSION_LINES_V`	View used in the simple tab of the business rule workbench form.
`JTF_BRM_PARAMETERS_V`	View used for the business rule monitor form.
`JTF_BRM_RULES_V`	View used for the business rule workbench form.
`JTF_BRM_RULES_VL`	View for translation of business rule data
`JTF_BRM_WF_ATTR_V`	View used for the business rule workbench form.
`JTF_BRM_WF_ATTR_VALUES_V`	View used for the business rule workbench form.
`JTF_CALENDARS_VL`	View for table JTF_CALENDARS_B.
`JTF_CAL_EXCEPTIONS_VL`	View for table JTF_CAL_EXCEPTIONS_B.
`JTF_CAL_EXCP_ASSIGN_V`	View for table JTF_CAL_EXCEPTION_ASSIGN, and view JTF_CAL_EXCEPTIONS_VL.
`JTF_CAL_RES_ASSIGN_V`	View for table JTF_CAL_RESOURCE_ASSIGN , and view JTF_RS_ALL_RESOURCES_VL
`JTF_CAL_SHIFTS_VL`	View for table JTF_CAL_SHIFTS_B.
`JTF_CAL_SHIFT_ASSIGN_V`	View for table JTF_CAL_SHIFT_ASSIGN, and view JTF_CAL_SHIFTS_VL.
`JTF_CAL_SHIFT_CONS_V`	View for table JTF_CAL_SHIFT_CONSTRUCTS.
`JTF_CHANGED_TERR`
`JTF_CONTACT_POINTS_V`	Contact details of each party, like Phone and Email
`JTF_CONTACT_RESTRICTIONS_V`	The duration and reason for which a contact type is restricted
`JTF_CUSTOMER_PROFILES_V`	JTF_CUSTOMER_PROFILES_V retrieves credit information for your customer accounts and customer account sites
`JTF_CUST_ACCOUNTS_ALL_V`	Account information of a Party. This view is identical to the underlying table HZ_CUST_ACCOUNTS. View is created so that it serves as a sing
`JTF_CUST_ACCOUNTS_ROLES_V`	JTF_CUST_ACCOUNT_ROLES retrieves information about the roles that parties perform in customer accounts.
`JTF_CUST_ACCOUNTS_V`	JTF_CUST_ACCOUNTS_V retrieves information about customer relationships. If a party becomes a customer, information about the customer accou
`JTF_CUST_ACCT_SITES_V`	JTF_CUST_ACCT_SITES retrieves information about customer sites. One customer account can have multiple sites.
`JTF_DPF_LOGICAL_FLOWS_VL`
`JTF_DPF_LOGICAL_PAGES_VL`
`JTF_DPF_RULES_VL`
`JTF_DSP_AMV_ITEMS_V`
`JTF_DSP_ATTACHMENTS_V`
`JTF_DSP_CONTEXT_V`
`JTF_DSP_CONTEXT_VL`
`JTF_DSP_FEATURED_MEDIA_V`
`JTF_DSP_LGL_PHYS_MAP_V`
`JTF_DSP_LGL_TEMPLATES_V`
`JTF_DSP_OBJ_LGL_CTNT_V`
`JTF_DSP_SECTIONS_VL`
`JTF_DSP_TPL_CONTEXT_V`
`JTF_DSP_TPL_CTG_V`
`JTF_DSP_TPL_ITEM_CTG_V`
`JTF_EC_ESC_CONTACTS_REF_DOCS`	Internal View for Escalation Reference Documents
`JTF_EC_STATUSES_VL`
`JTF_ESCALATION_TASK_V`	Internal View for Escalations
`JTF_ESC_UWQ_V`	This view contains escalation details to be displayed in Universal Work Queue.
`JTF_EXCEPTIONS`	Same as JTF_EXCEPTIONS_ALL
`JTF_FM_AMV_ATTACH_VL`	View referring to the JTF_AMV_ATTACHMENTS_V view
`JTF_FM_AMV_ITEMS_VL`	View referring to the JTF_AMV_ITEMS_VL view
`JTF_FM_CONTENT_HISTORY_V`	View referring to the JTF_FM_CONTENT_HISTORY table
`JTF_FM_DISPATCHERS_V`	View referring to the JTF_FM_DISPATCHERS table
`JTF_FM_EMAIL_JTF_FM_GROUPS_V`	View referring to the JTF_FM_EMAIL_JTF_FM_GROUPS table
`JTF_FM_EMAIL_STATS_V`	View to display statics of the email sent for specific requests.
`JTF_FM_EMAIL_V`	View referring to the JTF_FM_EMAIL table
`JTF_FM_FAILURES_V`	View on JTF_FM_CONTENT_FAILURES and JTF_FM_PROCESSED table to provide information on a given request for a given party_id
`JTF_FM_FAX_JTF_FM_GROUPS_V`	View referring to the JTF_FM_FAX_JTF_FM_GROUPS table.
`JTF_FM_FAX_V`	View referring to the JTF_FM_FAX table
`JTF_FM_FILE_JTF_FM_GROUPS_V`	view referring to the JTF_FM_FILE_JTF_FM_GROUP table.
`JTF_FM_FILE_V`	view referring to the JTF_FM_FILE table
`JTF_FM_FND_LOBS_V`	View referring to the FND_LOBS table
`JTF_FM_FND_PRINTER_V`	View referring to the FND_PRINTER table
`JTF_FM_FND_USER_V`	View referring to the FND_USER table
`JTF_FM_GROUP`	Stores info about fulfillment groups
`JTF_FM_GROUP_FND_USER_V`	view referring to the JTF_FM_GROUP_FND_USER table.
`JTF_FM_HIST_V`	View to show detailed history of each fulfillment request
`JTF_FM_MASTER_DOC_V`	View to show the content ID's and queries for master documents
`JTF_FM_PREVIEWS_V`	View to JTF_FM_PREVIEWS table
`JTF_FM_PRINTER_JTF_FM_GROUPS_V`	view referring to the JTF_FM_PRINTER_JTF_FM_GROUPS table.
`JTF_FM_PRINTER_LOOKUPS_USERS_V`	View to Lookup Printers associated with a user.
`JTF_FM_PRINTER_LOOKUPS_V`	View to lookup printers
`JTF_FM_PRINTER_V`	view referring to the JTF_FM_PRINTER table.
`JTF_FM_PROCESSED_V`	View on table JTF_FM_PROCESSED
`JTF_FM_QUERY`	This view refers to the table JTF_FM_QUERY storing information about the fulfillment queries
`JTF_FM_QUERY_MES_V`	view referring to the JTF_FM_QUERY_MES table.
`JTF_FM_REQUEST_HISTORY`	Stores request history information
`JTF_FM_SERVICE`	Stores information about the fulfillment servers
`JTF_FM_STATUS`	stores information about the fulfillment status for requests
`JTF_FM_TEMPLATE`	stores information about the fulfillment templates
`JTF_FM_TEMPLATE_CONTENTS_V`	Stores detailed information about the fulfillment templates and their contents
`JTF_FM_TEMPLATE_CONTENTS_V2`	view referring to the JTF_FM_TEMPLATE_CONTENTS table.
`JTF_GRID_COLS_VL`	MLS view for JTF_GRID_COLS_B and JTF_GRID_COLS_TL
`JTF_GRID_DATASOURCES_VL`	MLS view for JTF_GRID_DATASOURCES_B and JTF_GRID_DATASOURCES_TL
`JTF_HZ_CUST_ACCT_RELATE_V`	JTF_HZ_CUST_ACCT_RELATE_V retrieves information about relationships between customer accounts. A flag allows you to indicate whether a rela
`JTF_HZ_ORGANIZATION_PROFILES_V`	JTF_HZ_ORGANIZATION_PROFILES_V retrieves information about people as contacts for organizations. The table includes information
`JTF_HZ_PARTIES_V`	JTF_HZ_PARTIES_V retrieves information about parties such as organizations, people, and groups, including the identifying address info
`JTF_HZ_PARTY_LOCATIONS_V`	JTF_HZ_LOCATIONS_V retreives information about locations. Other entities, such as parties, can reference the locations stored in t
`JTF_IAPP_FAMILIES_VL`	Multilingual VL view
`JTF_IH_ACTIONS_VL`	Translated view of JTF_IH_ACTIONS_B and JTF_IH_ACTIONS_TL
`JTF_IH_ACTION_ACTION_ITEMS_VL`	Translated view of the related Action (JTF_IH_ACTIONS_VL) and Action Item (JTF_IH_ACTION_ITEMS_VL) pairs. Used to default Interaction Acti
`JTF_IH_ACTION_ITEMS_VL`	Translated view of JTF_IH_ACTION_ITEMS_B and JTF_IH_ACTION_ITEMS_TL.
`JTF_IH_ACTIVE_ACTIONS_VL`	Translated all active rows from view of JTF_IH_ACTIONS_B and JTF_IH_ACTIONS_TL
`JTF_IH_ACTIVE_ACTION_ITEMS_VL`	Translated all active rows from view of JTF_IH_ACTION_ITEMS_B and JTF_IH_ACTION_ITEMS_TL.
`JTF_IH_ACTIVE_OUTCOMES_VL`	Translated active rows from view for JTF_IH_OUTCOMES_B and JTF_IH_OUTCOMES_TL.
`JTF_IH_ACTIVE_REASONS_VL`	Translated all active rows from view for JTF_IH_REASONS_B and JTF_IH_REASONS_TL.
`JTF_IH_ACTIVE_RESULTS_VL`	Translated active rows from view for JTF_IH_RESULTS_B and JTF_IH_RESULTS_TL.
`JTF_IH_ACTIVE_WRAP_UPS_VL`
`JTF_IH_ACTIVITIES_V`	Used for generating reports for records in table JTF_IH_ACTIVITIES.
`JTF_IH_ACTIVITIES_VL`	Interaction History Activities View
`JTF_IH_ACTIVITIES_VL2`	Interaction History Activities View
`JTF_IH_ACTIVITIES_VL3`	Interaction History Activities View
`JTF_IH_ACTIVITIES_VL4`	Interaction History Activities View
`JTF_IH_ALL_NOTES_VL`	Allows to view JTF Notes attched to Interactions
`JTF_IH_INTERACTIONS_ONLY_VL`	Interactions View
`JTF_IH_INTERACTIONS_V`	Used for generating reports for records in table JTF_IH_INTERACTIONS.
`JTF_IH_INTERACTIONS_VL`	Interactions View
`JTF_IH_INTERACTIONS_VL2`	Interactions View
`JTF_IH_MEDIA_ITEMS_V`	Used for generating reports for records in table JTF_IH_MEDIA_ITEMS.
`JTF_IH_MEDIA_ITEM_LC_SEGS_V`	Used for generating reports for records in table JTF_IH_MEDIA_ITEM_LC_SEGS.
`JTF_IH_NOTES_ACT_VL`	Allows to view JTF notes attached to Activities
`JTF_IH_NOTES_VL`	Allows to view JTF Notes attched to Interactions
`JTF_IH_OUTCOMES_VL`	Translated view for JTF_IH_OUTCOMES_B and JTF_IH_OUTCOMES_TL.
`JTF_IH_OUTCOME_RESULTS_VL`	Translated view for JTF_IH_OUTCOME_RESULTS
`JTF_IH_REASONS_VL`	Translated view for JTF_IH_REASONS_B and JTF_IH_REASONS_TL.
`JTF_IH_RESULTS_VL`	Translated view for JTF_IH_RESULTS_B and JTF_IH_RESULTS_TL.
`JTF_IH_RESULT_REASONS_VL`
`JTF_IH_WRAPUP_OUTCOMES_VL`	View used to drive Outcome LOVs presented in Interaction Wrap-up UIs
`JTF_IH_WRAPUP_REASONS_VL`	View used to drive Reason LOVs presented in Interaction Wrap-up UIs
`JTF_IH_WRAPUP_RESULTS_VL`	View used to drive Result LOVs presented in Interaction Wrap-up UIs
`JTF_IH_WRAP_UPS_VL`
`JTF_IMP_AFFECTEDFILES_VL`
`JTF_IMP_PFILEINFO2_VL`
`JTF_IMP_PFILEINFO_VL`
`JTF_IMP_PISUMMARY2_VL`
`JTF_IMP_PISUMMARY_VL`
`JTF_IMP_PSCOMMON_VL`
`JTF_IMP_PSMASTER2_VL`
`JTF_IMP_PSMASTER_VL`
`JTF_IMP_PSNEW_VL`
`JTF_IMP_SFILEINFO_VL`
`JTF_IMP_SSUMMARY_VL`
`JTF_LOC_AREAS_VL`	View based on JTF_LOC_AREAS_B and JTF_LOC_AREAS_TL.
`JTF_LOC_HIERARCHIES_VL`	View based on JTF_LOC_HIERARCHIES_B table.
`JTF_LOC_TYPES_VL`	View based on JTF_LOC_TYPES_B and JTF_LOC_TYPES_TL.
`JTF_LOOKUPS_AK_ATTRIBUTE_V`
`JTF_LOOKUPS_BRM_WF_V`	View used to select workflow processes in JTFBRWKB form
`JTF_MON_DSTAT`
`JTF_MON_FSTAT`
`JTF_MON_PAGE_LOOKUP`
`JTF_MON_PSTAT`
`JTF_MON_SSTAT`
`JTF_MON_USTAT`
`JTF_MSITES_VL`
`JTF_MSITE_RESPS_VL`
`JTF_NAV_NODE_TYPES_V`	View on the base table.
`JTF_NAV_TABS_VL`	View that combines the base and translation tables based on the user language.
`JTF_NAV_TREE_ROOTS_VL`	View based on the base and translation tables which filters on the user language.
`JTF_NAV_VIEWBYS_VL`	View based on the base and translation tables which filters on the user language.
`JTF_NOTES_SOURCE_TYPE_MAP_V`	View over JTF_OBJECT_MAPPINGS_V
`JTF_NOTES_VL`	MLS view over JTF_NOTES_B and JTF_NOTES_TL. Main view to query up all Notes related to any object.
`JTF_NOTE_CONTEXTS_V`	View over JTF_NOTE_CONTEXTS base table that additionally calculates the note context meaning from the note context type and note context typ
`JTF_NOTE_TYPES_V`	View used to define Note Type object entity sets
`JTF_OBJECTS_VL`	MLS View for JTF_OBJECTS_B and JTF_OBJECTS_TL.
`JTF_OBJECT_MAPPINGS_V`	This view is used to map source object name to object id. And it is used to drop down the list of object id that a user can use.
`JTF_OBJECT_USAGES_V`	This view is used to define the usage of object code.
`JTF_ORG_CONTACTS_V`	JTF_ORG_CONTACTS_V retrieves all Contacts for a party.
`JTF_PARTIES_ALL_V`	Party information of the Caller, Customer and Relationship
`JTF_PARTIES_V`	Party (Organization or Group or Person) and relationship information
`JTF_PARTY_ACCOUNTS_V`	Account and Role information of a Party
`JTF_PARTY_ADDRESSES_V`	JTF_HZ_LOCATIONS_V retreives information about locations. Other entities, such as parties, can reference the locations stored in t
`JTF_PARTY_ALL_CONTACTS_V`	View all contacts, using hz_relationship table as the driving table. The view expose data for subject and object party. Please note that the
`JTF_PARTY_CONTACTS_V`	JTF_PARTY_CONTACTS_V retrieves all contacts for a party.
`JTF_PARTY_CONT_POINTS_V`	JTF_PARTY_CONT_POINTS_V retrieves all contact points for parties without any restriction.
`JTF_PARTY_CUSTOMERS_V`	JTF_PARTY_CUSTOMERS_V displays party information from HZ_PARTIES (and HZ_ORGANIZATION_PROFILES or HZ_PERSON_PROFILES depending on PARTY_TYPE
`JTF_PARTY_LOCATIONS_V`	Address Information of a Party
`JTF_PARTY_PHONES_V`	JTF_PARTY_PHONES_V retrieves all Phone and Fax numbers for a party.
`JTF_PARTY_RELATIONSHIPS_V`	Details on the relationship between parties
`JTF_PC_CATEGORIES_VL`	View that combines the base and translation tables based on the user language.
`JTF_PERZ_DATA_V`	View for personalization data party merge
`JTF_PERZ_QUERY_PARAM_V`	View for personalization data party merge
`JTF_PF_ALL_ACTIVITY_VL`
`JTF_PF_APP_SUMMARY_VL`
`JTF_PF_HOST_SUMMARY_VL`
`JTF_PF_PAGE_SUMMARY_VL`
`JTF_PF_SEQ_VL`
`JTF_PF_SESSION_SUMMARY_VL`
`JTF_PF_USER_SUMMARY_VL`
`JTF_PREFAB_CA_COMPS_VL`	view for ca_comps
`JTF_PREFAB_CA_FILTERS_VL`	view for ca_filters
`JTF_PREFAB_FILTERS_VL`	view for filters
`JTF_PREFAB_POLICIES_VL`	view for policies
`JTF_PREFAB_UD_KEYS_VL`	view for ud_keys
`JTF_PREFAB_WSH_POES_VL`	view for wsh policies
`JTF_QUAL_TYPES`	Same as JTF_QUAL_TYPES_ALL table
`JTF_QUAL_TYPE_DENORM_V`	De-normalized view of JTF_QUAL_TYPES table.
`JTF_QUAL_TYPE_USGS`	Same as JTF_QUAL_TYPE_USGS_ALL table
`JTF_QUAL_USGS`	Same as JTF_QUAL_USGS_ALL table
`JTF_RS_ACTIVE_RESOURCES_VL`	This view stores active resources as of sysdate
`JTF_RS_ALL_RESOURCES_VL`	This view shows all resource including team,groups and individual resource.
`JTF_RS_CCT_MIDDLEWARES_V`	Validates Call Center Parameters (Replaces CCT_MIDDLEWARES_V)
`JTF_RS_COMPONENTS_V`	Stores all valid components that skills can be assigned to.
`JTF_RS_DBI_RES_GRP_VL`
`JTF_RS_DBI_UNSEC_GRPS_V`
`JTF_RS_DEFRESGROUPS_VL`	This view is used by Define Resource Form Group Tab
`JTF_RS_DEFRESOURCES_V`
`JTF_RS_DEFRESOURCES_VL`
`JTF_RS_DEFRESROLES_VL`	This view is used by Define Resource Form roles,gmbr_roles,tmbr_roles block
`JTF_RS_DEFRESTEAMS_VL`	This view is used by Define Resource FormTeams block
`JTF_RS_DYNAMIC_GROUPS_VL`	MLS View for JTF_RS_DYNAMIC_GROUPS_B and JTF_RS_DYNAMIC_GROUPS_TL.
`JTF_RS_EMAIL_ACCOUNTS_V`	Validates Email Center Parameters (Replaces IEM_EMAIL_ACCOUNTS_V)
`JTF_RS_EMPLOYEES_VL`	This view has the list of all Employees that can be importedor is already present in Resource Manager
`JTF_RS_EMP_ADDRESS_VL`	This view has employee address.
`JTF_RS_EMP_DTLS_VL`	This view has the details of all the resources whose category='EMPLOYEE'
`JTF_RS_GROUPS_AUD_VL`	MLS View forJTF_RS_GROUPS_AUD_B andJTF_RS_GROUPS_AUD_TL.
`JTF_RS_GROUPS_VL`	MLS View forJTF_RS_GROUPS_B and JTF_RS_GROUPS_TL.
`JTF_RS_GROUP_DTLS_VL`	This view has the groups details including name and manager
`JTF_RS_GROUP_MBR_ROLE_VL`	This view is used in define group form member_roles block.
`JTF_RS_GROUP_MEMBERS_VL`	This view is used in define group form members block.
`JTF_RS_GROUP_USAGES_VL`	This view is used in define group form usages block.
`JTF_RS_GRP_DENORM_VL`	This view has the denorm records for all groups
`JTF_RS_GRP_HIER_MEM_V`	This view is used for defining the Meta data for the 'Members' spreadtable in Group Hierarchy Form.
`JTF_RS_GRP_HIER_V`	This view is used for defining the Meta data for the 'Groups' spreadtable in Group Hierarchy Form.
`JTF_RS_GRP_RELATIONS_VL`	This view is used in define group form relations block.
`JTF_RS_ITEM_CATEGORIES_V`	Stores all valid item categories for which resource skills can be assigned.
`JTF_RS_JOB_ROLES_VL`	This view is used in define role setup form jobs block.
`JTF_RS_OTHER_DTLS_VL`	This view has the details of all the resources whose category='OTHER'
`JTF_RS_PARTIES_VL`	The details of parties that can be imported as resource or are already present as resource
`JTF_RS_PARTNERS_VL`	The details of parners that can be imported as resource or are already present as resource
`JTF_RS_PARTNER_DTLS_VL`	This view has the details of all the resources whose category='PARTNER'
`JTF_RS_PARTY_CONTACTS_VL`	The list of party contacts
`JTF_RS_PARTY_DTLS_VL`	This view has the details of all the resources whose category='PARTY'
`JTF_RS_PLATFORMS_V`	Stores all valid platforms for which resource skills can be assigned.
`JTF_RS_PROBLEM_CODES_V`	Stores all valid problem codes for which resource skills can be assigned.
`JTF_RS_PRODUCTS_V`	Stores all valid products for which resource skills can be assigned.
`JTF_RS_PTNR_MIGR_VL`	Stores specific partner related data used for internal migration.
`JTF_RS_REP_MANAGERS_VL`	This view shows the member to manager and admin hierarchy across groups
`JTF_RS_RESOURCES_VL`	This view shows all resource including team,groups and individual resource.
`JTF_RS_RESOURCE_DTLS_VL`	This view is for the details (eg name , phone, email) for the resources
`JTF_RS_RESOURCE_EXTNS_VL`	Main resource view that stores all resource data.
`JTF_RS_RESOURCE_VALUES_VL`	This view lists the configuration name,parameter name and value for a resource and parameter
`JTF_RS_RES_EMP_VL`	This view shows a few attributes of a Resource of type Employee
`JTF_RS_ROLES_VL`	MLS View forJTF_RS_ROLES_B and JTF_RS_ROLES_TL.
`JTF_RS_ROLE_DETAILS_VL`	This View shows Roles and its details like Role type, Role name, etc.
`JTF_RS_ROLE_RELATIONS_VL`	This view shows the listing of details of roles attached to resource.
`JTF_RS_SALESREPS_MO_V`	This view stores information about salesreps for a particular organization.
`JTF_RS_SKILL_LEVELS_VL`	Stores various different skills, levels for use in resource skills bank.
`JTF_RS_SRP_GROUPS_V`	View for fetching the Default (Primary) group for a Salesrep.
`JTF_RS_SRP_TERRITORIES_V`	View that points to RA_SALESREP_TERRITORIES
`JTF_RS_SRP_VL`	This view is used by Define Resource Form AR block
`JTF_RS_SUPPLIERS_VL`	The details of supplier contacts that can be imported as resource or are already present as resource
`JTF_RS_SUPPLIER_DTLS_VL`	This view has the details of all the resources whose category='SUPPLIER_CONTACT'
`JTF_RS_TABLE_ATTRIBUTES_VL`	MLS View forJTF_RS_TABLE_ATTRIBUTES_B and JTF_RS_TABLE_ATTRIBUTES_TL.
`JTF_RS_TEAMS_VL`	MLS View forJTF_RS_TEAMS_B and JTF_RS_TEAMS_TL.
`JTF_RS_TEAM_MEMBERS_VL`	This view is used in define Team form members block.
`JTF_RS_TEAM_USAGES_VL`	This view is used in define Team form usages block.
`JTF_RS_VENUE_DTLS_VL`	This view has the details of all the resources whose category='VENUE'
`JTF_RS_WEB_AVAILABLE_V`	Stores information about a resources' web availability.
`JTF_R_RULESETS_V`	view for ruleset
`JTF_R_RULESETS_VL`	RuleSet language specific view
`JTF_R_RULES_V`	view for rules
`JTF_R_RULES_VL`	Provide Rule langauge specific information
`JTF_SEEDED_QUAL_ALL_VL`	Multi-Org single language view of seeded qualifiers.
`JTF_SEEDED_QUAL_USGS_V`	View for territories qualifier form. Summary of qualifier definitions and whether they are enabled or disabled for territory use.
`JTF_SEEDED_QUAL_VL`	Single-languagel,single-org view for displaying the seeded qualifier in Territories
`JTF_SOURCES`	Same as JTF_SOURCES_ALL table
`JTF_STATE_RESPONSIBILITIES_V`	Internal View for JTF_STATE_RESPONSIBILITIES and FND_RESPONSIBILITY
`JTF_STATE_RULES_VL`	MLS View for JTF_STATE_RULES_B and JTF_STATE_RULES_TL.
`JTF_STATE_TRANSITIONS_V`	Public State Transitions View
`JTF_STORES_VL`
`JTF_SUSPENSION_ACTIVITY_V`	JTF_SUSPENSION_ACTIVITY_V retreives information about the point in time that service is no longer provided to a customer account or cust
`JTF_TASKS_V`	Common View with all the task attributes.
`JTF_TASKS_VL`	MLS View for JTF_TASKS_B and JTF_TASKS_TL
`JTF_TASK_ALL_ASSIGNMENTS_V`	This view is used to get all the assignments where the ASSIGNEE_ROLE is OWNER or ASSIGNEE.
`JTF_TASK_ALL_STATUSES_VL`	MLS View for JTF_TASK_STATUSES_B and JTF_TASK_STATUSES_TL. ( shows task and escalation statuses )
`JTF_TASK_ASSIGNMENTS_V`	This view is used to get all the assignments where the ASSIGNEE_ROLE is ASSIGNEE.
`JTF_TASK_AUDITS_VL`	MLS View for JTF_TASK_AUDITS_B and JTF_TASK_AUDITS_TL.
`JTF_TASK_CONTACTS_V`	Internal View over JTF_TASK_CONTACTS
`JTF_TASK_DATES_V`	This view is used to get the actual date values for a given task
`JTF_TASK_DATE_TYPES_VL`	MLS View for JTF_TASK_DATE_TYPES_B and JTF_TASK_DATE_TYPES_TL.
`JTF_TASK_DEPENDS_V`	Internal View between Dependency Table and JTF_TASKS_B
`JTF_TASK_PARTY_CONTACTS_V`	View all contacts, using hz_relationship table as the driving table. The view expose data for subject and object party. Please note that the
`JTF_TASK_PHONES_V`	Internal View for JTF_TASK_PHONES
`JTF_TASK_PRIORITIES_VL`	MLS View for JTF_TASK_PRIORITIES_B and JTF_TASK_PRIORITIES_TL.
`JTF_TASK_REFERENCES_VL`	MLS View for JTF_TASK_REFERENCES_B and JTF_TASK_REFERENCES_TL.
`JTF_TASK_RESOURCES_VL`
`JTF_TASK_SECURITY_V`	This view is used to get the group or team resources granting full access to a login resource and group/team or employee resources granting
`JTF_TASK_STATUSES_VL`	MLS View for JTF_TASK_STATUSES_B and JTF_TASK_STATUSES_TL.
`JTF_TASK_TEMPLATES_VL`	MLS View for JTF_TASK_TEMPLATES_B and JTF_TASK_TEMPLATES_TL.
`JTF_TASK_TEMP_DEPENDS_V`	Internal View for JTF_TASK_TEMPLATES and JTF_TASKS_B
`JTF_TASK_TEMP_GROUPS_VL`	MLS View for JTF_TASK_TEMP_GROUPS_B and JTF_TASK_TEMP_GROUPS_TL.
`JTF_TASK_TERRITORY_V`	Internal View used by the Assignment Manager
`JTF_TASK_TYPES_VL`	MLS View for JTF_TASK_TYPES_B and JTF_TASK_TYPES_TL.
`JTF_TASK_UWQ_ALL_REF_V`	This view is used to get all the open tasks and assignments except that source object type is appointment or task type is escalation.
`JTF_TASK_UWQ_ALL_V`	This view is used to get all the tasks which has an open assignments
`JTF_TASK_UWQ_MYOWN_V`	Internal view used by the UWQ
`JTF_TASK_UWQ_V`	This view is used to get all the open tasks, assignments except that source object type is appointment or task type is escalation.
`JTF_TERR`	Territories (multi-org)
`JTF_TERRITORIES_NAV`	View for UI Navigator - view by Territories - Defines navigator tree structure for territory parent to child hierarchy.
`JTF_TERR_COLUMNS_V`	Shows a list of column associated with a table. This is used for defining user defined qualifiers
`JTF_TERR_DENORM_RULES`	Denormalized Territory view for performance purposes
`JTF_TERR_ESCALATIONS_NAV`	View for UI Navigator - view by Escalations - Defines navigator tree structure for territory escalations escalating hierarchy.
`JTF_TERR_INHERITED_QUAL_V`	This view is used to show the qualifiers that a territory inherits from the territories above it in the territory hierarchy (if a hierarchy
`JTF_TERR_OVERVIEW_V`	This view shows the header information for a territory.
`JTF_TERR_QLFY_RSC_DST_V`	This views stores all the active resources , groups and teams.
`JTF_TERR_QLFY_RSC_V`	This view stores all the informations about resources, groups and teams .
`JTF_TERR_QTYPE_USGS`	Same as JTF_TERR_QTYPE_USGS_ALL table.
`JTF_TERR_QUAL`	Same as JTF_TERR_QUAL_ALL table.
`JTF_TERR_QUALIFIERS_V`	This shows the qualifiers used to define a territory.
`JTF_TERR_RESOURCES_V`	This view stores all the informations of the resources assigned to territories .
`JTF_TERR_RSC`	Same as JTF_TERR_RSC_ALL table
`JTF_TERR_RSC_ACCESS`	Same as JTF_TERR_RSC_ALL table
`JTF_TERR_RSC_ACCESS_V`	This shows the access types that a resource has to a territory.
`JTF_TERR_RSC_LANG_V`	This shows a resource's language(s).
`JTF_TERR_SRCH_ADV_ESCL_V`	View for advanced escalation territory search
`JTF_TERR_SRCH_ADV_GEN_V`
`JTF_TERR_SRCH_ADV_MAIN_V`	View for advanced territory search
`JTF_TERR_SRCH_ADV_TEMP_V`	View for advanced template territory search
`JTF_TERR_SRCH_ADV_TYPE_V`	View for advanced territory type search
`JTF_TERR_SRCH_ESCL_V`	View for basic escalation territory search
`JTF_TERR_SRCH_MAIN_V`	View for basic territory search
`JTF_TERR_SRCH_TEMP_V`	View for template territory search
`JTF_TERR_SRCH_TYPE_V`	View for territory type search
`JTF_TERR_TABLES_V`	Shows a list of tables for use in defining user defined qualifers.
`JTF_TERR_TEMPLATES_NAV`	View for UI Navigator - view by Templates - Defines navigator tree structure for territory template to created territory hierarchy.
`JTF_TERR_TRANSACTIONS_V`	This view shows the transactions that are assigned to a territory.
`JTF_TERR_TRANS_DENORM_V`	This shows the denormalised territory transactions horizontally.
`JTF_TERR_TYPES`	Territory types (multi-org)
`JTF_TERR_TYPES_NAV`	View for UI Navigator - view by Territory Types - Defines navigator tree structure for type to territory hierarchy.
`JTF_TERR_TYPES_V`	Shows Territory Type usage by joining the JTF_TERR_TYPE_USGS table
`JTF_TERR_TYPE_QUAL`	Same as JTF_TERR_TYPE_QUAL_ALL table
`JTF_TERR_TYPE_QUALIFIERS_V`	Shows Territory Type's qualifer type usage and the qualifer details.
`JTF_TERR_TYPE_QUAL_V`	Shows Territory Type's qualifer and qualifer type usage description
`JTF_TERR_TYPE_USGS`	Same as JTF_TERR_TYPE_USGS_ALL table
`JTF_TERR_T_TRANS_DENORM_V`	This shows the denormalised territory type transactions horizontally.
`JTF_TERR_USGS`	Same as JTF_TERR_USGS_ALL table
`JTF_TERR_V`
`JTF_TERR_VALUES`	Same as JTF_TERR_VALUES_ALL.
`JTF_TERR_VALUES_DESC_V`
`JTF_TERR_WINNERS_V`
`JTF_TR_ALL_RESOURCES_V`	This view stores all the resources
`JTF_TR_SOURCE_DENORM_V`	Territories Denormalized Source View
`JTF_TTY_ALL_RESOURCES_V`	View for all resources
`JTF_TTY_GEO_TERR_OWNER_LOV_V`	View for owners of Geography Territories
`JTF_TTY_MY_DIRECTS_V`	Shows all the direct reports of a salesperson
`JTF_TTY_MY_RESOURCES_V`	Shows all the direct and indirect reports of a salesperson
`JTF_TTY_SRCH_MY_RESOURCES_V`	Shows all the direct and indirect reports of a salesperson
`JTF_TTY_WEBADI_TERR_GRP_V`	This view is used for Territory Group LOV for Excel
`JTF_TYPE_QTYPE_USGS`	Same as JTF_TYPE_QTYPE_USGS_ALL table
`JTF_TYPE_QTYPE_USGS_V`	Shows Territory Type's qualifer type usage description
`JTF_TYPE_TRANSACTIONS_V`	Shows the transaction types ( Qualifier types) associated with a Territory Type
`JTF_UM_APPROVALS_VL`	MLS view for JTF_UM_APPROVALS_B and JTF_UM_APPROVALS_TL
`JTF_UM_SUBSCRIPTIONS_VL`	MLS view for JTF_UM_SUBSCRIPTIONS_B and JTF_UM_SUBSCRIPTIONS_TL
`JTF_UM_TEMPLATES_VL`	MLS view for JTF_UM_TEMPLATES_B and JTF_UM_TEMPLATES_TL
`JTF_UM_USERTYPES_VL`	MLS view for JTF_UM_USERTYPES_B and JTF_UM_USERTYPES_TL
`JTF_USER_CUSTOM_GRIDS`	All the spreadtable customizations that the current end user can access.
`JTF_XML_INVOCATIONS_VL`	View that stores event info
`JTF_XML_INV_SERVICES_VL`	View that stores invocation info
`JTF_XML_SERVICES_VL`	View that stores services info.
`JTF_XML_SVC_GROUPS_VL`	View that stores service group info.
`JTY_ALL_ENABLED_ATTRIBUTES_V`	All Enabled Attributes View
`JTY_ESCALATION_TERRITORIES_V`	Escalation Territories
`JTY_WEBADI_OTH_TERR_V`