JTF — CRM Foundation
552 documented tables · 364 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
JTF_RS_RESOURCE_EXTNS |
This is table stores all important information about Resources. These Resources are coming from HR or HZ or Vo | hub |
JTF_OBJECTS_B |
This table stores the details of objects(modules). | hub |
JTF_TERR_ALL |
Stores the definition of the territories. There are 3 categories of territories, Standard, Escalation and Temp | hub |
JTF_RS_GROUPS_B |
Base Table JTF_RS_GROUPS_B stores general information about a given Group. | hub-leaning |
JTF_AMV_ITEMS_B |
Store document. | hub |
JTF_TERR_TYPES_ALL |
Stores the territory type definition. It holds the information about the types of territories defined for your | hub-leaning |
JTF_PERZ_PROFILE |
JTF_PERZ_PROFILE stores the personalization tag or profile for an entity. The entity could be a user, an objec | hub |
JTF_TASKS_B |
Base Table JTF_TASKS_B stores general information about a given Task. | hub |
JTF_AUTH_PRINCIPALS_B |
A principal will be a user or a role. If the principal is a user then the column IS_USER_FLAG is set to 1 and | hub |
CAC_SR_TEMPLATES_B |
Base Table JTF_SR_TEMPLATES_B stores general information about a Schedule Template | hub-leaning |
JTF_RS_TEAMS_B |
Base Table JTF_RS_TEAMS_B stores general information about a given Team. | hub-leaning |
JTF_TASK_TEMP_GROUPS_B |
JTF_TASK_TEMPLATES_B stores all task template groups. | hub |
JTF_LOC_AREAS_B |
A generic table to hold geographical location definitions that is not stored somewhere else in Oracle Applicat | hub |
JTF_MSITES_B |
Stores Mini Site (Specialty Stores) Information. | hub |
JTF_GRID_DATASOURCES_B |
Meta Data definitions that are used to initialize and set up a a spreadtable UI component. | hub |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
JTF_PLSQL_API |
API | 12 | 293 packages |
JTF_NOTES_PUB |
PUB | 16 | 78 packages |
JTF_TASKS_PUB |
PUB | 23 | 46 packages |
JTF_FM_REQUEST_GRP |
GRP | 20 | 30 packages |
JTF_IH_PUB |
PUB | 20 | 29 packages |
JTF_TASK_ASSIGNMENTS_PUB |
PUB | 10 | 25 packages |
JTF_TERRITORY_PUB |
PUB | 12 | 24 packages |
JTF_PERZ_PROFILE_PUB |
PUB | 3 | 21 packages |
JTF_RS_RESOURCE_PUB |
PUB | 8 | 20 packages |
JTF_DEBUG_PUB |
PUB | 22 | 15 packages |