Search Results jtf_objects_b




Overview
Explore in AI Chat

Overview

The JTF_OBJECTS_B table is a core metadata repository within the Oracle E-Business Suite CRM Foundation (JTF). It functions as a central registry for defining and storing details of application objects or modules across the system. Its primary role is to provide a standardized reference for various CRM and related components, enabling object-level integration, validation, and relationship mapping. The table is fundamental to the architecture of CRM, as evidenced by its extensive foreign key relationships with tables across Service (CS), Sales (IEU), Interaction Center (IEU), Contracts (OKS), and other product families. It provides the underlying structure for managing object-specific behaviors, such as note attachment sources, work item definitions, and service request linking rules.

Key Information Stored

The table's structure centers on a unique object identifier. While the full column list is not detailed in the provided metadata, the primary and foreign key relationships reveal its critical data points. The OBJECT_CODE column serves as the primary key (JTF_OBJECTS_B_PK) and is the unique identifier for a registered object. The APPLICATION_ID column is a foreign key to FND_APPLICATION, linking each object to its parent EBS application module. Although not listed, typical columns in such a metadata table would include OBJECT_NAME, DESCRIPTION, and various WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE). The data stored defines the universe of objects that can participate in CRM-centric processes.

Common Use Cases and Queries

A primary use case is resolving object codes to human-readable names for reports or integrations. For instance, when analyzing notes from JTF_NOTES_B, a query would join on SOURCE_OBJECT_CODE to get the object's name. The table is also crucial for validating object types in custom extensions or when configuring object-specific rules. A common query pattern is to list all registered objects for a specific application or module. Given the user's search for "oks_rules_dff," a relevant scenario might involve querying JTF_OBJECTS_B to identify the object code associated with OKS rules, which could then be used to query descriptive flexfield (DFF) metadata tables.

-- Example: Resolve object codes for notes
SELECT n.NOTE_ID, n.SOURCE_OBJECT_CODE, o.OBJECT_NAME
FROM JTF_NOTES_B n, JTF_OBJECTS_B o
WHERE n.SOURCE_OBJECT_CODE = o.OBJECT_CODE;

-- Example: Find objects related to the OKS module
SELECT OBJECT_CODE, OBJECT_NAME
FROM JTF_OBJECTS_B
WHERE APPLICATION_ID = (SELECT APPLICATION_ID FROM FND_APPLICATION WHERE APPLICATION_SHORT_NAME = 'OKS');

Related Objects

As per the metadata, JTF_OBJECTS_B has a vast network of dependencies, underscoring its central role. Key related objects include:

  • FND_APPLICATION: Parent table providing the application context.
  • JTF_NOTES_B: References SOURCE_OBJECT_CODE to identify the entity a note is attached to.
  • OKS_K_ORDER_CONTACTS, OKL_CRITERIA_B: Used in Contracts (OKS) and Lease Management (OKL) for object association.
  • CS_INCIDENT_LINKS, CS_SR_LINK_VALID_OBJ: Core Service (CS) tables using it to define valid subject and object types for service request linking.
  • IEU_MSG_MESSAGES, IEU_UWQM_ITEMS: Interaction Center tables referencing work item object codes.
  • JTF_IH_ACTIVITIES: References the object code for document associations in interaction history.

This extensive referencing makes JTF_OBJECTS_B a critical point of integration for any customization or data analysis involving CRM object relationships.

  • Table: JTF_OBJECTS_B 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_OBJECTS_B,  object_name:JTF_OBJECTS_B,  status:VALID,  product: JTF - CRM Foundation ,  description: This table stores the details of objects(modules). ,  implementation_dba_data: JTF.JTF_OBJECTS_B , 

  • Table: JTF_OBJECTS_B 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_OBJECTS_B,  object_name:JTF_OBJECTS_B,  status:VALID,  product: JTF - CRM Foundation ,  description: This table stores the details of objects(modules). ,  implementation_dba_data: JTF.JTF_OBJECTS_B , 

  • Table: JTF_OBJECTS_TL 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_OBJECTS_TL,  object_name:JTF_OBJECTS_TL,  status:VALID,  product: JTF - CRM Foundation ,  description: Translation Table for JTF_OBJECTS_B ,  implementation_dba_data: JTF.JTF_OBJECTS_TL , 

  • Table: JTF_OBJECTS_TL 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_OBJECTS_TL,  object_name:JTF_OBJECTS_TL,  status:VALID,  product: JTF - CRM Foundation ,  description: Translation Table for JTF_OBJECTS_B ,  implementation_dba_data: JTF.JTF_OBJECTS_TL , 

  • Table: JTF_STATE_RULES_B 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_STATE_RULES_B,  object_name:JTF_STATE_RULES_B,  status:VALID,  product: JTF - CRM Foundation ,  description: Base table which stores rule definitions ,  implementation_dba_data: JTF.JTF_STATE_RULES_B , 

  • Table: JTF_STATE_RULES_B 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_STATE_RULES_B,  object_name:JTF_STATE_RULES_B,  status:VALID,  product: JTF - CRM Foundation ,  description: Base table which stores rule definitions ,  implementation_dba_data: JTF.JTF_STATE_RULES_B , 

  • View: JTF_OBJECTS_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_OBJECTS_VL,  object_name:JTF_OBJECTS_VL,  status:VALID,  product: JTF - CRM Foundation ,  description: MLS View for JTF_OBJECTS_B and JTF_OBJECTS_TL. ,  implementation_dba_data: APPS.JTF_OBJECTS_VL , 

  • View: JTF_OBJECTS_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_OBJECTS_VL,  object_name:JTF_OBJECTS_VL,  status:VALID,  product: JTF - CRM Foundation ,  description: MLS View for JTF_OBJECTS_B and JTF_OBJECTS_TL. ,  implementation_dba_data: APPS.JTF_OBJECTS_VL , 

  • Table: JTF_TASKS_B 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_TASKS_B,  object_name:JTF_TASKS_B,  status:VALID,  product: JTF - CRM Foundation ,  description: Base Table JTF_TASKS_B stores general information about a given Task. ,  implementation_dba_data: JTF.JTF_TASKS_B , 

  • Table: JTF_TASKS_B 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_TASKS_B,  object_name:JTF_TASKS_B,  status:VALID,  product: JTF - CRM Foundation ,  description: Base Table JTF_TASKS_B stores general information about a given Task. ,  implementation_dba_data: JTF.JTF_TASKS_B , 

  • Table: JTF_NOTES_SOURCE_TYPE_MAP 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_NOTES_SOURCE_TYPE_MAP,  object_name:JTF_NOTES_SOURCE_TYPE_MAP,  status:VALID,  product: JTF - CRM Foundation ,  description: JTF_NOTES_SOURCE_TYPE_MAP is the base table for defining application/object specific note types. ,  implementation_dba_data: JTF.JTF_NOTES_SOURCE_TYPE_MAP , 

  • Table: JTF_TASK_REFERENCES_B 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_TASK_REFERENCES_B,  object_name:JTF_TASK_REFERENCES_B,  status:VALID,  product: JTF - CRM Foundation ,  description: JTF_TASK_REFERENCES stores the reference details for a given task. ,  implementation_dba_data: JTF.JTF_TASK_REFERENCES_B , 

  • Table: JTF_OBJECT_USAGES 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_OBJECT_USAGES,  object_name:JTF_OBJECT_USAGES,  status:VALID,  product: JTF - CRM Foundation ,  description: Intersection Table between JTF_OBJECTS and Objects User. The point of the table is to allow other applications to hook to the OBJECT USAGES. ,  implementation_dba_data: JTF.JTF_OBJECT_USAGES , 

  • Table: JTF_TASK_ASSIGNMENTS 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_TASK_ASSIGNMENTS,  object_name:JTF_TASK_ASSIGNMENTS,  status:VALID,  product: JTF - CRM Foundation ,  description: JTF_TASK_ASSIGNMENTS stores information about the resource assignments associated with the task. ,  implementation_dba_data: JTF.JTF_TASK_ASSIGNMENTS , 

  • Table: JTF_TASK_REFERENCES_B 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_TASK_REFERENCES_B,  object_name:JTF_TASK_REFERENCES_B,  status:VALID,  product: JTF - CRM Foundation ,  description: JTF_TASK_REFERENCES stores the reference details for a given task. ,  implementation_dba_data: JTF.JTF_TASK_REFERENCES_B , 

  • Table: JTF_NOTES_SOURCE_TYPE_MAP 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_NOTES_SOURCE_TYPE_MAP,  object_name:JTF_NOTES_SOURCE_TYPE_MAP,  status:VALID,  product: JTF - CRM Foundation ,  description: JTF_NOTES_SOURCE_TYPE_MAP is the base table for defining application/object specific note types. ,  implementation_dba_data: JTF.JTF_NOTES_SOURCE_TYPE_MAP , 

  • Table: JTF_NOTE_CONTEXTS 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_NOTE_CONTEXTS,  object_name:JTF_NOTE_CONTEXTS,  status:VALID,  product: JTF - CRM Foundation ,  description: Base table for Contexts to Notes, which are references to other objects. ,  implementation_dba_data: JTF.JTF_NOTE_CONTEXTS , 

  • Table: JTF_NOTE_CONTEXTS 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_NOTE_CONTEXTS,  object_name:JTF_NOTE_CONTEXTS,  status:VALID,  product: JTF - CRM Foundation ,  description: Base table for Contexts to Notes, which are references to other objects. ,  implementation_dba_data: JTF.JTF_NOTE_CONTEXTS , 

  • Table: JTF_OBJECT_MAPPINGS 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_OBJECT_MAPPINGS,  object_name:JTF_OBJECT_MAPPINGS,  status:VALID,  product: JTF - CRM Foundation ,  description: Mapping Table between Source and Object Types eg Task Types,Note Types . The point of the table is to allow applications to define mappings to the source for a particular object type. ,  implementation_dba_data: JTF.JTF_OBJECT_MAPPINGS , 

  • Table: JTF_TASK_TEMP_GROUPS_B 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_TASK_TEMP_GROUPS_B,  object_name:JTF_TASK_TEMP_GROUPS_B,  status:VALID,  product: JTF - CRM Foundation ,  description: JTF_TASK_TEMPLATES_B stores all task template groups. ,  implementation_dba_data: JTF.JTF_TASK_TEMP_GROUPS_B , 

  • Table: JTF_OBJECT_USAGES 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_OBJECT_USAGES,  object_name:JTF_OBJECT_USAGES,  status:VALID,  product: JTF - CRM Foundation ,  description: Intersection Table between JTF_OBJECTS and Objects User. The point of the table is to allow other applications to hook to the OBJECT USAGES. ,  implementation_dba_data: JTF.JTF_OBJECT_USAGES , 

  • Table: JTF_TASK_ASSIGNMENTS 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_TASK_ASSIGNMENTS,  object_name:JTF_TASK_ASSIGNMENTS,  status:VALID,  product: JTF - CRM Foundation ,  description: JTF_TASK_ASSIGNMENTS stores information about the resource assignments associated with the task. ,  implementation_dba_data: JTF.JTF_TASK_ASSIGNMENTS , 

  • Table: JTF_TASK_RSC_REQS 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_TASK_RSC_REQS,  object_name:JTF_TASK_RSC_REQS,  status:VALID,  product: JTF - CRM Foundation ,  description: JTF_TASK_RSC_REQS contains the resource requirements for a task. ,  implementation_dba_data: JTF.JTF_TASK_RSC_REQS , 

  • Table: JTF_CAL_RESOURCE_ASSIGN 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_CAL_RESOURCE_ASSIGN,  object_name:JTF_CAL_RESOURCE_ASSIGN,  status:VALID,  product: JTF - CRM Foundation ,  description: Assign Resources to a Calendar. ,  implementation_dba_data: JTF.JTF_CAL_RESOURCE_ASSIGN , 

  • Table: JTF_NOTES_B 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_NOTES_B,  object_name:JTF_NOTES_B,  status:VALID,  product: JTF - CRM Foundation ,  description: Non-translated base table for Notes module. ,  implementation_dba_data: JTF.JTF_NOTES_B , 

  • Table: JTF_TASK_RSC_REQS 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_TASK_RSC_REQS,  object_name:JTF_TASK_RSC_REQS,  status:VALID,  product: JTF - CRM Foundation ,  description: JTF_TASK_RSC_REQS contains the resource requirements for a task. ,  implementation_dba_data: JTF.JTF_TASK_RSC_REQS , 

  • Table: JTF_CAL_RESOURCE_ASSIGN 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_CAL_RESOURCE_ASSIGN,  object_name:JTF_CAL_RESOURCE_ASSIGN,  status:VALID,  product: JTF - CRM Foundation ,  description: Assign Resources to a Calendar. ,  implementation_dba_data: JTF.JTF_CAL_RESOURCE_ASSIGN , 

  • Table: JTF_NOTES_B 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_NOTES_B,  object_name:JTF_NOTES_B,  status:VALID,  product: JTF - CRM Foundation ,  description: Non-translated base table for Notes module. ,  implementation_dba_data: JTF.JTF_NOTES_B , 

  • Table: JTF_OBJECT_MAPPINGS 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_OBJECT_MAPPINGS,  object_name:JTF_OBJECT_MAPPINGS,  status:VALID,  product: JTF - CRM Foundation ,  description: Mapping Table between Source and Object Types eg Task Types,Note Types . The point of the table is to allow applications to define mappings to the source for a particular object type. ,  implementation_dba_data: JTF.JTF_OBJECT_MAPPINGS , 

  • Table: JTF_RS_ROLE_RELATIONS 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_RS_ROLE_RELATIONS,  object_name:JTF_RS_ROLE_RELATIONS,  status:VALID,  product: JTF - CRM Foundation ,  description: This table stores the association between resources and roles. Primary key is Resource_id and Role_id. Each resource can be assigned to multiple roles. ,  implementation_dba_data: JTF.JTF_RS_ROLE_RELATIONS , 

  • Table: JTF_TASK_TEMP_GROUPS_B 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_TASK_TEMP_GROUPS_B,  object_name:JTF_TASK_TEMP_GROUPS_B,  status:VALID,  product: JTF - CRM Foundation ,  description: JTF_TASK_TEMPLATES_B stores all task template groups. ,  implementation_dba_data: JTF.JTF_TASK_TEMP_GROUPS_B , 

  • Table: JTF_GRID_COLS_B 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_GRID_COLS_B,  object_name:JTF_GRID_COLS_B,  status:VALID,  product: JTF - CRM Foundation ,  description: Meta Data information for each column defined for a spreadtable UI component. ,  implementation_dba_data: JTF.JTF_GRID_COLS_B , 

  • Table: JTF_RS_ROLE_RELATIONS 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_RS_ROLE_RELATIONS,  object_name:JTF_RS_ROLE_RELATIONS,  status:VALID,  product: JTF - CRM Foundation ,  description: This table stores the association between resources and roles. Primary key is Resource_id and Role_id. Each resource can be assigned to multiple roles. ,  implementation_dba_data: JTF.JTF_RS_ROLE_RELATIONS , 

  • Table: JTF_GRID_COLS_B 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_GRID_COLS_B,  object_name:JTF_GRID_COLS_B,  status:VALID,  product: JTF - CRM Foundation ,  description: Meta Data information for each column defined for a spreadtable UI component. ,  implementation_dba_data: JTF.JTF_GRID_COLS_B , 

  • Table: JTF_IH_ACTIVITIES 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_IH_ACTIVITIES,  object_name:JTF_IH_ACTIVITIES,  status:VALID,  product: JTF - CRM Foundation ,  description: An act performed by a human or automated agent as part of an Interaction. An Interaction Activity can be related to the handling of the Media Items related to the Interaction (example: answering a call, transferring a call, etc.) . An Int ,  implementation_dba_data: JTF.JTF_IH_ACTIVITIES , 

  • Table: JTF_IH_ACTIVITIES 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_IH_ACTIVITIES,  object_name:JTF_IH_ACTIVITIES,  status:VALID,  product: JTF - CRM Foundation ,  description: An act performed by a human or automated agent as part of an Interaction. An Interaction Activity can be related to the handling of the Media Items related to the Interaction (example: answering a call, transferring a call, etc.) . An Int ,  implementation_dba_data: JTF.JTF_IH_ACTIVITIES , 

  • View: JTF_ESC_UWQ_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_ESC_UWQ_V,  object_name:JTF_ESC_UWQ_V,  status:VALID,  product: JTF - CRM Foundation ,  description: This view contains escalation details to be displayed in Universal Work Queue. ,  implementation_dba_data: APPS.JTF_ESC_UWQ_V , 

  • View: JTF_ESC_UWQ_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_ESC_UWQ_V,  object_name:JTF_ESC_UWQ_V,  status:VALID,  product: JTF - CRM Foundation ,  description: This view contains escalation details to be displayed in Universal Work Queue. ,  implementation_dba_data: APPS.JTF_ESC_UWQ_V , 

  • View: JTF_TASK_UWQ_MYOWN_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_TASK_UWQ_MYOWN_V,  object_name:JTF_TASK_UWQ_MYOWN_V,  status:VALID,  product: JTF - CRM Foundation ,  description: Internal view used by the UWQ ,  implementation_dba_data: APPS.JTF_TASK_UWQ_MYOWN_V , 

  • View: JTF_NOTES_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_NOTES_VL,  object_name:JTF_NOTES_VL,  status:VALID,  product: JTF - CRM Foundation ,  description: MLS view over JTF_NOTES_B and JTF_NOTES_TL. Main view to query up all Notes related to any object. ,  implementation_dba_data: APPS.JTF_NOTES_VL , 

  • View: JTF_TASK_UWQ_MYOWN_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_TASK_UWQ_MYOWN_V,  object_name:JTF_TASK_UWQ_MYOWN_V,  status:VALID,  product: JTF - CRM Foundation ,  description: Internal view used by the UWQ ,  implementation_dba_data: APPS.JTF_TASK_UWQ_MYOWN_V , 

  • View: JTF_NOTES_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_NOTES_VL,  object_name:JTF_NOTES_VL,  status:VALID,  product: JTF - CRM Foundation ,  description: MLS view over JTF_NOTES_B and JTF_NOTES_TL. Main view to query up all Notes related to any object. ,  implementation_dba_data: APPS.JTF_NOTES_VL , 

  • View: JTF_TASK_UWQ_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_TASK_UWQ_V,  object_name:JTF_TASK_UWQ_V,  status:VALID,  product: JTF - CRM Foundation ,  description: This view is used to get all the open tasks, assignments except that source object type is appointment or task type is escalation. ,  implementation_dba_data: APPS.JTF_TASK_UWQ_V , 

  • View: JTF_TASK_UWQ_ALL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_TASK_UWQ_ALL_V,  object_name:JTF_TASK_UWQ_ALL_V,  status:VALID,  product: JTF - CRM Foundation ,  description: This view is used to get all the tasks which has an open assignments ,  implementation_dba_data: APPS.JTF_TASK_UWQ_ALL_V , 

  • View: JTF_TASK_UWQ_ALL_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_TASK_UWQ_ALL_V,  object_name:JTF_TASK_UWQ_ALL_V,  status:VALID,  product: JTF - CRM Foundation ,  description: This view is used to get all the tasks which has an open assignments ,  implementation_dba_data: APPS.JTF_TASK_UWQ_ALL_V , 

  • View: JTF_TASK_UWQ_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_TASK_UWQ_V,  object_name:JTF_TASK_UWQ_V,  status:VALID,  product: JTF - CRM Foundation ,  description: This view is used to get all the open tasks, assignments except that source object type is appointment or task type is escalation. ,  implementation_dba_data: APPS.JTF_TASK_UWQ_V , 

  • View: JTF_IH_ACTIVITIES_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_IH_ACTIVITIES_VL,  object_name:JTF_IH_ACTIVITIES_VL,  status:VALID,  product: JTF - CRM Foundation ,  description: Interaction History Activities View ,  implementation_dba_data: APPS.JTF_IH_ACTIVITIES_VL , 

  • View: JTF_IH_ACTIVITIES_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_IH_ACTIVITIES_VL,  object_name:JTF_IH_ACTIVITIES_VL,  status:VALID,  product: JTF - CRM Foundation ,  description: Interaction History Activities View ,  implementation_dba_data: APPS.JTF_IH_ACTIVITIES_VL , 

  • View: JTF_IH_ACTIVITIES_VL3 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_IH_ACTIVITIES_VL3,  object_name:JTF_IH_ACTIVITIES_VL3,  status:VALID,  product: JTF - CRM Foundation ,  description: Interaction History Activities View ,  implementation_dba_data: APPS.JTF_IH_ACTIVITIES_VL3 , 

  • Table: JTF_RS_RESOURCE_EXTNS 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_RS_RESOURCE_EXTNS,  object_name:JTF_RS_RESOURCE_EXTNS,  status:VALID,  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 ,