This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.
The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend
This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.
Oracle is a registered trademark. AIM Advantage, Big Business. Small Business. All Business., CDM Advantage, .comference, ConText®, Des40®, Easy*Query, Easy*SQL®, Education Objects, EMM Advantage, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist, Hyper*SQL, instantOracle, "Internet Business Intelligence - Insight for Everyone", iSQL*Plus, JInitiator, NLS*Workbench®, Object Marketplace, ODP Pulse, ODP Techwire, OLA, On Oracle, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer, Oracle® Expert, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile, Oracle Names®, Oracle NetSolutions®, Oracle® One, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i, Oracle9i, PC Express®, Personal Express®, PJM Advantage, PL/SQL, Pro*Ada®, Pro*C, Pro*C/C++, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit, ProREXX, Report Card, Secure Access 2.0, Secure Network Services®, Security Without Compromise, SellingPoint®, SQL*Plus®, Tutor are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
CAC_SR_EXCEPTIONS_B.PERIOD_CATEGORY_ID | CAC_SR_PERIOD_CATS_B |
CAC_SR_EXCEPTIONS_B.TEMPLATE_ID | CAC_SR_TEMPLATES_B |
Foreign Key Column | Foreign Table |
---|---|
CAC_SR_EXCEPTIONS_TL.EXCEPTION_ID | CAC_SR_EXCEPTIONS_B |
CAC_SR_EXCP_DETAILS.EXCEPTION_ID | CAC_SR_EXCEPTIONS_B |
CAC_SR_SCHDL_EXCEPTIONS.EXCEPTION_ID | CAC_SR_EXCEPTIONS_B |
JTF.CAC_SR_EXCEPTIONS_B does not reference any database object
JTF.CAC_SR_EXCEPTIONS_B is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
CAC_SR_EXCEPTIONS_TL.EXCEPTION_ID | CAC_SR_EXCEPTIONS_B |
JTF.CAC_SR_EXCEPTIONS_TL does not reference any database object
JTF.CAC_SR_EXCEPTIONS_TL is referenced by following:
Description: | This is used to store details of a template based exception |
---|
Foreign Key Column | Foreign Table |
---|---|
CAC_SR_EXCP_DETAILS.EXCEPTION_ID | CAC_SR_EXCEPTIONS_B |
CAC_SR_EXCP_DETAILS.PERIOD_ID | CAC_SR_PERIODS_B |
JTF.CAC_SR_EXCP_DETAILS does not reference any database object
JTF.CAC_SR_EXCP_DETAILS is referenced by following:
Description: | This table is used to store availability summary. This includes (Schedules - Exception - Tasks) |
---|
JTF.CAC_SR_OBJECT_CAPACITY does not reference any database object
JTF.CAC_SR_OBJECT_CAPACITY is referenced by following:
Description: | This table stores non-translated data of periods |
---|
Foreign Key Column | Foreign Table |
---|---|
CAC_SR_PERIODS_B.PERIOD_CATEGORY_ID | CAC_SR_PERIOD_CATS_B |
Foreign Key Column | Foreign Table |
---|---|
CAC_SR_EXCP_DETAILS.PERIOD_ID | CAC_SR_PERIODS_B |
CAC_SR_PERIODS_TL.PERIOD_ID | CAC_SR_PERIODS_B |
CAC_SR_PERIOD_DETAILS.PERIOD_ID | CAC_SR_PERIODS_B |
CAC_SR_SCHDL_DETAILS.PERIOD_ID | CAC_SR_PERIODS_B |
CAC_SR_TMPL_DETAILS.CHILD_PERIOD_ID | CAC_SR_PERIODS_B |
JTF.CAC_SR_PERIODS_B does not reference any database object
JTF.CAC_SR_PERIODS_B is referenced by following:
Description: | This table stores translated data of periods |
---|
Foreign Key Column | Foreign Table |
---|---|
CAC_SR_PERIODS_TL.PERIOD_ID | CAC_SR_PERIODS_B |
JTF.CAC_SR_PERIODS_TL does not reference any database object
JTF.CAC_SR_PERIODS_TL is referenced by following:
Description: | This table stores non-translated data of period category |
---|
Foreign Key Column | Foreign Table |
---|---|
CAC_SR_EXCEPTIONS_B.PERIOD_CATEGORY_ID | CAC_SR_PERIOD_CATS_B |
CAC_SR_PERIODS_B.PERIOD_CATEGORY_ID | CAC_SR_PERIOD_CATS_B |
CAC_SR_PERIOD_CATS_TL.PERIOD_CATEGORY_ID | CAC_SR_PERIOD_CATS_B |
JTF.CAC_SR_PERIOD_CATS_B does not reference any database object
JTF.CAC_SR_PERIOD_CATS_B is referenced by following:
Description: | This table stores translated data of period category |
---|
Foreign Key Column | Foreign Table |
---|---|
CAC_SR_PERIOD_CATS_TL.PERIOD_CATEGORY_ID | CAC_SR_PERIOD_CATS_B |
JTF.CAC_SR_PERIOD_CATS_TL does not reference any database object
JTF.CAC_SR_PERIOD_CATS_TL is referenced by following:
Description: | This table stores details of a period |
---|
Foreign Key Column | Foreign Table |
---|---|
CAC_SR_PERIOD_DETAILS.PERIOD_ID | CAC_SR_PERIODS_B |
CAC_SR_PERIOD_DETAILS.PERIOD_DTL_TYPE_ID | CAC_SR_PERIOD_DTL_TYPES_B |
JTF.CAC_SR_PERIOD_DETAILS does not reference any database object
JTF.CAC_SR_PERIOD_DETAILS is referenced by following:
Description: | This table is used to store details about period detail types. |
---|
Foreign Key Column | Foreign Table |
---|---|
CAC_SR_PERIOD_DETAILS.PERIOD_DTL_TYPE_ID | CAC_SR_PERIOD_DTL_TYPES_B |
CAC_SR_PERIOD_DTL_TYPES_TL.PERIOD_DTL_TYPE_ID | CAC_SR_PERIOD_DTL_TYPES_B |
JTF.CAC_SR_PERIOD_DTL_TYPES_B does not reference any database object
JTF.CAC_SR_PERIOD_DTL_TYPES_B is referenced by following:
Description: | This table is used to store details about period detail types. |
---|
Foreign Key Column | Foreign Table |
---|---|
CAC_SR_PERIOD_DTL_TYPES_TL.PERIOD_DTL_TYPE_ID | CAC_SR_PERIOD_DTL_TYPES_B |
JTF.CAC_SR_PERIOD_DTL_TYPES_TL does not reference any database object
JTF.CAC_SR_PERIOD_DTL_TYPES_TL is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
CAC_SR_PUBLISH_SCHEDULES.SCHEDULE_ID | CAC_SR_SCHEDULES_B |
JTF.CAC_SR_PUBLISH_SCHEDULES does not reference any database object
JTF.CAC_SR_PUBLISH_SCHEDULES is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
CAC_SR_SCHDL_DETAILS.SCHEDULE_ID | CAC_SR_SCHEDULES_B |
CAC_SR_SCHDL_DETAILS.SCHEDULE_OBJECT_ID | CAC_SR_SCHDL_OBJECTS |
CAC_SR_SCHDL_DETAILS.PERIOD_ID | CAC_SR_PERIODS_B |
JTF.CAC_SR_SCHDL_DETAILS does not reference any database object
JTF.CAC_SR_SCHDL_DETAILS is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
CAC_SR_SCHDL_EXCEPTIONS.SCHEDULE_ID | CAC_SR_SCHEDULES_B |
CAC_SR_SCHDL_EXCEPTIONS.SCHEDULE_OBJECT_ID | CAC_SR_SCHDL_OBJECTS |
CAC_SR_SCHDL_EXCEPTIONS.EXCEPTION_ID | CAC_SR_EXCEPTIONS_B |
JTF.CAC_SR_SCHDL_EXCEPTIONS does not reference any database object
JTF.CAC_SR_SCHDL_EXCEPTIONS is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
CAC_SR_SCHDL_OBJECTS.SCHEDULE_ID | CAC_SR_SCHEDULES_B |
Foreign Key Column | Foreign Table |
---|---|
CAC_SR_SCHDL_DETAILS.SCHEDULE_OBJECT_ID | CAC_SR_SCHDL_OBJECTS |
CAC_SR_SCHDL_EXCEPTIONS.SCHEDULE_OBJECT_ID | CAC_SR_SCHDL_OBJECTS |
JTF.CAC_SR_SCHDL_OBJECTS does not reference any database object
JTF.CAC_SR_SCHDL_OBJECTS is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
CAC_SR_SCHEDULES_B.TEMPLATE_ID | CAC_SR_TEMPLATES_B |
Foreign Key Column | Foreign Table |
---|---|
CAC_SR_PUBLISH_SCHEDULES.SCHEDULE_ID | CAC_SR_SCHEDULES_B |
CAC_SR_SCHDL_DETAILS.SCHEDULE_ID | CAC_SR_SCHEDULES_B |
CAC_SR_SCHDL_EXCEPTIONS.SCHEDULE_ID | CAC_SR_SCHEDULES_B |
CAC_SR_SCHDL_OBJECTS.SCHEDULE_ID | CAC_SR_SCHEDULES_B |
CAC_SR_SCHEDULES_TL.SCHEDULE_ID | CAC_SR_SCHEDULES_B |
JTF.CAC_SR_SCHEDULES_B does not reference any database object
JTF.CAC_SR_SCHEDULES_B is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
CAC_SR_SCHEDULES_TL.SCHEDULE_ID | CAC_SR_SCHEDULES_B |
JTF.CAC_SR_SCHEDULES_TL does not reference any database object
JTF.CAC_SR_SCHEDULES_TL is referenced by following:
Description: | Base Table JTF_SR_TEMPLATES_B stores general information about a Schedule Template |
---|
Foreign Key Column | Foreign Table |
---|---|
CAC_SR_EXCEPTIONS_B.TEMPLATE_ID | CAC_SR_TEMPLATES_B |
CAC_SR_SCHEDULES_B.TEMPLATE_ID | CAC_SR_TEMPLATES_B |
CAC_SR_TEMPLATES_TL.TEMPLATE_ID | CAC_SR_TEMPLATES_B |
CAC_SR_TMPL_DETAILS.TEMPLATE_ID | CAC_SR_TEMPLATES_B |
CAC_SR_TMPL_DETAILS.CHILD_TEMPLATE_ID | CAC_SR_TEMPLATES_B |
JTF.CAC_SR_TEMPLATES_B does not reference any database object
JTF.CAC_SR_TEMPLATES_B is referenced by following:
Description: | This tables stores translated data of a Schedule Template |
---|
Foreign Key Column | Foreign Table |
---|---|
CAC_SR_TEMPLATES_TL.TEMPLATE_ID | CAC_SR_TEMPLATES_B |
JTF.CAC_SR_TEMPLATES_TL does not reference any database object
JTF.CAC_SR_TEMPLATES_TL is referenced by following:
Description: | This table stores non translated data of a detail line of a Schedule Template |
---|
Foreign Key Column | Foreign Table |
---|---|
CAC_SR_TMPL_DETAILS.TEMPLATE_ID | CAC_SR_TEMPLATES_B |
CAC_SR_TMPL_DETAILS.CHILD_PERIOD_ID | CAC_SR_PERIODS_B |
CAC_SR_TMPL_DETAILS.CHILD_TEMPLATE_ID | CAC_SR_TEMPLATES_B |
JTF.CAC_SR_TMPL_DETAILS does not reference any database object
JTF.CAC_SR_TMPL_DETAILS is referenced by following:
Description: |
---|
JTF.CAC_SYNC_AGENTS does not reference any database object
JTF.CAC_SYNC_AGENTS is referenced by following:
Description: | Stores general information about the last anchor date when sync was done for appointments/tasks/contacts |
---|
Foreign Key Column | Foreign Table |
---|---|
CAC_SYNC_ANCHORS.PRINCIPAL_ID | CAC_SYNC_PRINCIPALS |
JTF.CAC_SYNC_ANCHORS does not reference any database object
JTF.CAC_SYNC_ANCHORS is referenced by following:
Description: |
---|
JTF.CAC_SYNC_CONTACT_MAPPINGS does not reference any database object
JTF.CAC_SYNC_CONTACT_MAPPINGS is referenced by following:
Description: | Each line includes sync server and sync client mappings for each for appointments, tasks and contacts |
---|
Foreign Key Column | Foreign Table |
---|---|
CAC_SYNC_MAPPINGS.PRINCIPAL_ID | CAC_SYNC_PRINCIPALS |
JTF.CAC_SYNC_MAPPINGS does not reference any database object
JTF.CAC_SYNC_MAPPINGS is referenced by following:
Description: | Each line stores truncated version of SyncML reply and response payload |
---|
JTF.CAC_SYNC_MESSAGES does not reference any database object
JTF.CAC_SYNC_MESSAGES is referenced by following:
Description: | Stores information about client devices synced with. |
---|
Foreign Key Column | Foreign Table |
---|---|
CAC_SYNC_PRINCIPALS.USER_ID | FND_USER |
Foreign Key Column | Foreign Table |
---|---|
CAC_SYNC_ANCHORS.PRINCIPAL_ID | CAC_SYNC_PRINCIPALS |
CAC_SYNC_MAPPINGS.PRINCIPAL_ID | CAC_SYNC_PRINCIPALS |
JTF.CAC_SYNC_PRINCIPALS does not reference any database object
JTF.CAC_SYNC_PRINCIPALS is referenced by following:
Description: |
---|
JTF.CAC_SYNC_STORE_DATA does not reference any database object
JTF.CAC_SYNC_STORE_DATA is referenced by following:
Description: |
---|
JTF.CAC_VIEW_COLLAB_DETAILS does not reference any database object
JTF.CAC_VIEW_COLLAB_DETAILS is referenced by following:
Description: |
---|
JTF.CAC_VIEW_COLLAB_DETAILS_TL does not reference any database object
JTF.CAC_VIEW_COLLAB_DETAILS_TL is referenced by following:
Description: | Mapping table for Task Sync |
---|
JTF.JTA_SYNC_TASK_MAPPING does not reference any database object
JTF.JTA_SYNC_TASK_MAPPING is referenced by following:
Description: | Stores the information of tasks/appointments excluded from a repeating series. |
---|
JTF.JTA_TASK_EXCLUSIONS does not reference any database object
JTF.JTA_TASK_EXCLUSIONS is referenced by following:
Description: | This table maps activity type and categories. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_ACT_ACTIVITY_CATS.JTF_ACT_TYPES_B_ID | JTF_ACT_TYPES_B |
JTF_ACT_ACTIVITY_CATS.JTF_ACT_APP_CATS_ID | JTF_ACT_APP_CATS |
JTF.JTF_ACT_ACTIVITY_CATS does not reference any database object
JTF.JTF_ACT_ACTIVITY_CATS is referenced by following:
Description: | This table is the default table to store all activities. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_ACT_ACTIVITY_LOGS.ACTIVITY_NAME_ID | JTF_ACT_TYPES_B |
JTF_ACT_ACTIVITY_LOGS.APPLICATION_ID | FND_APPLICATION |
JTF_ACT_ACTIVITY_LOGS.JTF_ACT_ACTIVITY_LOGS_USER_ID | FND_USER |
JTF.JTF_ACT_ACTIVITY_LOGS does not reference any database object
JTF.JTF_ACT_ACTIVITY_LOGS is referenced by following:
Description: | this table maps application and categories. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_ACT_APP_CATS.APPLICATION_ID | FND_APPLICATION |
Foreign Key Column | Foreign Table |
---|---|
JTF_ACT_ACTIVITY_CATS.JTF_ACT_APP_CATS_ID | JTF_ACT_APP_CATS |
JTF.JTF_ACT_APP_CATS does not reference any database object
JTF.JTF_ACT_APP_CATS is referenced by following:
Description: | This table maps activity type and attributes. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_ACT_TYPES_ATTRS_B.ACTIVITY_NAME_ID | JTF_ACT_TYPES_B |
Foreign Key Column | Foreign Table |
---|---|
JTF_ACT_TYPES_ATTRS_TL.ATTRIBUTE_NAME_ID | JTF_ACT_TYPES_ATTRS_B |
JTF.JTF_ACT_TYPES_ATTRS_B does not reference any database object
JTF.JTF_ACT_TYPES_ATTRS_B is referenced by following:
Description: | the translation table of jtf_act_types_attrs_b table. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_ACT_TYPES_ATTRS_TL.ATTRIBUTE_NAME_ID | JTF_ACT_TYPES_ATTRS_B |
JTF.JTF_ACT_TYPES_ATTRS_TL does not reference any database object
JTF.JTF_ACT_TYPES_ATTRS_TL is referenced by following:
Description: | Define the activity type. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_ACT_ACTIVITY_CATS.JTF_ACT_TYPES_B_ID | JTF_ACT_TYPES_B |
JTF_ACT_ACTIVITY_LOGS.ACTIVITY_NAME_ID | JTF_ACT_TYPES_B |
JTF_ACT_TYPES_ATTRS_B.ACTIVITY_NAME_ID | JTF_ACT_TYPES_B |
JTF_ACT_TYPES_TL.ACTIVITY_NAME_ID | JTF_ACT_TYPES_B |
JTF.JTF_ACT_TYPES_B does not reference any database object
JTF.JTF_ACT_TYPES_B is referenced by following:
Description: | the table is the translation table of jtf_act_types_tl. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_ACT_TYPES_TL.ACTIVITY_NAME_ID | JTF_ACT_TYPES_B |
JTF.JTF_ACT_TYPES_TL does not reference any database object
JTF.JTF_ACT_TYPES_TL is referenced by following:
Description: |
---|
JTF.JTF_ALERT does not reference any database object
JTF.JTF_ALERT is referenced by following:
Description: | This table stores the documents that are attached to the JTF_AMV_ITEMS_B table. Attached files are stored in the FND_LOBS. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_AMV_ATTACHMENTS.OWNER_USER_ID | FND_USER |
JTF_AMV_ATTACHMENTS.ATTACHMENT_USED_BY_ID | JTF_AMV_ITEMS_B |
JTF_AMV_ATTACHMENTS.FILE_ID | FND_LOBS |
JTF_AMV_ATTACHMENTS.LANGUAGE_CODE | FND_LANGUAGES |
JTF_AMV_ATTACHMENTS.APPLICATION_ID | FND_APPLICATION |
JTF_AMV_ATTACHMENTS.DOCUMENT_ID | FND_DOCUMENTS |
Foreign Key Column | Foreign Table |
---|---|
AMS_DELIVERABLES_ALL_B.JTF_AMV_ITEM_ID | JTF_AMV_ATTACHMENTS |
IBE_DSP_LGL_PHYS_MAP.ATTACHMENT_ID | JTF_AMV_ATTACHMENTS |
IBE_EOS_THEMES_B.LOGO_ATTACHMENT_ID | JTF_AMV_ATTACHMENTS |
JTF_DSP_LGL_PHYS_MAP.ATTACHMENT_ID | JTF_AMV_ATTACHMENTS |
JTF.JTF_AMV_ATTACHMENTS does not reference any database object
JTF.JTF_AMV_ATTACHMENTS is referenced by following:
Description: | Store document. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_AMV_ITEMS_B.LANGUAGE_CODE | FND_LANGUAGES |
JTF_AMV_ITEMS_B.APPLICATION_ID | FND_APPLICATION |
Foreign Key Column | Foreign Table |
---|---|
AMV_C_CHL_ITEM_MATCH.ITEM_ID | JTF_AMV_ITEMS_B |
AMV_D_COMPL_RULE_ITEMS.ITEM_ID | JTF_AMV_ITEMS_B |
AMV_D_SIMPLE_RULE_ITEMS.ITEM_ID | JTF_AMV_ITEMS_B |
AMV_I_ITEM_PERSPECTIVES.ITEM_ID | JTF_AMV_ITEMS_B |
AMV_U_ACCESS.ACCESS_TO_TABLE_RECORD_ID | JTF_AMV_ITEMS_B |
IBE_DSP_CONTEXT_B.ITEM_ID | JTF_AMV_ITEMS_B |
IBE_DSP_LGL_PHYS_MAP.ITEM_ID | JTF_AMV_ITEMS_B |
IBE_DSP_OBJ_LGL_CTNT.ITEM_ID | JTF_AMV_ITEMS_B |
IBE_DSP_SECTIONS_B.DELIVERABLE_ID | JTF_AMV_ITEMS_B |
IBE_DSP_TPL_CTG.ITEM_ID | JTF_AMV_ITEMS_B |
JTF_AMV_ATTACHMENTS.ATTACHMENT_USED_BY_ID | JTF_AMV_ITEMS_B |
JTF_AMV_ITEMS_TL.ITEM_ID | JTF_AMV_ITEMS_B |
JTF_AMV_ITEM_AUTHORS.ITEM_ID | JTF_AMV_ITEMS_B |
JTF_AMV_ITEM_KEYWORDS.ITEM_ID | JTF_AMV_ITEMS_B |
JTF_DSP_CONTEXT_B.ITEM_ID | JTF_AMV_ITEMS_B |
JTF_DSP_LGL_PHYS_MAP.ITEM_ID | JTF_AMV_ITEMS_B |
JTF_DSP_OBJ_LGL_CTNT.ITEM_ID | JTF_AMV_ITEMS_B |
JTF_DSP_TPL_CTG.ITEM_ID | JTF_AMV_ITEMS_B |
OKL_PROCESS_TMPLTS_ALL_B.JTF_AMV_ITEM_ID | JTF_AMV_ITEMS_B |
JTF.JTF_AMV_ITEMS_B does not reference any database object
JTF.JTF_AMV_ITEMS_B is referenced by following:
Description: | Stores all translated columns. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_AMV_ITEMS_TL.ITEM_ID | JTF_AMV_ITEMS_B |
JTF.JTF_AMV_ITEMS_TL does not reference any database object
JTF.JTF_AMV_ITEMS_TL is referenced by following:
Description: | Stores one to many authors for a specific item. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_AMV_ITEM_AUTHORS.ITEM_ID | JTF_AMV_ITEMS_B |
JTF.JTF_AMV_ITEM_AUTHORS does not reference any database object
JTF.JTF_AMV_ITEM_AUTHORS is referenced by following:
Description: | Stores one to many keywords for a specific item. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_AMV_ITEM_KEYWORDS.ITEM_ID | JTF_AMV_ITEMS_B |
JTF.JTF_AMV_ITEM_KEYWORDS does not reference any database object
JTF.JTF_AMV_ITEM_KEYWORDS is referenced by following:
Description: | This table is the setup table to modify the Assignment Manager UI layout |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_AM_SCREEN_SETUPS_TL.SCREEN_SETUP_ID | JTF_AM_SCREEN_SETUPS_B |
JTF.JTF_AM_SCREEN_SETUPS_B does not reference any database object
JTF.JTF_AM_SCREEN_SETUPS_B is referenced by following:
Description: | This table is the translation table for JTF_AM_SCREEN_SETUPS_B for Assignment Manager |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_AM_SCREEN_SETUPS_TL.SCREEN_SETUP_ID | JTF_AM_SCREEN_SETUPS_B |
JTF.JTF_AM_SCREEN_SETUPS_TL does not reference any database object
JTF.JTF_AM_SCREEN_SETUPS_TL is referenced by following:
Description: | This table contains the skill rule mapping with product, category, problem code and component. It will help in finiding the rule id for specific document type depending on whether product id, category id, problem code, subcomponent is passe |
---|
JTF.JTF_AM_SKILL_RULES does not reference any database object
JTF.JTF_AM_SKILL_RULES is referenced by following:
Description: | This table contains the combination which has to be checked in Skill Bank for a given Rule Id. |
---|
JTF.JTF_AM_SKILL_RULE_DTLS does not reference any database object
JTF.JTF_AM_SKILL_RULE_DTLS is referenced by following:
Description: | This table contains data that maps the territory qualifier id to the territory qualifier record attribute name in the territory/am api |
---|
JTF.JTF_AM_TERR_QUALIFIERS does not reference any database object
JTF.JTF_AM_TERR_QUALIFIERS is referenced by following:
Description: | This table maps a type of user to a particular role and a particular application domain. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_AUTH_ACCT_ROLE_MAPS.JTF_AUTH_DOMAIN_ID | JTF_AUTH_DOMAINS_B |
JTF_AUTH_ACCT_ROLE_MAPS.JTF_AUTH_PRINCIPAL_ID | JTF_AUTH_PRINCIPALS_B |
JTF.JTF_AUTH_ACCT_ROLE_MAPS does not reference any database object
JTF.JTF_AUTH_ACCT_ROLE_MAPS is referenced by following:
Description: | Defines the domain for which the role or the permission is granted to the principal. A domain may belong to a parent domain |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_AUTH_DOMAINS_B.PARENT_DOMAIN_ID | JTF_AUTH_DOMAINS_B |
JTF_AUTH_DOMAINS_B.APPLICATION_ID | FND_APPLICATION |
Foreign Key Column | Foreign Table |
---|---|
JTF_AUTH_ACCT_ROLE_MAPS.JTF_AUTH_DOMAIN_ID | JTF_AUTH_DOMAINS_B |
JTF_AUTH_DOMAINS_B.PARENT_DOMAIN_ID | JTF_AUTH_DOMAINS_B |
JTF_AUTH_DOMAINS_TL.DOMAIN_DESC_ID | JTF_AUTH_DOMAINS_B |
JTF_AUTH_PRINCIPAL_MAPS.JTF_AUTH_DOMAIN_ID | JTF_AUTH_DOMAINS_B |
JTF_AUTH_READ_PERMS.JTF_AUTH_DOMAIN_ID | JTF_AUTH_DOMAINS_B |
JTF.JTF_AUTH_DOMAINS_B does not reference any database object
JTF.JTF_AUTH_DOMAINS_B is referenced by following:
Description: | Translation table |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_AUTH_DOMAINS_TL.DOMAIN_DESC_ID | JTF_AUTH_DOMAINS_B |
JTF.JTF_AUTH_DOMAINS_TL does not reference any database object
JTF.JTF_AUTH_DOMAINS_TL is referenced by following:
Description: | This table stores the source information for the user-role mapping table. A role can be assigned to a user coming from different sources. An entry in JTF_AUTH_PRINCIPAL_MAPS can correspond to 1 or more entries in this table. The foreign key |
---|
JTF.JTF_AUTH_MAPS_SOURCES does not reference any database object
JTF.JTF_AUTH_MAPS_SOURCES is referenced by following:
Description: | This table will store the permissions [which are simple strings] for all the domains in the system. We will partition the permissions by applicationID for hosting purposes. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_AUTH_PERMISSIONS_B.APPLICATION_ID | FND_APPLICATION |
Foreign Key Column | Foreign Table |
---|---|
JTF_AUTH_PERMISSIONS_TL.PERMISSION_DESC_ID | JTF_AUTH_PERMISSIONS_B |
JTF_AUTH_READ_PERMS.JTF_AUTH_PERMISSION_ID | JTF_AUTH_PERMISSIONS_B |
JTF_AUTH_ROLE_PERMS.JTF_AUTH_PERMISSION_ID | JTF_AUTH_PERMISSIONS_B |
JTF_DAC_ROLE_PERM_CRIT.JTF_AUTH_PERMISSION_ID | JTF_AUTH_PERMISSIONS_B |
JTF.JTF_AUTH_PERMISSIONS_B does not reference any database object
JTF.JTF_AUTH_PERMISSIONS_B is referenced by following:
Description: | Translation table |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_AUTH_PERMISSIONS_TL.PERMISSION_DESC_ID | JTF_AUTH_PERMISSIONS_B |
JTF.JTF_AUTH_PERMISSIONS_TL does not reference any database object
JTF.JTF_AUTH_PERMISSIONS_TL is referenced by following:
Description: | 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 USER_ID points to a user in FND_USER. We will later use application id to stripe the data for hosting purposes. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_AUTH_ACCT_ROLE_MAPS.JTF_AUTH_PRINCIPAL_ID | JTF_AUTH_PRINCIPALS_B |
JTF_AUTH_PRINCIPALS_TL.PRINCIPAL_DESC_ID | JTF_AUTH_PRINCIPALS_B |
JTF_AUTH_PRINCIPAL_MAPS.JTF_AUTH_PRINCIPAL_ID | JTF_AUTH_PRINCIPALS_B |
JTF_AUTH_PRINCIPAL_MAPS.JTF_AUTH_PARENT_PRINCIPAL_ID | JTF_AUTH_PRINCIPALS_B |
JTF_AUTH_READ_PERMS.JTF_AUTH_PRINCIPAL_ID | JTF_AUTH_PRINCIPALS_B |
JTF_AUTH_ROLE_PERMS.JTF_AUTH_PRINCIPAL_ID | JTF_AUTH_PRINCIPALS_B |
JTF_DAC_ROLE_PERM_CRIT.JTF_AUTH_PRINCIPAL_ID | JTF_AUTH_PRINCIPALS_B |
JTF_UM_SUBSCRIPTIONS_B.AUTH_DELEGATION_ROLE_ID | JTF_AUTH_PRINCIPALS_B |
JTF_UM_SUBSCRIPTION_ROLE.PRINCIPAL_NAME | JTF_AUTH_PRINCIPALS_B |
JTF_UM_USERTYPE_ROLE.PRINCIPAL_NAME | JTF_AUTH_PRINCIPALS_B |
PV_ATTR_PRINCIPALS.JTF_AUTH_PRINCIPAL_ID | JTF_AUTH_PRINCIPALS_B |
JTF.JTF_AUTH_PRINCIPALS_B does not reference any database object
JTF.JTF_AUTH_PRINCIPALS_B is referenced by following:
Description: | Translation table |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_AUTH_PRINCIPALS_TL.PRINCIPAL_DESC_ID | JTF_AUTH_PRINCIPALS_B |
JTF.JTF_AUTH_PRINCIPALS_TL does not reference any database object
JTF.JTF_AUTH_PRINCIPALS_TL is referenced by following:
Description: | This table will be used to grant roles to users by making users [JTF_AUTH_PARENT_PRINCIPAL_ID] parents of the roles [JTF_AUTH_PRINCIPAL_ID] on a domain basis [JTF_AUTH_DOMAIN_ID] |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_AUTH_PRINCIPAL_MAPS.JTF_AUTH_PRINCIPAL_ID | JTF_AUTH_PRINCIPALS_B |
JTF_AUTH_PRINCIPAL_MAPS.JTF_AUTH_PARENT_PRINCIPAL_ID | JTF_AUTH_PRINCIPALS_B |
JTF_AUTH_PRINCIPAL_MAPS.JTF_AUTH_DOMAIN_ID | JTF_AUTH_DOMAINS_B |
JTF_AUTH_PRINCIPAL_MAPS.APPLICATION_ID | FND_APPLICATION |
JTF.JTF_AUTH_PRINCIPAL_MAPS does not reference any database object
JTF.JTF_AUTH_PRINCIPAL_MAPS is referenced by following:
Description: | Is the denormalized table that maps every user [JTF_AUTH_PRINCIPAL_NAME] to a permission [JTF_AUTH_PERMISSION_NAME] for a given domain [JTF_AUTH_DOMAIN_NAME] |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_AUTH_READ_PERMS.JTF_AUTH_PRINCIPAL_ID | JTF_AUTH_PRINCIPALS_B |
JTF_AUTH_READ_PERMS.JTF_AUTH_PERMISSION_ID | JTF_AUTH_PERMISSIONS_B |
JTF_AUTH_READ_PERMS.JTF_AUTH_DOMAIN_ID | JTF_AUTH_DOMAINS_B |
JTF.JTF_AUTH_READ_PERMS does not reference any database object
JTF.JTF_AUTH_READ_PERMS is referenced by following:
Description: | This table groups roles [which are a type of principals] to permissions. Permissions can be positive or negative, based on the column POSITIVE_FLAG. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_AUTH_ROLE_PERMS.APPLICATION_ID | FND_APPLICATION |
JTF_AUTH_ROLE_PERMS.JTF_AUTH_PRINCIPAL_ID | JTF_AUTH_PRINCIPALS_B |
JTF_AUTH_ROLE_PERMS.JTF_AUTH_PERMISSION_ID | JTF_AUTH_PERMISSIONS_B |
JTF.JTF_AUTH_ROLE_PERMS does not reference any database object
JTF.JTF_AUTH_ROLE_PERMS is referenced by following:
Description: | Temp table used for passing bind variables and bind values for business objects. |
---|
JTF.JTF_BIND_DATA does not reference any database object
JTF.JTF_BIND_DATA is referenced by following:
Description: | CRM BIS 11.5.1 Chart Plug Reports |
---|
JTF.JTF_BIS_CHART_FUNCTIONS does not reference any database object
JTF.JTF_BIS_CHART_FUNCTIONS is referenced by following:
Description: | This table store Links to Releted Reports. Each Link is striped for a User, Report. |
---|
JTF.JTF_BIS_RELATED_LINKS does not reference any database object
JTF.JTF_BIS_RELATED_LINKS is referenced by following:
Description: | This table is for storing Chart report information for each user-defined Chart Plug |
---|
JTF.JTF_BIS_USER_CHART_PLUGS does not reference any database object
JTF.JTF_BIS_USER_CHART_PLUGS is referenced by following:
Description: | This table is for storing Chart report information for each user-defined Favorite Plug |
---|
JTF.JTF_BIS_USER_FAVORITE_PLUGS does not reference any database object
JTF.JTF_BIS_USER_FAVORITE_PLUGS is referenced by following:
Description: | Expression Lines for simple business rule definitions. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_BRM_EXPRESSION_LINES.RULE_ID | % |
JTF_BRM_EXPRESSION_LINES.RULE_ID | JTF_BRM_RULES_B |
JTF.JTF_BRM_EXPRESSION_LINES does not reference any database object
JTF.JTF_BRM_EXPRESSION_LINES is referenced by following:
Description: | Parameters for the main workflow process of the Business Rule Monitor. |
---|
JTF.JTF_BRM_PARAMETERS does not reference any database object
JTF.JTF_BRM_PARAMETERS is referenced by following:
Description: | In this table a workflow process is linked to a business rule. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_BRM_PROCESSES.RULE_ID | JTF_BRM_RULES_B |
JTF_BRM_PROCESSES.RULE_ID | JTF_BRM_RULES_B |
Foreign Key Column | Foreign Table |
---|---|
JTF_BRM_WF_ATTR_VALUES.PROCESS_ID | JTF_BRM_PROCESSES |
JTF.JTF_BRM_PROCESSES does not reference any database object
JTF.JTF_BRM_PROCESSES is referenced by following:
Description: | Base table for business rules that are monitored by the business rule monitor. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_BRM_EXPRESSION_LINES.RULE_ID | JTF_BRM_RULES_B |
JTF_BRM_PROCESSES.RULE_ID | JTF_BRM_RULES_B |
JTF_BRM_PROCESSES.RULE_ID | JTF_BRM_RULES_B |
JTF_BRM_RULES_TL.RULE_ID | JTF_BRM_RULES_B |
JTF_BRM_RULES_TL.RULE_ID | JTF_BRM_RULES_B |
JTF.JTF_BRM_RULES_B does not reference any database object
JTF.JTF_BRM_RULES_B is referenced by following:
Description: | Translation table for a business rules that are monitored by the business rule monitor. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_BRM_RULES_TL.RULE_ID | JTF_BRM_RULES_B |
JTF_BRM_RULES_TL.RULE_ID | JTF_BRM_RULES_B |
JTF.JTF_BRM_RULES_TL does not reference any database object
JTF.JTF_BRM_RULES_TL is referenced by following:
Description: | Contains Workflow attribute values for each process |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_BRM_WF_ATTR_VALUES.PROCESS_ID | JTF_BRM_PROCESSES |
JTF.JTF_BRM_WF_ATTR_VALUES does not reference any database object
JTF.JTF_BRM_WF_ATTR_VALUES is referenced by following:
Description: | Business Object X-reference for Inbound messages. |
---|
JTF.JTF_BUS_OBJ_XREF does not reference any database object
JTF.JTF_BUS_OBJ_XREF is referenced by following:
Description: | Calendar Name,Type, Description and Effectivity. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_CALENDARS_TL.CALENDAR_ID | JTF_CALENDARS_B |
JTF_CAL_EXCEPTION_ASSIGN.CALENDAR_ID | JTF_CALENDARS_B |
JTF_CAL_RESOURCE_ASSIGN.CALENDAR_ID | JTF_CALENDARS_B |
JTF_CAL_RESOURCE_ASSIGN.CALENDAR_ID | JTF_CALENDARS_B |
JTF_CAL_SHIFT_ASSIGN.CALENDAR_ID | JTF_CALENDARS_B |
JTF_CAL_SHIFT_ASSIGN.CALENDAR_ID | JTF_CALENDARS_B |
PA_PROJECT_ASSIGNMENTS.CALENDAR_ID | JTF_CALENDARS_B |
PA_PROJ_ELEM_VER_SCHEDULE.CALENDAR_ID | JTF_CALENDARS_B |
PA_SCHEDULES.CALENDAR_ID | JTF_CALENDARS_B |
JTF.JTF_CALENDARS_B does not reference any database object
JTF.JTF_CALENDARS_B is referenced by following:
Description: | Translation table for JTF_CALENDARS_B |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_CALENDARS_TL.CALENDAR_ID | JTF_CALENDARS_B |
JTF.JTF_CALENDARS_TL does not reference any database object
JTF.JTF_CALENDARS_TL is referenced by following:
Description: | This table is used to store addresses of private contacts, the table is design to make Palm sync possible in the future. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_CAL_ADDRESSES.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF.JTF_CAL_ADDRESSES does not reference any database object
JTF.JTF_CAL_ADDRESSES is referenced by following:
Description: | Exception Name, Type, Description, and Effectivity. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_CAL_EXCEPTIONS_TL.EXCEPTION_ID | JTF_CAL_EXCEPTIONS_B |
JTF_CAL_EXCEPTION_ASSIGN.EXCEPTION_ID | JTF_CAL_EXCEPTIONS_B |
JTF.JTF_CAL_EXCEPTIONS_B does not reference any database object
JTF.JTF_CAL_EXCEPTIONS_B is referenced by following:
Description: | Translation table for JTF_CAL_EXCEPTIONS_B table. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_CAL_EXCEPTIONS_TL.EXCEPTION_ID | JTF_CAL_EXCEPTIONS_B |
JTF.JTF_CAL_EXCEPTIONS_TL does not reference any database object
JTF.JTF_CAL_EXCEPTIONS_TL is referenced by following:
Description: | Assign Exceptions to a Calendar. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_CAL_EXCEPTION_ASSIGN.CALENDAR_ID | JTF_CALENDARS_B |
JTF_CAL_EXCEPTION_ASSIGN.EXCEPTION_ID | JTF_CAL_EXCEPTIONS_B |
JTF_CAL_EXCEPTION_ASSIGN.CALENDAR_ID | % |
JTF_CAL_EXCEPTION_ASSIGN.EXCEPTION_ID | % |
JTF.JTF_CAL_EXCEPTION_ASSIGN does not reference any database object
JTF.JTF_CAL_EXCEPTION_ASSIGN is referenced by following:
Description: | Base table for Calendar Items. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_CAL_ITEMS_TL.CAL_ITEM_ID | JTF_CAL_ITEMS_B |
JTF.JTF_CAL_ITEMS_B does not reference any database object
JTF.JTF_CAL_ITEMS_B is referenced by following:
Description: | Translation table for Calendar Items. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_CAL_ITEMS_TL.CAL_ITEM_ID | JTF_CAL_ITEMS_B |
JTF.JTF_CAL_ITEMS_TL does not reference any database object
JTF.JTF_CAL_ITEMS_TL is referenced by following:
Description: | Assign Resources to a Calendar. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_CAL_RESOURCE_ASSIGN.CALENDAR_ID | JTF_CALENDARS_B |
JTF_CAL_RESOURCE_ASSIGN.RESOURCE_TYPE_CODE | JTF_OBJECTS_B |
JTF_CAL_RESOURCE_ASSIGN.CALENDAR_ID | JTF_CALENDARS_B |
JTF_CAL_RESOURCE_ASSIGN.RESOURCE_TYPE_CODE | % |
JTF.JTF_CAL_RESOURCE_ASSIGN does not reference any database object
JTF.JTF_CAL_RESOURCE_ASSIGN is referenced by following:
Description: | Shift Name, Description, and Effectivity. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_CAL_SHIFT_ASSIGN.SHIFT_ID | JTF_CAL_SHIFTS_B |
JTF_CAL_SHIFTS_TL.SHIFT_ID | JTF_CAL_SHIFTS_B |
JTF_CAL_SHIFT_ASSIGN.SHIFT_ID | JTF_CAL_SHIFTS_B |
JTF_CAL_SHIFT_CONSTRUCTS.SHIFT_ID | JTF_CAL_SHIFTS_B |
JTF.JTF_CAL_SHIFTS_B does not reference any database object
JTF.JTF_CAL_SHIFTS_B is referenced by following:
Description: | Translation table for JTF_CAL_SHIFTS_B table. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_CAL_SHIFTS_TL.SHIFT_ID | JTF_CAL_SHIFTS_B |
JTF.JTF_CAL_SHIFTS_TL does not reference any database object
JTF.JTF_CAL_SHIFTS_TL is referenced by following:
Description: | Assign Shifts to a Calendar. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_CAL_SHIFT_ASSIGN.CALENDAR_ID | JTF_CALENDARS_B |
JTF_CAL_SHIFT_ASSIGN.SHIFT_ID | JTF_CAL_SHIFTS_B |
JTF_CAL_SHIFT_ASSIGN.CALENDAR_ID | JTF_CALENDARS_B |
JTF_CAL_SHIFT_ASSIGN.SHIFT_ID | JTF_CAL_SHIFTS_B |
JTF.JTF_CAL_SHIFT_ASSIGN does not reference any database object
JTF.JTF_CAL_SHIFT_ASSIGN is referenced by following:
Description: | Shift patterns comprising of start and end times for a particular day, availability type, and effectivity. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_CAL_SHIFT_CONSTRUCTS.SHIFT_ID | % |
JTF_CAL_SHIFT_CONSTRUCTS.SHIFT_ID | JTF_CAL_SHIFTS_B |
Foreign Key Column | Foreign Table |
---|---|
JTF_TASK_ASSIGNMENTS.SHIFT_CONSTRUCT_ID | JTF_CAL_SHIFT_CONSTRUCTS |
JTF.JTF_CAL_SHIFT_CONSTRUCTS does not reference any database object
JTF.JTF_CAL_SHIFT_CONSTRUCTS is referenced by following:
Description: | Stores records of changes to JTF_TERR_ALL, JTF_TERR_VALUES, and JTF_TERR_RSC |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_CHANGED_TERR_ALL.TERR_ID | JTF_TERR_ALL |
JTF.JTF_CHANGED_TERR_ALL does not reference any database object
JTF.JTF_CHANGED_TERR_ALL is referenced by following:
Description: | Bind variable values for End user customizations of filtering criteria to a spreadtable UI component. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_CUSTOM_BIND_VALUES.CUSTOM_GRID_ID | JTF_CUSTOM_GRIDS |
JTF.JTF_CUSTOM_BIND_VALUES does not reference any database object
JTF.JTF_CUSTOM_BIND_VALUES is referenced by following:
Description: | User named sets of customizations, in Oracle Applications commonly referred to as "Folders" |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_CUSTOM_GRIDS.GRID_DATASOURCE_NAME | JTF_GRID_DATASOURCES_B |
JTF_CUSTOM_GRIDS.GRID_DATASOURCE_NAME
JTF_CUSTOM_GRIDS.GRID_SORT_COL_ALIAS1 |
JTF_GRID_COLS_B |
JTF_CUSTOM_GRIDS.GRID_DATASOURCE_NAME
JTF_CUSTOM_GRIDS.GRID_SORT_COL_ALIAS2 |
JTF_GRID_COLS_B |
JTF_CUSTOM_GRIDS.GRID_DATASOURCE_NAME
JTF_CUSTOM_GRIDS.GRID_SORT_COL_ALIAS3 |
JTF_GRID_COLS_B |
Foreign Key Column | Foreign Table |
---|---|
JTF_CUSTOM_BIND_VALUES.CUSTOM_GRID_ID | JTF_CUSTOM_GRIDS |
JTF_CUSTOM_GRID_COLS.CUSTOM_GRID_ID | JTF_CUSTOM_GRIDS |
JTF_DEF_CUSTOM_GRIDS.CUSTOM_GRID_ID | JTF_CUSTOM_GRIDS |
JTF.JTF_CUSTOM_GRIDS does not reference any database object
JTF.JTF_CUSTOM_GRIDS is referenced by following:
Description: | End user customizations (on a column by column basis) to the visual appearance and sort, filtering criteria for a spreadtable UI component. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_CUSTOM_GRID_COLS.CUSTOM_GRID_ID | JTF_CUSTOM_GRIDS |
JTF_CUSTOM_GRID_COLS.GRID_DATASOURCE_NAME
JTF_CUSTOM_GRID_COLS.GRID_COL_ALIAS |
JTF_GRID_COLS_B |
JTF.JTF_CUSTOM_GRID_COLS does not reference any database object
JTF.JTF_CUSTOM_GRID_COLS is referenced by following:
Description: | Do not use |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_DAC_CRITERIA.ROLE_PERM_ID | JTF_DAC_ROLE_PERMS |
Foreign Key Column | Foreign Table |
---|---|
JTF_DAC_ROLE_PERM_CRIT.CRITERIA_ID | JTF_DAC_CRITERIA |
JTF.JTF_DAC_CRITERIA does not reference any database object
JTF.JTF_DAC_CRITERIA is referenced by following:
Description: | Do not use |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_DAC_CRITERIA.ROLE_PERM_ID | JTF_DAC_ROLE_PERMS |
JTF_DAC_ROLE_PERM_CRIT.ROLE_PERM_ID | JTF_DAC_ROLE_PERMS |
JTF.JTF_DAC_ROLE_PERMS does not reference any database object
JTF.JTF_DAC_ROLE_PERMS is referenced by following:
Description: | Do not use |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_DAC_ROLE_PERM_CRIT.JTF_AUTH_PRINCIPAL_ID | JTF_AUTH_PRINCIPALS_B |
JTF_DAC_ROLE_PERM_CRIT.JTF_AUTH_PERMISSION_ID | JTF_AUTH_PERMISSIONS_B |
JTF_DAC_ROLE_PERM_CRIT.ROLE_PERM_ID | JTF_DAC_ROLE_PERMS |
JTF_DAC_ROLE_PERM_CRIT.CRITERIA_ID | JTF_DAC_CRITERIA |
JTF.JTF_DAC_ROLE_PERM_CRIT does not reference any database object
JTF.JTF_DAC_ROLE_PERM_CRIT is referenced by following:
Description: | Holds a reference to what the end user has specified as the default set of customizations. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_DEF_CUSTOM_GRIDS.GRID_DATASOURCE_NAME | JTF_GRID_DATASOURCES_B |
JTF_DEF_CUSTOM_GRIDS.CUSTOM_GRID_ID | JTF_CUSTOM_GRIDS |
JTF.JTF_DEF_CUSTOM_GRIDS does not reference any database object
JTF.JTF_DEF_CUSTOM_GRIDS is referenced by following:
Description: | Stores information about tests that are security alertable |
---|
JTF.JTF_DIAGNOSTIC_ALERT does not reference any database object
JTF.JTF_DIAGNOSTIC_ALERT is referenced by following:
Description: | Stores applications registered with diagnostic fwk and html platform which is a pseudo application |
---|
JTF.JTF_DIAGNOSTIC_APP does not reference any database object
JTF.JTF_DIAGNOSTIC_APP is referenced by following:
Description: | Stores argument name-value pairs for a testcase for a row number |
---|
JTF.JTF_DIAGNOSTIC_ARG does not reference any database object
JTF.JTF_DIAGNOSTIC_ARG is referenced by following:
Description: | Contains test to application class correlation |
---|
JTF.JTF_DIAGNOSTIC_CMAP does not reference any database object
JTF.JTF_DIAGNOSTIC_CMAP is referenced by following:
Description: | Stores information about columns within a sub test type = column |
---|
JTF.JTF_DIAGNOSTIC_DECL_STEP_COLS does not reference any database object
JTF.JTF_DIAGNOSTIC_DECL_STEP_COLS is referenced by following:
Description: | contains information about steps in the test |
---|
JTF.JTF_DIAGNOSTIC_DECL_TEST_STEPS does not reference any database object
JTF.JTF_DIAGNOSTIC_DECL_TEST_STEPS is referenced by following:
Description: | This table will hold the downloadable report which got generated for a particular request. The Report column in the table will hold the zip file of all the reports which got generated under this request name. |
---|
JTF.JTF_DIAGNOSTIC_DOWNLOAD_RPT does not reference any database object
JTF.JTF_DIAGNOSTIC_DOWNLOAD_RPT is referenced by following:
Description: | Stores group info. for apps registered with the framework |
---|
JTF.JTF_DIAGNOSTIC_GROUP does not reference any database object
JTF.JTF_DIAGNOSTIC_GROUP is referenced by following:
Description: | Stores the results of tests executes in the diagnostics framework |
---|
Description: | Stores prereqs for groups and application registered within diagnostics |
---|
JTF.JTF_DIAGNOSTIC_PREREQ does not reference any database object
JTF.JTF_DIAGNOSTIC_PREREQ is referenced by following:
Description: | This table holds the individual components in a report for a test as separate entities. To construct the report for a particular execution, we can get the records for that execution_id and interpret the xmldata to construct the Report. |
---|
Description: | Stores the statistical information about a historical test execution |
---|
JTF.JTF_DIAGNOSTIC_STATS does not reference any database object
JTF.JTF_DIAGNOSTIC_STATS is referenced by following:
Description: | Stores information about testcases registered within the group and app with diagnostics |
---|
Description: | This table will hold the details of the test sets which were seeded/saved by the user. |
---|
Description: | Stores the input/output params for a flow. |
---|
JTF.JTF_DPF_LGCL_FLOW_PARAMS does not reference any database object
JTF.JTF_DPF_LGCL_FLOW_PARAMS is referenced by following:
Description: | See description |
---|
JTF.JTF_DPF_LGCL_NEXT_RULES does not reference any database object
JTF.JTF_DPF_LGCL_NEXT_RULES is referenced by following:
Description: | See description |
---|
JTF.JTF_DPF_LGCL_PHY_RULES does not reference any database object
JTF.JTF_DPF_LGCL_PHY_RULES is referenced by following:
Description: | See description |
---|
JTF.JTF_DPF_LOGICAL_FLOWS_B does not reference any database object
JTF.JTF_DPF_LOGICAL_FLOWS_B is referenced by following:
Description: | See description |
---|
JTF.JTF_DPF_LOGICAL_FLOWS_TL does not reference any database object
JTF.JTF_DPF_LOGICAL_FLOWS_TL is referenced by following:
Description: | See description |
---|
JTF.JTF_DPF_LOGICAL_PAGES_B does not reference any database object
JTF.JTF_DPF_LOGICAL_PAGES_B is referenced by following:
Description: | See description |
---|
JTF.JTF_DPF_LOGICAL_PAGES_TL does not reference any database object
JTF.JTF_DPF_LOGICAL_PAGES_TL is referenced by following:
Description: | See description |
---|
JTF.JTF_DPF_PHYSICAL_PAGES_B does not reference any database object
JTF.JTF_DPF_PHYSICAL_PAGES_B is referenced by following:
Description: | See description |
---|
JTF.JTF_DPF_PHYSICAL_PAGES_TL does not reference any database object
JTF.JTF_DPF_PHYSICAL_PAGES_TL is referenced by following:
Description: | See description |
---|
JTF.JTF_DPF_PHY_ATTRIBS does not reference any database object
JTF.JTF_DPF_PHY_ATTRIBS is referenced by following:
Description: | See description |
---|
JTF.JTF_DPF_RULES_B does not reference any database object
JTF.JTF_DPF_RULES_B is referenced by following:
Description: | See description |
---|
JTF.JTF_DPF_RULES_TL does not reference any database object
JTF.JTF_DPF_RULES_TL is referenced by following:
Description: | See description |
---|
JTF.JTF_DPF_RULE_PARAMS does not reference any database object
JTF.JTF_DPF_RULE_PARAMS is referenced by following:
Description: | Stores the display contexts associated with templates and media attributes for media. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_DSP_CONTEXT_B.ITEM_ID | JTF_AMV_ITEMS_B |
Foreign Key Column | Foreign Table |
---|---|
JTF_DSP_CONTEXT_TL.CONTEXT_ID | JTF_DSP_CONTEXT_B |
JTF_DSP_OBJ_LGL_CTNT.CONTEXT_ID | JTF_DSP_CONTEXT_B |
JTF_DSP_SECTIONS_B.DISPLAY_CONTEXT_ID | JTF_DSP_CONTEXT_B |
JTF.JTF_DSP_CONTEXT_B does not reference any database object
JTF.JTF_DSP_CONTEXT_B is referenced by following:
Description: | Translations for JTF_DSP_CONTEXT_B. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_DSP_CONTEXT_TL.CONTEXT_ID | JTF_DSP_CONTEXT_B |
JTF.JTF_DSP_CONTEXT_TL does not reference any database object
JTF.JTF_DSP_CONTEXT_TL is referenced by following:
Description: | Stores the logical to physical media mapping based on site and language |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_DSP_LGL_PHYS_MAP.ATTACHMENT_ID | JTF_AMV_ATTACHMENTS |
JTF_DSP_LGL_PHYS_MAP.MSITE_ID | JTF_MSITES_B |
JTF_DSP_LGL_PHYS_MAP.ITEM_ID | JTF_AMV_ITEMS_B |
JTF.JTF_DSP_LGL_PHYS_MAP does not reference any database object
JTF.JTF_DSP_LGL_PHYS_MAP is referenced by following:
Description: | This table stores the assocation between mini-site and items. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_DSP_MSITE_SCT_ITEMS.MINI_SITE_ID | JTF_MSITES_B |
JTF_DSP_MSITE_SCT_ITEMS.SECTION_ITEM_ID | JTF_DSP_SECTION_ITEMS |
JTF.JTF_DSP_MSITE_SCT_ITEMS does not reference any database object
JTF.JTF_DSP_MSITE_SCT_ITEMS is referenced by following:
Description: | This table stores the association between mini-site and sections. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_DSP_MSITE_SCT_SECTS.MINI_SITE_ID | JTF_MSITES_B |
JTF_DSP_MSITE_SCT_SECTS.PARENT_SECTION_ID | JTF_DSP_SECTIONS_B |
JTF_DSP_MSITE_SCT_SECTS.CHILD_SECTION_ID | JTF_DSP_SECTIONS_B |
JTF.JTF_DSP_MSITE_SCT_SECTS does not reference any database object
JTF.JTF_DSP_MSITE_SCT_SECTS is referenced by following:
Description: | This table Contains the default logical items for selected display context labels and objects |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_DSP_OBJ_LGL_CTNT.ITEM_ID | JTF_AMV_ITEMS_B |
JTF_DSP_OBJ_LGL_CTNT.CONTEXT_ID | JTF_DSP_CONTEXT_B |
JTF_DSP_OBJ_LGL_CTNT.OBJECT_ID | MTL_CATEGORIES_B |
JTF_DSP_OBJ_LGL_CTNT.OBJECT_ID | JTF_DSP_SECTIONS_B |
JTF.JTF_DSP_OBJ_LGL_CTNT does not reference any database object
JTF.JTF_DSP_OBJ_LGL_CTNT is referenced by following:
Description: | This table stores information about the sections. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_DSP_SECTIONS_B.DISPLAY_CONTEXT_ID | JTF_DSP_CONTEXT_B |
JTF_DSP_SECTIONS_B.DELIVERABLE_ID | AMS_DELIVERABLES_ALL_B |
Foreign Key Column | Foreign Table |
---|---|
JTF_DSP_MSITE_SCT_SECTS.PARENT_SECTION_ID | JTF_DSP_SECTIONS_B |
JTF_DSP_MSITE_SCT_SECTS.CHILD_SECTION_ID | JTF_DSP_SECTIONS_B |
JTF_DSP_OBJ_LGL_CTNT.OBJECT_ID | JTF_DSP_SECTIONS_B |
JTF_DSP_SECTIONS_TL.SECTION_ID | JTF_DSP_SECTIONS_B |
JTF_DSP_SECTION_ITEMS.SECTION_ID | JTF_DSP_SECTIONS_B |
JTF_MSITES_B.MSITE_ROOT_SECTION_ID | JTF_DSP_SECTIONS_B |
JTF.JTF_DSP_SECTIONS_B does not reference any database object
JTF.JTF_DSP_SECTIONS_B is referenced by following:
Description: | This table stores the translatable information about the sections. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_DSP_SECTIONS_TL.SECTION_ID | JTF_DSP_SECTIONS_B |
JTF.JTF_DSP_SECTIONS_TL does not reference any database object
JTF.JTF_DSP_SECTIONS_TL is referenced by following:
Description: | This table stores the association between sections and items. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_DSP_SECTION_ITEMS.SECTION_ID | JTF_DSP_SECTIONS_B |
Foreign Key Column | Foreign Table |
---|---|
JTF_DSP_MSITE_SCT_ITEMS.SECTION_ITEM_ID | JTF_DSP_SECTION_ITEMS |
JTF.JTF_DSP_SECTION_ITEMS does not reference any database object
JTF.JTF_DSP_SECTION_ITEMS is referenced by following:
Description: | This table stores the category to logical template mappings |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_DSP_TPL_CTG.ITEM_ID | JTF_AMV_ITEMS_B |
JTF_DSP_TPL_CTG.CATEGORY_ID | MTL_CATEGORIES_B |
JTF.JTF_DSP_TPL_CTG does not reference any database object
JTF.JTF_DSP_TPL_CTG is referenced by following:
Description: | This table has the information about all the event handlers for a given event. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_EVT_HANDLERS_B.JTF_EVT_TYPES_ID | JTF_EVT_TYPES_B |
Foreign Key Column | Foreign Table |
---|---|
JTF_EVT_HANDLERS_TL.JTF_EVT_HANDLERS_ID | JTF_EVT_HANDLERS_B |
JTF.JTF_EVT_HANDLERS_B does not reference any database object
JTF.JTF_EVT_HANDLERS_B is referenced by following:
Description: | Translation table has the information about all the event handlers for a given event. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_EVT_HANDLERS_TL.JTF_EVT_HANDLERS_ID | JTF_EVT_HANDLERS_B |
JTF.JTF_EVT_HANDLERS_TL does not reference any database object
JTF.JTF_EVT_HANDLERS_TL is referenced by following:
Description: | This table holds information about the different types of Events. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_EVT_HANDLERS_B.JTF_EVT_TYPES_ID | JTF_EVT_TYPES_B |
JTF_EVT_TYPES_TL.JTF_EVT_TYPES_ID | JTF_EVT_TYPES_B |
JTF.JTF_EVT_TYPES_B does not reference any database object
JTF.JTF_EVT_TYPES_B is referenced by following:
Description: | Translation table holds information about the different types of Events. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_EVT_TYPES_TL.JTF_EVT_TYPES_ID | JTF_EVT_TYPES_B |
JTF.JTF_EVT_TYPES_TL does not reference any database object
JTF.JTF_EVT_TYPES_TL is referenced by following:
Description: | Stores the exceptions to a territory. Not used. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_EXCEPTIONS_ALL.TERR_ID | JTF_TERR_ALL |
JTF.JTF_EXCEPTIONS_ALL does not reference any database object
JTF.JTF_EXCEPTIONS_ALL is referenced by following:
Description: | Table internally used by Fulfillment server to store information on the batch segments |
---|
JTF.JTF_FM_BATCH_SEGMENTS does not reference any database object
JTF.JTF_FM_BATCH_SEGMENTS is referenced by following:
Description: | Table to store information about Emails that bounced back. |
---|
JTF.JTF_FM_BOUNCE_BACKS does not reference any database object
JTF.JTF_FM_BOUNCE_BACKS is referenced by following:
Description: | Table that holds details on Failed Requests |
---|
JTF.JTF_FM_CONTENT_FAILURES does not reference any database object
JTF.JTF_FM_CONTENT_FAILURES is referenced by following:
Description: | This table stores the fulfillment content history |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_FM_CONTENT_HISTORY.HIST_REQ_ID
JTF_FM_CONTENT_HISTORY.SUBMIT_DT_TM |
JTF_FM_REQUEST_HISTORY_ALL |
JTF.JTF_FM_CONTENT_HISTORY does not reference any database object
JTF.JTF_FM_CONTENT_HISTORY is referenced by following:
Description: | This table stores fulfillment dispatchers for each server |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_FM_DISPATCHERS.SERVER_ID | JTF_FM_SERVICE_ALL |
JTF_FM_DISPATCHERS.SERVER_ID | JTF_FM_SERVICE_ALL |
Foreign Key Column | Foreign Table |
---|---|
JTF_FM_EMAIL.DISPATCHER_ID
JTF_FM_EMAIL.SERVER_ID |
JTF_FM_DISPATCHERS |
JTF_FM_FAX.DISPATCHER_ID
JTF_FM_FAX.SERVER_ID |
JTF_FM_DISPATCHERS |
JTF_FM_FILE.DISPATCHER_ID
JTF_FM_FILE.SERVER_ID |
JTF_FM_DISPATCHERS |
JTF_FM_PRINTER.DISPATCHER_ID
JTF_FM_PRINTER.SERVER_ID |
JTF_FM_DISPATCHERS |
JTF.JTF_FM_DISPATCHERS does not reference any database object
JTF.JTF_FM_DISPATCHERS is referenced by following:
Description: | This table stores information about the fulfillment email servers |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_FM_EMAIL.DISPATCHER_ID
JTF_FM_EMAIL.SERVER_ID |
JTF_FM_DISPATCHERS |
Foreign Key Column | Foreign Table |
---|---|
JTF_FM_EMAIL_JTF_FM_GROUPS.OUTPUT_ID
JTF_FM_EMAIL_JTF_FM_GROUPS.OUTPUT_TYPE JTF_FM_EMAIL_JTF_FM_GROUPS.DISPATCHER_ID JTF_FM_EMAIL_JTF_FM_GROUPS.SERVER_ID |
JTF_FM_EMAIL |
JTF.JTF_FM_EMAIL does not reference any database object
JTF.JTF_FM_EMAIL is referenced by following:
Description: | Stores cross reference info about email servers and groups |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_FM_EMAIL_JTF_FM_GROUPS.OUTPUT_ID
JTF_FM_EMAIL_JTF_FM_GROUPS.OUTPUT_TYPE JTF_FM_EMAIL_JTF_FM_GROUPS.DISPATCHER_ID JTF_FM_EMAIL_JTF_FM_GROUPS.SERVER_ID |
% |
JTF_FM_EMAIL_JTF_FM_GROUPS.GROUP_ID | % |
JTF_FM_EMAIL_JTF_FM_GROUPS.OUTPUT_ID
JTF_FM_EMAIL_JTF_FM_GROUPS.OUTPUT_TYPE JTF_FM_EMAIL_JTF_FM_GROUPS.DISPATCHER_ID JTF_FM_EMAIL_JTF_FM_GROUPS.SERVER_ID |
JTF_FM_EMAIL |
JTF_FM_EMAIL_JTF_FM_GROUPS.GROUP_ID | JTF_FM_GROUPS_ALL |
JTF.JTF_FM_EMAIL_JTF_FM_GROUPS does not reference any database object
JTF.JTF_FM_EMAIL_JTF_FM_GROUPS is referenced by following:
Description: | Table to hold statistical information on Emails sent out by Fulfillment Server. |
---|
JTF.JTF_FM_EMAIL_STATS does not reference any database object
JTF.JTF_FM_EMAIL_STATS is referenced by following:
Description: | Stores information about Fulfillment fax servers |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_FM_FAX.DISPATCHER_ID
JTF_FM_FAX.SERVER_ID |
JTF_FM_DISPATCHERS |
Foreign Key Column | Foreign Table |
---|---|
JTF_FM_FAX_JTF_FM_GROUPS.OUTPUT_ID
JTF_FM_FAX_JTF_FM_GROUPS.OUTPUT_TYPE JTF_FM_FAX_JTF_FM_GROUPS.DISPATCHER_ID JTF_FM_FAX_JTF_FM_GROUPS.SERVER_ID |
JTF_FM_FAX |
JTF_FM_FAX_JTF_FM_GROUPS.OUTPUT_ID
JTF_FM_FAX_JTF_FM_GROUPS.OUTPUT_TYPE JTF_FM_FAX_JTF_FM_GROUPS.DISPATCHER_ID JTF_FM_FAX_JTF_FM_GROUPS.SERVER_ID |
JTF_FM_FAX |
JTF.JTF_FM_FAX does not reference any database object
JTF.JTF_FM_FAX is referenced by following:
Description: | Stores cross reference info about fax servers and groups |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_FM_FAX_JTF_FM_GROUPS.OUTPUT_ID
JTF_FM_FAX_JTF_FM_GROUPS.OUTPUT_TYPE JTF_FM_FAX_JTF_FM_GROUPS.DISPATCHER_ID JTF_FM_FAX_JTF_FM_GROUPS.SERVER_ID |
JTF_FM_FAX |
JTF_FM_FAX_JTF_FM_GROUPS.GROUP_ID | JTF_FM_GROUPS_ALL |
JTF_FM_FAX_JTF_FM_GROUPS.OUTPUT_ID
JTF_FM_FAX_JTF_FM_GROUPS.OUTPUT_TYPE JTF_FM_FAX_JTF_FM_GROUPS.DISPATCHER_ID JTF_FM_FAX_JTF_FM_GROUPS.SERVER_ID |
JTF_FM_FAX |
JTF_FM_FAX_JTF_FM_GROUPS.GROUP_ID | JTF_FM_GROUPS_ALL |
JTF.JTF_FM_FAX_JTF_FM_GROUPS does not reference any database object
JTF.JTF_FM_FAX_JTF_FM_GROUPS is referenced by following:
Description: | Stores information about batch files |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_FM_FILE.DISPATCHER_ID
JTF_FM_FILE.SERVER_ID |
JTF_FM_DISPATCHERS |
Foreign Key Column | Foreign Table |
---|---|
JTF_FM_FILE_JTF_FM_GROUPS.OUTPUT_ID
JTF_FM_FILE_JTF_FM_GROUPS.OUTPUT_TYPE JTF_FM_FILE_JTF_FM_GROUPS.DISPATCHER_ID JTF_FM_FILE_JTF_FM_GROUPS.SERVER_ID |
JTF_FM_FILE |
JTF.JTF_FM_FILE does not reference any database object
JTF.JTF_FM_FILE is referenced by following:
Description: | Stores cross reference info about batch files and groups |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_FM_FILE_JTF_FM_GROUPS.OUTPUT_ID
JTF_FM_FILE_JTF_FM_GROUPS.OUTPUT_TYPE JTF_FM_FILE_JTF_FM_GROUPS.DISPATCHER_ID JTF_FM_FILE_JTF_FM_GROUPS.SERVER_ID |
% |
JTF_FM_FILE_JTF_FM_GROUPS.GROUP_ID | % |
JTF_FM_FILE_JTF_FM_GROUPS.OUTPUT_ID
JTF_FM_FILE_JTF_FM_GROUPS.OUTPUT_TYPE JTF_FM_FILE_JTF_FM_GROUPS.DISPATCHER_ID JTF_FM_FILE_JTF_FM_GROUPS.SERVER_ID |
JTF_FM_FILE |
JTF_FM_FILE_JTF_FM_GROUPS.GROUP_ID | JTF_FM_GROUPS_ALL |
JTF.JTF_FM_FILE_JTF_FM_GROUPS does not reference any database object
JTF.JTF_FM_FILE_JTF_FM_GROUPS is referenced by following:
Description: | Stores info about fulfillment groups |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_FM_EMAIL_JTF_FM_GROUPS.GROUP_ID | JTF_FM_GROUPS_ALL |
JTF_FM_FAX_JTF_FM_GROUPS.GROUP_ID | JTF_FM_GROUPS_ALL |
JTF_FM_FAX_JTF_FM_GROUPS.GROUP_ID | JTF_FM_GROUPS_ALL |
JTF_FM_FILE_JTF_FM_GROUPS.GROUP_ID | JTF_FM_GROUPS_ALL |
JTF_FM_GROUP_FND_USER.GROUP_ID | JTF_FM_GROUPS_ALL |
JTF_FM_PRINTER_JTF_FM_GROUPS.GROUP_ID | JTF_FM_GROUPS_ALL |
JTF_FM_PRINTER_JTF_FM_GROUPS.GROUP_ID | JTF_FM_GROUPS_ALL |
JTF.JTF_FM_GROUPS_ALL does not reference any database object
JTF.JTF_FM_GROUPS_ALL is referenced by following:
Description: | Stores cross reference info between groups and agents |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_FM_GROUP_FND_USER.GROUP_ID | JTF_FM_GROUPS_ALL |
JTF_FM_GROUP_FND_USER.USER_ID | FND_USER |
JTF_FM_GROUP_FND_USER.GROUP_ID | % |
JTF_FM_GROUP_FND_USER.USER_ID | FND_USER |
JTF.JTF_FM_GROUP_FND_USER does not reference any database object
JTF.JTF_FM_GROUP_FND_USER is referenced by following:
Description: | Table to hold the data for request in progress. This table stores the batches and line ID range for every request inserted into the table JTF_FM_INT_REQUEST_LINES. |
---|
JTF.JTF_FM_INT_REQUEST_BATCHES does not reference any database object
JTF.JTF_FM_INT_REQUEST_BATCHES is referenced by following:
Description: | Table to hold the data for request in progress. This table stores the header level details about the request. |
---|
JTF.JTF_FM_INT_REQUEST_HEADER does not reference any database object
JTF.JTF_FM_INT_REQUEST_HEADER is referenced by following:
Description: | Table for storing Migration Information |
---|
JTF.JTF_FM_MIGRATION_HISTORY does not reference any database object
JTF.JTF_FM_MIGRATION_HISTORY is referenced by following:
Description: | Table to Store Details of Migration. |
---|
JTF.JTF_FM_MIG_HISTORY_DETAILS does not reference any database object
JTF.JTF_FM_MIG_HISTORY_DETAILS is referenced by following:
Description: | This table will be used to store the list of all partitions that will be pooled among FFM requests |
---|
JTF.JTF_FM_PARTITION_X_REQUEST does not reference any database object
JTF.JTF_FM_PARTITION_X_REQUEST is referenced by following:
Description: | Table to hold temporary placement of Fulfillment Content to be previewed and then either submitted for dispatch or deleted |
---|
JTF.JTF_FM_PREVIEWS does not reference any database object
JTF.JTF_FM_PREVIEWS is referenced by following:
Description: | Stores information about Fulfillment printers |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_FM_PRINTER.DISPATCHER_ID
JTF_FM_PRINTER.SERVER_ID |
JTF_FM_DISPATCHERS |
JTF_FM_PRINTER.PRINT_SERVER_ID | JTF_FM_PRINT_SERVERS |
Foreign Key Column | Foreign Table |
---|---|
JTF_FM_PRINTER_JTF_FM_GROUPS.OUTPUT_ID
JTF_FM_PRINTER_JTF_FM_GROUPS.OUTPUT_TYPE JTF_FM_PRINTER_JTF_FM_GROUPS.DISPATCHER_ID JTF_FM_PRINTER_JTF_FM_GROUPS.SERVER_ID |
JTF_FM_PRINTER |
JTF_FM_PRINTER_JTF_FM_GROUPS.OUTPUT_ID
JTF_FM_PRINTER_JTF_FM_GROUPS.OUTPUT_TYPE JTF_FM_PRINTER_JTF_FM_GROUPS.DISPATCHER_ID JTF_FM_PRINTER_JTF_FM_GROUPS.SERVER_ID |
JTF_FM_PRINTER |
JTF.JTF_FM_PRINTER does not reference any database object
JTF.JTF_FM_PRINTER is referenced by following:
Description: | Table to store the Printers available. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_FM_PRINTERS.PRINT_SERVER_ID | JTF_FM_PRINT_SERVERS |
JTF.JTF_FM_PRINTERS does not reference any database object
JTF.JTF_FM_PRINTERS is referenced by following:
Description: | Stores cross reference info about printers and groups |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_FM_PRINTER_JTF_FM_GROUPS.OUTPUT_ID
JTF_FM_PRINTER_JTF_FM_GROUPS.OUTPUT_TYPE JTF_FM_PRINTER_JTF_FM_GROUPS.DISPATCHER_ID JTF_FM_PRINTER_JTF_FM_GROUPS.SERVER_ID |
JTF_FM_PRINTER |
JTF_FM_PRINTER_JTF_FM_GROUPS.GROUP_ID | JTF_FM_GROUPS_ALL |
JTF_FM_PRINTER_JTF_FM_GROUPS.OUTPUT_ID
JTF_FM_PRINTER_JTF_FM_GROUPS.OUTPUT_TYPE JTF_FM_PRINTER_JTF_FM_GROUPS.DISPATCHER_ID JTF_FM_PRINTER_JTF_FM_GROUPS.SERVER_ID |
JTF_FM_PRINTER |
JTF_FM_PRINTER_JTF_FM_GROUPS.GROUP_ID | JTF_FM_GROUPS_ALL |
JTF.JTF_FM_PRINTER_JTF_FM_GROUPS does not reference any database object
JTF.JTF_FM_PRINTER_JTF_FM_GROUPS is referenced by following:
Description: | Table to Store the Print Servers |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_FM_PRINTERS.PRINT_SERVER_ID | JTF_FM_PRINT_SERVERS |
JTF_FM_PRINTER.PRINT_SERVER_ID | JTF_FM_PRINT_SERVERS |
JTF.JTF_FM_PRINT_SERVERS does not reference any database object
JTF.JTF_FM_PRINT_SERVERS is referenced by following:
Description: | Table that stores information all the requests that have been processed |
---|
JTF.JTF_FM_PROCESSED does not reference any database object
JTF.JTF_FM_PROCESSED is referenced by following:
Description: | This table stores information about the fulfillment queries |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_FM_QUERY_MES.QUERY_ID | JTF_FM_QUERIES_ALL |
JTF.JTF_FM_QUERIES_ALL does not reference any database object
JTF.JTF_FM_QUERIES_ALL is referenced by following:
Description: | Cross reference entity to store query and master document association |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_FM_QUERY_MES.QUERY_ID | JTF_FM_QUERIES_ALL |
JTF.JTF_FM_QUERY_MES does not reference any database object
JTF.JTF_FM_QUERY_MES is referenced by following:
Description: | Table that is used internally by the Fulfillment Server to store information about the Queues in which requests are placed. |
---|
JTF.JTF_FM_REQUESTS_AQ does not reference any database object
JTF.JTF_FM_REQUESTS_AQ is referenced by following:
Description: | Table to hold details on the contents within the request. |
---|
JTF.JTF_FM_REQUEST_CONTENTS does not reference any database object
JTF.JTF_FM_REQUEST_CONTENTS is referenced by following:
Description: | Stores request history information |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_FM_CONTENT_HISTORY.HIST_REQ_ID
JTF_FM_CONTENT_HISTORY.SUBMIT_DT_TM |
JTF_FM_REQUEST_HISTORY_ALL |
JTF.JTF_FM_REQUEST_HISTORY_ALL does not reference any database object
JTF.JTF_FM_REQUEST_HISTORY_ALL is referenced by following:
Description: | Table to hold information about the resubmitted requests. |
---|
JTF.JTF_FM_RESUBMITTED does not reference any database object
JTF.JTF_FM_RESUBMITTED is referenced by following:
Description: | Result table to store HTML output from Intermedia cartridge. |
---|
JTF.JTF_FM_RESULT_TAB_ALL does not reference any database object
JTF.JTF_FM_RESULT_TAB_ALL is referenced by following:
Description: | This table stores information about the fulfillment servers |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_FM_DISPATCHERS.SERVER_ID | JTF_FM_SERVICE_ALL |
JTF_FM_DISPATCHERS.SERVER_ID | JTF_FM_SERVICE_ALL |
JTF.JTF_FM_SERVICE_ALL does not reference any database object
JTF.JTF_FM_SERVICE_ALL is referenced by following:
Description: | Table to Store information on all the servers that were ever used in any environment |
---|
JTF.JTF_FM_SERVICE_MONITOR does not reference any database object
JTF.JTF_FM_SERVICE_MONITOR is referenced by following:
Description: | This table stores information about the fulfillment status for requests. |
---|
JTF.JTF_FM_STATUS_ALL does not reference any database object
JTF.JTF_FM_STATUS_ALL is referenced by following:
Description: | This table stores information about the fulfillment templates |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_FM_TEMPLATE_CONTENTS.TEMPLATE_ID | JTF_FM_TEMPLATE_ALL |
JTF.JTF_FM_TEMPLATE_ALL does not reference any database object
JTF.JTF_FM_TEMPLATE_ALL is referenced by following:
Description: | Stores cross reference information between the fulfillment templates and contents. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_FM_TEMPLATE_CONTENTS.TEMPLATE_ID | % |
JTF_FM_TEMPLATE_CONTENTS.TEMPLATE_ID | JTF_FM_TEMPLATE_ALL |
JTF.JTF_FM_TEMPLATE_CONTENTS does not reference any database object
JTF.JTF_FM_TEMPLATE_CONTENTS is referenced by following:
Description: | This table stores the log details for the test submitted through the test harness |
---|
JTF.JTF_FM_TESTTOOL_TEST_DETAILS does not reference any database object
JTF.JTF_FM_TESTTOOL_TEST_DETAILS is referenced by following:
Description: | this is a table where the request id for TEST requests is held temporarily |
---|
JTF.JTF_FM_TEST_REQUESTS does not reference any database object
JTF.JTF_FM_TEST_REQUESTS is referenced by following:
Description: | Meta Data information for each column defined for a spreadtable UI component. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_GRID_COLS_B.GRID_DATASOURCE_NAME | JTF_GRID_DATASOURCES_B |
JTF_GRID_COLS_B.VALIDATION_OBJECT_CODE | JTF_OBJECTS_B |
Foreign Key Column | Foreign Table |
---|---|
JTF_CUSTOM_GRIDS.GRID_DATASOURCE_NAME
JTF_CUSTOM_GRIDS.GRID_SORT_COL_ALIAS1 |
JTF_GRID_COLS_B |
JTF_CUSTOM_GRIDS.GRID_DATASOURCE_NAME
JTF_CUSTOM_GRIDS.GRID_SORT_COL_ALIAS2 |
JTF_GRID_COLS_B |
JTF_CUSTOM_GRIDS.GRID_DATASOURCE_NAME
JTF_CUSTOM_GRIDS.GRID_SORT_COL_ALIAS3 |
JTF_GRID_COLS_B |
JTF_CUSTOM_GRID_COLS.GRID_DATASOURCE_NAME
JTF_CUSTOM_GRID_COLS.GRID_COL_ALIAS |
JTF_GRID_COLS_B |
JTF_GRID_COLS_TL.GRID_DATASOURCE_NAME
JTF_GRID_COLS_TL.GRID_COL_ALIAS |
JTF_GRID_COLS_B |
JTF_GRID_SORT_COLS.GRID_DATASOURCE_NAME
JTF_GRID_SORT_COLS.GRID_SORT_COL_ALIAS1 |
JTF_GRID_COLS_B |
JTF_GRID_SORT_COLS.GRID_DATASOURCE_NAME
JTF_GRID_SORT_COLS.GRID_SORT_COL_ALIAS2 |
JTF_GRID_COLS_B |
JTF_GRID_SORT_COLS.GRID_DATASOURCE_NAME
JTF_GRID_SORT_COLS.GRID_SORT_COL_ALIAS3 |
JTF_GRID_COLS_B |
JTF.JTF_GRID_COLS_B does not reference any database object
JTF.JTF_GRID_COLS_B is referenced by following:
Description: | Translation table for JTF_GRID_COLS_B |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_GRID_COLS_TL.GRID_DATASOURCE_NAME
JTF_GRID_COLS_TL.GRID_COL_ALIAS |
JTF_GRID_COLS_B |
JTF.JTF_GRID_COLS_TL does not reference any database object
JTF.JTF_GRID_COLS_TL is referenced by following:
Description: | Meta Data definitions that are used to initialize and set up a a spreadtable UI component. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_GRID_DATASOURCES_B.APPLICATION_ID | FND_APPLICATION |
Foreign Key Column | Foreign Table |
---|---|
IEU_UWQ_NODE_DS.DATASOURCE_NAME | JTF_GRID_DATASOURCES_B |
JTF_CUSTOM_GRIDS.GRID_DATASOURCE_NAME | JTF_GRID_DATASOURCES_B |
JTF_DEF_CUSTOM_GRIDS.GRID_DATASOURCE_NAME | JTF_GRID_DATASOURCES_B |
JTF_GRID_COLS_B.GRID_DATASOURCE_NAME | JTF_GRID_DATASOURCES_B |
JTF_GRID_DATASOURCES_TL.GRID_DATASOURCE_NAME | JTF_GRID_DATASOURCES_B |
JTF_GRID_SORT_COLS.GRID_DATASOURCE_NAME | JTF_GRID_DATASOURCES_B |
JTF.JTF_GRID_DATASOURCES_B does not reference any database object
JTF.JTF_GRID_DATASOURCES_B is referenced by following:
Description: | Translation table for JTF_GRID_DATASOURCES_B |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_GRID_DATASOURCES_TL.GRID_DATASOURCE_NAME | JTF_GRID_DATASOURCES_B |
JTF.JTF_GRID_DATASOURCES_TL does not reference any database object
JTF.JTF_GRID_DATASOURCES_TL is referenced by following:
Description: | The default columns and priority of the columns for the current set of meta data, used for sorting the data displayed in a spreadtable UI component. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_GRID_SORT_COLS.GRID_DATASOURCE_NAME | JTF_GRID_DATASOURCES_B |
JTF_GRID_SORT_COLS.GRID_DATASOURCE_NAME
JTF_GRID_SORT_COLS.GRID_SORT_COL_ALIAS1 |
JTF_GRID_COLS_B |
JTF_GRID_SORT_COLS.GRID_DATASOURCE_NAME
JTF_GRID_SORT_COLS.GRID_SORT_COL_ALIAS2 |
JTF_GRID_COLS_B |
JTF_GRID_SORT_COLS.GRID_DATASOURCE_NAME
JTF_GRID_SORT_COLS.GRID_SORT_COL_ALIAS3 |
JTF_GRID_COLS_B |
JTF.JTF_GRID_SORT_COLS does not reference any database object
JTF.JTF_GRID_SORT_COLS is referenced by following:
Description: |
---|
JTF.JTF_HEADER_DTD does not reference any database object
JTF.JTF_HEADER_DTD is referenced by following:
Description: | Table the stores all the internal hooks call out. |
---|
JTF.JTF_HOOKS_DATA does not reference any database object
JTF.JTF_HOOKS_DATA is referenced by following:
Description: | Table holds app family names for the inter-app navigation framework. Base table. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_IAPP_FAMILIES_TL.APP_FAMILY_ID | JTF_IAPP_FAMILIES_B |
JTF_IAPP_FAMILY_USR_MAP.APP_FAMILY_ID | JTF_IAPP_FAMILIES_B |
JTF.JTF_IAPP_FAMILIES_B does not reference any database object
JTF.JTF_IAPP_FAMILIES_B is referenced by following:
Description: | Table holds app family names for the inter-app navigation framework. Translated table. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_IAPP_FAMILIES_TL.APP_FAMILY_ID | JTF_IAPP_FAMILIES_B |
JTF.JTF_IAPP_FAMILIES_TL does not reference any database object
JTF.JTF_IAPP_FAMILIES_TL is referenced by following:
Description: | Table holds app to family mapping for the inter-app navigation framework. |
---|
JTF.JTF_IAPP_FAMILY_APP_MAP does not reference any database object
JTF.JTF_IAPP_FAMILY_APP_MAP is referenced by following:
Description: | Table holds user, responsibility, app family mapping for the inter-app navigation framework. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_IAPP_FAMILY_USR_MAP.APP_FAMILY_ID | JTF_IAPP_FAMILIES_B |
JTF.JTF_IAPP_FAMILY_USR_MAP does not reference any database object
JTF.JTF_IAPP_FAMILY_USR_MAP is referenced by following:
Description: | An act that can occur upon an Action Item. Examples: Add, Update, Delete, Inquiry. |
---|
Foreign Key Column | Foreign Table |
---|---|
AML_BUSINESS_EVENT_TYPES_B.ACTION_ID | JTF_IH_ACTIONS_B |
JTF_IH_ACTIONS_TL.ACTION_ID | JTF_IH_ACTIONS_B |
JTF_IH_ACTION_ACTION_ITEMS.ACTION_ID | JTF_IH_ACTIONS_B |
JTF_IH_ACTIVITIES.ACTION_ID | JTF_IH_ACTIONS_B |
JTF.JTF_IH_ACTIONS_B does not reference any database object
JTF.JTF_IH_ACTIONS_B is referenced by following:
Description: | Translation table for Actions. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_ACTIONS_TL.ACTION_ID | JTF_IH_ACTIONS_B |
JTF.JTF_IH_ACTIONS_TL does not reference any database object
JTF.JTF_IH_ACTIONS_TL is referenced by following:
Description: | Intersction table for a valid set of Action Items and Actions. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_ACTION_ACTION_ITEMS.ACTION_ITEM_ID | JTF_IH_ACTION_ITEMS_B |
JTF_IH_ACTION_ACTION_ITEMS.ACTION_ID | JTF_IH_ACTIONS_B |
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_TRACKING_LISTS.ACTION_ACTION_ITEM_ID | JTF_IH_ACTION_ACTION_ITEMS |
JTF.JTF_IH_ACTION_ACTION_ITEMS does not reference any database object
JTF.JTF_IH_ACTION_ACTION_ITEMS is referenced by following:
Description: | An item upon which an act can occur. Example: Order, Quote, Service Request, E-Mail, Phone Call. |
---|
Foreign Key Column | Foreign Table |
---|---|
AML_BUSINESS_EVENT_TYPES_B.ACTION_ITEM_ID | JTF_IH_ACTION_ITEMS_B |
JTF_IH_ACTION_ACTION_ITEMS.ACTION_ITEM_ID | JTF_IH_ACTION_ITEMS_B |
JTF_IH_ACTION_ITEMS_TL.ACTION_ITEM_ID | JTF_IH_ACTION_ITEMS_B |
JTF_IH_ACTIVITIES.ACTION_ITEM_ID | JTF_IH_ACTION_ITEMS_B |
JTF.JTF_IH_ACTION_ITEMS_B does not reference any database object
JTF.JTF_IH_ACTION_ITEMS_B is referenced by following:
Description: | Translation table for Action Items. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_ACTION_ITEMS_TL.ACTION_ITEM_ID | JTF_IH_ACTION_ITEMS_B |
JTF.JTF_IH_ACTION_ITEMS_TL does not reference any database object
JTF.JTF_IH_ACTION_ITEMS_TL is referenced by following:
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 |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_ACTIVITIES.ACTION_ID | JTF_IH_ACTIONS_B |
JTF_IH_ACTIVITIES.SOURCE_CODE_ID | AMS_SOURCE_CODES |
JTF_IH_ACTIVITIES.TASK_ID | JTF_TASKS_B |
JTF_IH_ACTIVITIES.CUST_ACCOUNT_ID | HZ_CUST_ACCOUNTS |
JTF_IH_ACTIVITIES.ACTION_ITEM_ID | JTF_IH_ACTION_ITEMS_B |
JTF_IH_ACTIVITIES.DOC_REF | JTF_OBJECTS_B |
JTF_IH_ACTIVITIES.INTERACTION_ID | JTF_IH_INTERACTIONS |
JTF_IH_ACTIVITIES.MEDIA_ID | JTF_IH_MEDIA_ITEMS |
JTF_IH_ACTIVITIES.OUTCOME_ID | JTF_IH_OUTCOMES_B |
JTF_IH_ACTIVITIES.REASON_ID | JTF_IH_REASONS_B |
JTF_IH_ACTIVITIES.RESULT_ID | JTF_IH_RESULTS_B |
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_WRAP_UPS.ACTION_ACTIVITY_ID | JTF_IH_ACTIVITIES |
JTF.JTF_IH_ACTIVITIES does not reference any database object
JTF.JTF_IH_ACTIVITIES is referenced by following:
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 |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_ACTIVITIES_STG.MEDIA_ID | JTF_IH_MEDIA_ITEMS_STG |
JTF_IH_ACTIVITIES_STG.INTERACTION_ID | JTF_IH_INTERACTIONS_STG |
JTF.JTF_IH_ACTIVITIES_STG does not reference any database object
JTF.JTF_IH_ACTIVITIES_STG is referenced by following:
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 |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_ACTIVITIES_STG_LOG.CUST_ACCOUNT_PARTY_ID | HZ_PARTIES |
JTF.JTF_IH_ACTIVITIES_STG_LOG does not reference any database object
JTF.JTF_IH_ACTIVITIES_STG_LOG is referenced by following:
Description: | JTF_IH_BUILK_ERRORS table required to hold data about the errors encountered while attemting to create Interaction records from builk requests. |
---|
JTF.JTF_IH_BULK_ERRORS does not reference any database object
JTF.JTF_IH_BULK_ERRORS is referenced by following:
Description: | Interaction History Bilk Recovery Table |
---|
JTF.JTF_IH_BULK_RECOVERY does not reference any database object
JTF.JTF_IH_BULK_RECOVERY is referenced by following:
Description: | This table is an intersection table between Results and Oracle Campaign. Pairing a set of Results to a specific Campaign. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_CAMPAIGNS_RESULTS.SOURCE_CODE_ID | AMS_SOURCE_CODES |
JTF_IH_CAMPAIGNS_RESULTS.RESULT_ID | JTF_IH_RESULTS_B |
JTF.JTF_IH_CAMPAIGNS_RESULTS does not reference any database object
JTF.JTF_IH_CAMPAIGNS_RESULTS is referenced by following:
Description: | Intersection table that pairs a RESULT-REASON for a Specific Oracle Marketing Campaign. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_CAMPAIGN_RESULT_REASONS.SOURCE_CODE_ID | AMS_SOURCE_CODES |
JTF_IH_CAMPAIGN_RESULT_REASONS.REASON_ID | JTF_IH_REASONS_B |
JTF_IH_CAMPAIGN_RESULT_REASONS.RESULT_ID | JTF_IH_RESULTS_B |
JTF.JTF_IH_CAMPAIGN_RESULT_REASONS does not reference any database object
JTF.JTF_IH_CAMPAIGN_RESULT_REASONS is referenced by following:
Description: | A business entity that can be created, updated or queried during the process of an interaction . Individual document types are defined in other CRM/ERP schemas. |
---|
JTF.JTF_IH_DOCUMENTS does not reference any database object
JTF.JTF_IH_DOCUMENTS is referenced by following:
Description: | A contact point between a customer, customer system or potential customer and a single human or automated agent (Handler and Handler Resource). An Interaction can be timed and has an outcome and result that can be tracked. Multiple Intera |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_INTERACTIONS.PARTY_ID | HZ_PARTIES |
JTF_IH_INTERACTIONS.OUTCOME_ID | JTF_IH_OUTCOMES_B |
JTF_IH_INTERACTIONS.REASON_ID | JTF_IH_REASONS_B |
JTF_IH_INTERACTIONS.RESULT_ID | JTF_IH_RESULTS_B |
JTF_IH_INTERACTIONS.SCRIPT_ID | JTF_IH_SCRIPTS |
JTF_IH_INTERACTIONS.SOURCE_CODE_ID | AMS_SOURCE_CODES |
JTF_IH_INTERACTIONS.HANDLER_ID | FND_APPLICATION |
JTF_IH_INTERACTIONS.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF_IH_INTERACTIONS.INTERACTION_INTERS_ID | JTF_IH_INTERACTION_INTERS |
Foreign Key Column | Foreign Table |
---|---|
AML_INTERACTION_LEADS.INTERACTION_ID | JTF_IH_INTERACTIONS |
JTF_IH_ACTIVITIES.INTERACTION_ID | JTF_IH_INTERACTIONS |
JTF_IH_INTERACTIONS_CAMPAIGNS.INTERACTION_ID | JTF_IH_INTERACTIONS |
JTF_IH_INTERACTION_INTERS.INTERACT_INTERACTION_ID | JTF_IH_INTERACTIONS |
JTF_IH_INTERACTION_INTERS.INTERACT_INTERACTION_IDRELATES | JTF_IH_INTERACTIONS |
JTF.JTF_IH_INTERACTIONS does not reference any database object
JTF.JTF_IH_INTERACTIONS is referenced by following:
Description: | This table is an intersection table between INTERACTIONS and CAMPAIGNS. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_INTERACTIONS_CAMPAIGNS.SOURCE_CODE_ID | AMS_SOURCE_CODES |
JTF_IH_INTERACTIONS_CAMPAIGNS.INTERACTION_ID | JTF_IH_INTERACTIONS |
JTF.JTF_IH_INTERACTIONS_CAMPAIGNS does not reference any database object
JTF.JTF_IH_INTERACTIONS_CAMPAIGNS is referenced by following:
Description: | A contact point between a customer, customer system or potential customer and a single human or automated agent (Handler and Handler Resource). An Interaction can be timed and has an outcome and result that can be tracked. Multiple Intera |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_INTERACTIONS_STG.PARTY_ID | HZ_PARTIES |
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_ACTIVITIES_STG.INTERACTION_ID | JTF_IH_INTERACTIONS_STG |
JTF.JTF_IH_INTERACTIONS_STG does not reference any database object
JTF.JTF_IH_INTERACTIONS_STG is referenced by following:
Description: | A contact point between a customer, customer system or potential customer and a single human or automated agent (Handler and Handler Resource). An Interaction can be timed and has an outcome and result that can be tracked. Multiple Intera |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_INTERACTIONS_STG_LOG.PARTY_ID | HZ_PARTIES |
JTF.JTF_IH_INTERACTIONS_STG_LOG does not reference any database object
JTF.JTF_IH_INTERACTIONS_STG_LOG is referenced by following:
Description: | Groups multiple interactions within the system. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_INTERACTION_INTERS.INTERACT_INTERACTION_ID | JTF_IH_INTERACTIONS |
JTF_IH_INTERACTION_INTERS.INTERACT_INTERACTION_IDRELATES | JTF_IH_INTERACTIONS |
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_INTERACTIONS.INTERACTION_INTERS_ID | JTF_IH_INTERACTION_INTERS |
JTF.JTF_IH_INTERACTION_INTERS does not reference any database object
JTF.JTF_IH_INTERACTION_INTERS is referenced by following:
Description: | An instance of media that was processed by the system and/or its users. Media Items can be generated by a customer or by the system or an application. Media Items can be inbound (ex. Mail or call from a customer/person ) or outbound (ex. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_MEDIA_ITEMS.SOURCE_ID | JTF_IH_SOURCES |
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_ACTIVITIES.MEDIA_ID | JTF_IH_MEDIA_ITEMS |
JTF_IH_MEDIA_ITEM_LC_SEGS.MEDIA_ID | JTF_IH_MEDIA_ITEMS |
JTF.JTF_IH_MEDIA_ITEMS does not reference any database object
JTF.JTF_IH_MEDIA_ITEMS is referenced by following:
Description: | An instance of media that was processed by the system and/or its users. Media Items can be generated by a customer or by the system or an application. Media Items can be inbound (ex. Mail or call from a customer/person ) or outbound (ex. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_ACTIVITIES_STG.MEDIA_ID | JTF_IH_MEDIA_ITEMS_STG |
JTF.JTF_IH_MEDIA_ITEMS_STG does not reference any database object
JTF.JTF_IH_MEDIA_ITEMS_STG is referenced by following:
Description: | An instance of media that was processed by the system and/or its users. Media Items can be generated by a customer or by the system or an application. Media Items can be inbound (ex. Mail or call from a customer/person ) or outbound (ex. |
---|
JTF.JTF_IH_MEDIA_ITEMS_STG_LOG does not reference any database object
JTF.JTF_IH_MEDIA_ITEMS_STG_LOG is referenced by following:
Description: | An interval in the life of a Media Item within the system. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_MEDIA_ITEM_LC_SEGS.HANDLER_ID | FND_APPLICATION |
JTF_IH_MEDIA_ITEM_LC_SEGS.MEDIA_ID | JTF_IH_MEDIA_ITEMS |
JTF_IH_MEDIA_ITEM_LC_SEGS.MILCS_TYPE_ID | JTF_IH_MEDIA_ITM_LC_SEG_TYS |
JTF.JTF_IH_MEDIA_ITEM_LC_SEGS does not reference any database object
JTF.JTF_IH_MEDIA_ITEM_LC_SEGS is referenced by following:
Description: | The descriptor of a Media Lifecycle Segment. It can denote the system or activity to which the interval of time is attributed. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_MEDIA_ITEM_LC_SEGS.MILCS_TYPE_ID | JTF_IH_MEDIA_ITM_LC_SEG_TYS |
JTF.JTF_IH_MEDIA_ITM_LC_SEG_TYS does not reference any database object
JTF.JTF_IH_MEDIA_ITM_LC_SEG_TYS is referenced by following:
Description: | The outcome of an interaction. Example: Contact. Busy. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_ACTIVITIES.OUTCOME_ID | JTF_IH_OUTCOMES_B |
JTF_IH_INTERACTIONS.OUTCOME_ID | JTF_IH_OUTCOMES_B |
JTF_IH_OUTCOMES_CAMPAIGNS.OUTCOME_ID | JTF_IH_OUTCOMES_B |
JTF_IH_OUTCOMES_TL.OUTCOME_ID | JTF_IH_OUTCOMES_B |
JTF_IH_OUTCOME_RESULTS.OUTCOME_ID | JTF_IH_OUTCOMES_B |
JTF_IH_WRAP_UPS.OUTCOME_ID | JTF_IH_OUTCOMES_B |
JTF.JTF_IH_OUTCOMES_B does not reference any database object
JTF.JTF_IH_OUTCOMES_B is referenced by following:
Description: | Intersection table pairing Outcomes for specific Oracle Campaigns. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_OUTCOMES_CAMPAIGNS.OUTCOME_ID | JTF_IH_OUTCOMES_B |
JTF_IH_OUTCOMES_CAMPAIGNS.SOURCE_CODE_ID | AMS_SOURCE_CODES |
JTF.JTF_IH_OUTCOMES_CAMPAIGNS does not reference any database object
JTF.JTF_IH_OUTCOMES_CAMPAIGNS is referenced by following:
Description: | Translation table for Outcomes. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_OUTCOMES_TL.OUTCOME_ID | JTF_IH_OUTCOMES_B |
JTF.JTF_IH_OUTCOMES_TL does not reference any database object
JTF.JTF_IH_OUTCOMES_TL is referenced by following:
Description: | The valid combination of results for an Outcome. This table represents an intersection between JTF_IH_OUTCOMES and JTF_IH_RESULTS tables. The following is a list of the table columns |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_OUTCOME_RESULTS.OUTCOME_ID | JTF_IH_OUTCOMES_B |
JTF_IH_OUTCOME_RESULTS.RESULT_ID | JTF_IH_RESULTS_B |
JTF.JTF_IH_OUTCOME_RESULTS does not reference any database object
JTF.JTF_IH_OUTCOME_RESULTS is referenced by following:
Description: | A reason for the result of an interaction or an activity. Example: The reason the interaction resulted in a no-sale was that the customer thought the product was too expensive. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_ACTIVITIES.REASON_ID | JTF_IH_REASONS_B |
JTF_IH_CAMPAIGN_RESULT_REASONS.REASON_ID | JTF_IH_REASONS_B |
JTF_IH_INTERACTIONS.REASON_ID | JTF_IH_REASONS_B |
JTF_IH_REASONS_TL.REASON_ID | JTF_IH_REASONS_B |
JTF_IH_RESULT_REASONS.REASON_ID | JTF_IH_REASONS_B |
JTF_IH_WRAP_UPS.REASON_ID | JTF_IH_REASONS_B |
JTF.JTF_IH_REASONS_B does not reference any database object
JTF.JTF_IH_REASONS_B is referenced by following:
Description: | Translation table for Reason. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_REASONS_TL.REASON_ID | JTF_IH_REASONS_B |
JTF.JTF_IH_REASONS_TL does not reference any database object
JTF.JTF_IH_REASONS_TL is referenced by following:
Description: | The result of an interaction or an activity. Example: The interaction resulted in a sale. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_ACTIVITIES.RESULT_ID | JTF_IH_RESULTS_B |
JTF_IH_CAMPAIGNS_RESULTS.RESULT_ID | JTF_IH_RESULTS_B |
JTF_IH_CAMPAIGN_RESULT_REASONS.RESULT_ID | JTF_IH_RESULTS_B |
JTF_IH_INTERACTIONS.RESULT_ID | JTF_IH_RESULTS_B |
JTF_IH_OUTCOME_RESULTS.RESULT_ID | JTF_IH_RESULTS_B |
JTF_IH_RESULTS_TL.RESULT_ID | JTF_IH_RESULTS_B |
JTF_IH_RESULT_REASONS.RESULT_ID | JTF_IH_RESULTS_B |
JTF_IH_WRAP_UPS.RESULT_ID | JTF_IH_RESULTS_B |
JTF.JTF_IH_RESULTS_B does not reference any database object
JTF.JTF_IH_RESULTS_B is referenced by following:
Description: | Translation table for Results. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_RESULTS_TL.RESULT_ID | JTF_IH_RESULTS_B |
JTF.JTF_IH_RESULTS_TL does not reference any database object
JTF.JTF_IH_RESULTS_TL is referenced by following:
Description: | The valid combination of reasons for a result. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_RESULT_REASONS.REASON_ID | JTF_IH_REASONS_B |
JTF_IH_RESULT_REASONS.RESULT_ID | JTF_IH_RESULTS_B |
JTF.JTF_IH_RESULT_REASONS does not reference any database object
JTF.JTF_IH_RESULT_REASONS is referenced by following:
Description: | Defined in the Call Center Schema for scripting. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_INTERACTIONS.SCRIPT_ID | JTF_IH_SCRIPTS |
JTF.JTF_IH_SCRIPTS does not reference any database object
JTF.JTF_IH_SCRIPTS is referenced by following:
Description: | The system from which a Media Item was received or through which a Media Item was generated. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_MEDIA_ITEMS.SOURCE_ID | JTF_IH_SOURCES |
JTF.JTF_IH_SOURCES does not reference any database object
JTF.JTF_IH_SOURCES is referenced by following:
Description: | This table is used by Oracle iMarketing for tracking web-clicks in the context of an Oracle Campaign. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_TRACKING_LISTS.ACTION_ACTION_ITEM_ID | JTF_IH_ACTION_ACTION_ITEMS |
JTF.JTF_IH_TRACKING_LISTS does not reference any database object
JTF.JTF_IH_TRACKING_LISTS is referenced by following:
Description: | This table identifies the information that has to be provided by the application inserting Interaction History records. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_IH_WRAP_UPS.SOURCE_CODE_ID | AMS_SOURCE_CODES |
JTF_IH_WRAP_UPS.OUTCOME_ID | JTF_IH_OUTCOMES_B |
JTF_IH_WRAP_UPS.REASON_ID | JTF_IH_REASONS_B |
JTF_IH_WRAP_UPS.RESULT_ID | JTF_IH_RESULTS_B |
JTF_IH_WRAP_UPS.ACTION_ACTIVITY_ID | JTF_IH_ACTIVITIES |
JTF_IH_WRAP_UPS.SOURCE_CODE | AMS_SOURCE_CODES |
JTF.JTF_IH_WRAP_UPS does not reference any database object
JTF.JTF_IH_WRAP_UPS is referenced by following:
Description: | A generic table to hold geographical location definitions that is not stored somewhere else in Oracle Applications. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_LOC_AREAS_B.LOCATION_TYPE_CODE | JTF_LOC_TYPES_B |
JTF_LOC_AREAS_B.PARENT_LOCATION_AREA_ID | JTF_LOC_AREAS_B |
Foreign Key Column | Foreign Table |
---|---|
JTF_LOC_AREAS_B.PARENT_LOCATION_AREA_ID | JTF_LOC_AREAS_B |
JTF_LOC_AREAS_TL.LOCATION_AREA_ID | JTF_LOC_AREAS_B |
JTF_LOC_HIERARCHIES_B.POSTAL_CODE_ID | JTF_LOC_AREAS_B |
JTF_LOC_HIERARCHIES_B.AREA1_ID | JTF_LOC_AREAS_B |
JTF_LOC_HIERARCHIES_B.AREA2_ID | JTF_LOC_AREAS_B |
JTF_LOC_HIERARCHIES_B.COUNTRY_ID | JTF_LOC_AREAS_B |
JTF_LOC_HIERARCHIES_B.STATE_ID | JTF_LOC_AREAS_B |
JTF_LOC_HIERARCHIES_B.COUNTRY_REGION_ID | JTF_LOC_AREAS_B |
JTF_LOC_HIERARCHIES_B.STATE_REGION_ID | JTF_LOC_AREAS_B |
JTF_LOC_HIERARCHIES_B.CITY_ID | JTF_LOC_AREAS_B |
JTF_LOC_POSTAL_CODES.LOCATION_AREA_ID | JTF_LOC_AREAS_B |
OKR_IP_RGTS_TXN_TERR.TERRITORY_ID | JTF_LOC_AREAS_B |
JTF.JTF_LOC_AREAS_B does not reference any database object
JTF.JTF_LOC_AREAS_B is referenced by following:
Description: | Stores columns that should be translated for a location area. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_LOC_AREAS_TL.LOCATION_AREA_ID | JTF_LOC_AREAS_B |
JTF.JTF_LOC_AREAS_TL does not reference any database object
JTF.JTF_LOC_AREAS_TL is referenced by following:
Description: | Stores a flattened out structure of all geographical information. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_LOC_HIERARCHIES_B.LOCATION_TYPE_CODE | JTF_LOC_TYPES_B |
JTF_LOC_HIERARCHIES_B.POSTAL_CODE_ID | JTF_LOC_AREAS_B |
JTF_LOC_HIERARCHIES_B.CREATED_BY_APPLICATION_ID | FND_APPLICATION |
JTF_LOC_HIERARCHIES_B.AREA1_ID | JTF_LOC_AREAS_B |
JTF_LOC_HIERARCHIES_B.AREA2_ID | JTF_LOC_AREAS_B |
JTF_LOC_HIERARCHIES_B.COUNTRY_ID | JTF_LOC_AREAS_B |
JTF_LOC_HIERARCHIES_B.STATE_ID | JTF_LOC_AREAS_B |
JTF_LOC_HIERARCHIES_B.COUNTRY_REGION_ID | JTF_LOC_AREAS_B |
JTF_LOC_HIERARCHIES_B.STATE_REGION_ID | JTF_LOC_AREAS_B |
JTF_LOC_HIERARCHIES_B.CITY_ID | JTF_LOC_AREAS_B |
Foreign Key Column | Foreign Table |
---|---|
AMS_ACT_GEO_AREAS.GEO_HIERARCHY_ID | JTF_LOC_HIERARCHIES_B |
AMS_CAMPAIGNS_ALL_B.CITY_ID | JTF_LOC_HIERARCHIES_B |
JTF.JTF_LOC_HIERARCHIES_B does not reference any database object
JTF.JTF_LOC_HIERARCHIES_B is referenced by following:
Description: | A generic table that stores range of postal code within a location area. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_LOC_POSTAL_CODES.LOCATION_AREA_ID | JTF_LOC_AREAS_B |
JTF.JTF_LOC_POSTAL_CODES does not reference any database object
JTF.JTF_LOC_POSTAL_CODES is referenced by following:
Description: | Stores location types, like CITY and STATE. |
---|
Foreign Key Column | Foreign Table |
---|---|
AMS_ACT_GEO_AREAS.GEO_AREA_TYPE_CODE | JTF_LOC_TYPES_B |
JTF_LOC_AREAS_B.LOCATION_TYPE_CODE | JTF_LOC_TYPES_B |
JTF_LOC_HIERARCHIES_B.LOCATION_TYPE_CODE | JTF_LOC_TYPES_B |
JTF_LOC_TYPES_TL.LOCATION_TYPE_ID | JTF_LOC_TYPES_B |
JTF.JTF_LOC_TYPES_B does not reference any database object
JTF.JTF_LOC_TYPES_B is referenced by following:
Description: | Stores columns that should be translated for a location types. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_LOC_TYPES_TL.LOCATION_TYPE_ID | JTF_LOC_TYPES_B |
JTF.JTF_LOC_TYPES_TL does not reference any database object
JTF.JTF_LOC_TYPES_TL is referenced by following:
Description: | business objects store |
---|
JTF.JTF_MESSAGE_OBJECTS does not reference any database object
JTF.JTF_MESSAGE_OBJECTS is referenced by following:
Description: | Stores the Queue name for each registered Business Object. |
---|
JTF.JTF_MSG_OBJ_ROUTE does not reference any database object
JTF.JTF_MSG_OBJ_ROUTE is referenced by following:
Description: | Stores Mini Site (Specialty Stores) Information. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_MSITES_B.MSITE_ROOT_SECTION_ID | JTF_DSP_SECTIONS_B |
JTF_MSITES_B.DEFAULT_LANGUAGE_CODE | FND_LANGUAGES |
JTF_MSITES_B.DEFAULT_CURRENCY_CODE | FND_CURRENCIES |
JTF_MSITES_B.PROFILE_ID | JTF_PERZ_PROFILE |
JTF_MSITES_B.STORE_ID | JTF_STORES_B |
Foreign Key Column | Foreign Table |
---|---|
JTF_DSP_LGL_PHYS_MAP.MSITE_ID | JTF_MSITES_B |
JTF_DSP_MSITE_SCT_ITEMS.MINI_SITE_ID | JTF_MSITES_B |
JTF_DSP_MSITE_SCT_SECTS.MINI_SITE_ID | JTF_MSITES_B |
JTF_MSITES_TL.MSITE_ID | JTF_MSITES_B |
JTF_MSITE_CURRENCIES.MSITE_ID | JTF_MSITES_B |
JTF_MSITE_LANGUAGES.MSITE_ID | JTF_MSITES_B |
JTF_MSITE_ORGS.MSITE_ID | JTF_MSITES_B |
JTF_MSITE_PRTY_ACCSS.MSITE_ID | JTF_MSITES_B |
JTF_MSITE_RESPS_B.MSITE_ID | JTF_MSITES_B |
JTF.JTF_MSITES_B does not reference any database object
JTF.JTF_MSITES_B is referenced by following:
Description: | Translations for JTF_MSITES_B |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_MSITES_TL.MSITE_ID | JTF_MSITES_B |
JTF.JTF_MSITES_TL does not reference any database object
JTF.JTF_MSITES_TL is referenced by following:
Description: | Stores the currencies supported by the mini-sites |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_MSITE_CURRENCIES.MSITE_ID | JTF_MSITES_B |
JTF_MSITE_CURRENCIES.CURRENCY_CODE | FND_CURRENCIES |
JTF_MSITE_CURRENCIES.BIZPARTNER_PRC_LISTID | QP_LIST_HEADERS_B |
JTF_MSITE_CURRENCIES.REGISTERED_PRC_LISTID | QP_LIST_HEADERS_B |
JTF_MSITE_CURRENCIES.WALKIN_PRC_LISTID | QP_LIST_HEADERS_B |
JTF.JTF_MSITE_CURRENCIES does not reference any database object
JTF.JTF_MSITE_CURRENCIES is referenced by following:
Description: | Stores the languages supported by the mini-sites |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_MSITE_LANGUAGES.MSITE_ID | JTF_MSITES_B |
JTF_MSITE_LANGUAGES.LANGUAGE_CODE | FND_LANGUAGES |
JTF.JTF_MSITE_LANGUAGES does not reference any database object
JTF.JTF_MSITE_LANGUAGES is referenced by following:
Description: | Define the organizations supported by the mini-sites |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_MSITE_ORGS.MSITE_ID | JTF_MSITES_B |
JTF.JTF_MSITE_ORGS does not reference any database object
JTF.JTF_MSITE_ORGS is referenced by following:
Description: | Defines the parties supported by the mini-sites (Currently not used in 11.5.1) |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_MSITE_PRTY_ACCSS.MSITE_ID | JTF_MSITES_B |
JTF_MSITE_PRTY_ACCSS.PARTY_ID | HZ_PARTIES |
JTF.JTF_MSITE_PRTY_ACCSS does not reference any database object
JTF.JTF_MSITE_PRTY_ACCSS is referenced by following:
Description: | Defines the responsibilities supported by the minisite |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_MSITE_RESPS_B.MSITE_ID | JTF_MSITES_B |
Foreign Key Column | Foreign Table |
---|---|
JTF_MSITE_RESPS_TL.MSITE_RESP_ID | JTF_MSITE_RESPS_B |
JTF.JTF_MSITE_RESPS_B does not reference any database object
JTF.JTF_MSITE_RESPS_B is referenced by following:
Description: | Translations for JTF_MSITE_RESPS_B |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_MSITE_RESPS_TL.MSITE_RESP_ID | JTF_MSITE_RESPS_B |
JTF.JTF_MSITE_RESPS_TL does not reference any database object
JTF.JTF_MSITE_RESPS_TL is referenced by following:
Description: | Define the node types that will be shown in the navigator |
---|
JTF.JTF_NAV_NODE_TYPES does not reference any database object
JTF.JTF_NAV_NODE_TYPES is referenced by following:
Description: | Base table that stores the tabs by application id. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_NAV_TABS_TL.TAB_ID | JTF_NAV_TABS_B |
JTF.JTF_NAV_TABS_B does not reference any database object
JTF.JTF_NAV_TABS_B is referenced by following:
Description: | Translation table that stores the translated values for the tabs in the UI navigator. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_NAV_TABS_TL.TAB_ID | JTF_NAV_TABS_B |
JTF.JTF_NAV_TABS_TL does not reference any database object
JTF.JTF_NAV_TABS_TL is referenced by following:
Description: | Base table that stores the tree root for each view by. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_NAV_TREE_ROOTS_TL.TREE_ROOT_ID | JTF_NAV_TREE_ROOTS_B |
JTF.JTF_NAV_TREE_ROOTS_B does not reference any database object
JTF.JTF_NAV_TREE_ROOTS_B is referenced by following:
Description: | Translation table which stores the language dependent text to be shown on the tree root. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_NAV_TREE_ROOTS_TL.TREE_ROOT_ID | JTF_NAV_TREE_ROOTS_B |
JTF.JTF_NAV_TREE_ROOTS_TL does not reference any database object
JTF.JTF_NAV_TREE_ROOTS_TL is referenced by following:
Description: | Base table that stores the view-bys associated with each tab. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_NAV_VIEWBYS_TL.VIEWBY_ID | JTF_NAV_VIEWBYS_B |
JTF.JTF_NAV_VIEWBYS_B does not reference any database object
JTF.JTF_NAV_VIEWBYS_B is referenced by following:
Description: | JTF_NAV_VIEWBYS_TL stores information about the lables that appear in the drop down list. Each row includes the value, its translated data, the translation language and the source language. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_NAV_VIEWBYS_TL.VIEWBY_ID | JTF_NAV_VIEWBYS_B |
JTF.JTF_NAV_VIEWBYS_TL does not reference any database object
JTF.JTF_NAV_VIEWBYS_TL is referenced by following:
Description: | Non-translated base table for Notes module. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_NOTES_B.SOURCE_OBJECT_ID | CS_INCIDENTS_ALL_B |
JTF_NOTES_B.SOURCE_OBJECT_CODE | JTF_OBJECTS_B |
JTF_NOTES_B.SOURCE_OBJECT_ID | AS_LEADS_ALL |
JTF_NOTES_B.SOURCE_OBJECT_ID | AS_SALES_LEADS |
JTF_NOTES_B.PARENT_NOTE_ID | JTF_NOTES_B |
Foreign Key Column | Foreign Table |
---|---|
JTF_NOTES_B.PARENT_NOTE_ID | JTF_NOTES_B |
JTF_NOTES_TL.JTF_NOTE_ID | JTF_NOTES_B |
JTF_NOTE_CONTEXTS.JTF_NOTE_ID | JTF_NOTES_B |
JTF.JTF_NOTES_B does not reference any database object
JTF.JTF_NOTES_B is referenced by following:
Description: | JTF_NOTES_SOURCE_TYPE_MAP is the base table for defining application/object specific note types. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_NOTES_SOURCE_TYPE_MAP.SOURCE_OBJECT_CODE | JTF_OBJECTS_B |
JTF.JTF_NOTES_SOURCE_TYPE_MAP does not reference any database object
JTF.JTF_NOTES_SOURCE_TYPE_MAP is referenced by following:
Description: | Translated base table for Notes module. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_NOTES_TL.JTF_NOTE_ID | JTF_NOTES_B |
JTF.JTF_NOTES_TL does not reference any database object
JTF.JTF_NOTES_TL is referenced by following:
Description: | Base table for Contexts to Notes, which are references to other objects. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_NOTE_CONTEXTS.NOTE_CONTEXT_TYPE_ID | AS_LEADS_ALL |
JTF_NOTE_CONTEXTS.NOTE_CONTEXT_TYPE_ID | AS_SALES_LEADS |
JTF_NOTE_CONTEXTS.JTF_NOTE_ID | JTF_NOTES_B |
JTF_NOTE_CONTEXTS.NOTE_CONTEXT_TYPE | JTF_OBJECTS_B |
JTF.JTF_NOTE_CONTEXTS does not reference any database object
JTF.JTF_NOTE_CONTEXTS is referenced by following:
Description: | This table stores the details of objects(modules). |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_OBJECTS_B.APPLICATION_ID | FND_APPLICATION |
Foreign Key Column | Foreign Table |
---|---|
OKS_K_ORDER_CONTACTS.JTOT_OBJECT_CODE | JTF_OBJECTS_B |
OKL_CRITERIA_B.JTF_OBJECT_CODE | JTF_OBJECTS_B |
CSS_DEF_EXTERNAL_LINKS.TO_OBJECT_CODE | JTF_OBJECTS_B |
CSS_DEF_NOTE_TOKEN_MAP.OBJECT_CODE | JTF_OBJECTS_B |
CS_FORUM_CAT_LINKS.OBJECT_CODE | JTF_OBJECTS_B |
CS_INCIDENT_LINKS_EXT.TO_OBJECT_TYPE | JTF_OBJECTS_B |
CS_INCIDENT_LINKS.SUBJECT_TYPE | JTF_OBJECTS_B |
CS_INCIDENT_LINKS.OBJECT_TYPE | JTF_OBJECTS_B |
CS_KB_ELEMENT_LINKS.OBJECT_CODE | JTF_OBJECTS_B |
CS_KB_ELE_TYPE_LINKS.OBJECT_CODE | JTF_OBJECTS_B |
CS_KB_SET_LINKS.OBJECT_CODE | JTF_OBJECTS_B |
CS_KB_SET_TYPE_LINKS.OBJECT_CODE | JTF_OBJECTS_B |
CS_SR_LINK_VALID_OBJ.SUBJECT_TYPE | JTF_OBJECTS_B |
CS_SR_LINK_VALID_OBJ.OBJECT_TYPE | JTF_OBJECTS_B |
CS_TP_TEMPLATE_ATTRIBUTE.OBJECT_CODE | JTF_OBJECTS_B |
CS_TP_TEMPLATE_LINKS.OBJECT_CODE | JTF_OBJECTS_B |
IEO_SVR_PARAMS.OBJECT_CODE | JTF_OBJECTS_B |
IEU_MSG_MESSAGES.WORKITEM_OBJ_CODE | JTF_OBJECTS_B |
IEU_UWQM_ITEMS.WORKITEM_OBJ_CODE | JTF_OBJECTS_B |
IBY_TANGIBLE.SOURCE_OBJECT_TYPE_CODE | JTF_OBJECTS_B |
JTF_CAL_RESOURCE_ASSIGN.RESOURCE_TYPE_CODE | JTF_OBJECTS_B |
JTF_GRID_COLS_B.VALIDATION_OBJECT_CODE | JTF_OBJECTS_B |
JTF_IH_ACTIVITIES.DOC_REF | JTF_OBJECTS_B |
JTF_NOTES_B.SOURCE_OBJECT_CODE | JTF_OBJECTS_B |
JTF_NOTES_SOURCE_TYPE_MAP.SOURCE_OBJECT_CODE | JTF_OBJECTS_B |
JTF_NOTE_CONTEXTS.NOTE_CONTEXT_TYPE | JTF_OBJECTS_B |
JTF_OBJECTS_TL.OBJECT_CODE | JTF_OBJECTS_B |
JTF_OBJECT_MAPPINGS.SOURCE_OBJECT_CODE | JTF_OBJECTS_B |
JTF_OBJECT_USAGES.OBJECT_CODE | JTF_OBJECTS_B |
JTF_RS_RESOURCE_EXTNS.CATEGORY | JTF_OBJECTS_B |
JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE | JTF_OBJECTS_B |
JTF_STATE_RULES_B.STATE_TYPE | JTF_OBJECTS_B |
JTF_STATE_RULES_B.STATE_TYPE | JTF_OBJECTS_B |
JTF_TASKS_B.SOURCE_OBJECT_TYPE_CODE | JTF_OBJECTS_B |
JTF_TASKS_B.SOURCE_OBJECT_TYPE_CODE | JTF_OBJECTS_B |
JTF_TASK_ASSIGNMENTS.RESOURCE_TYPE_CODE | JTF_OBJECTS_B |
JTF_TASK_REFERENCES_B.OBJECT_TYPE_CODE | JTF_OBJECTS_B |
JTF_TASK_RSC_REQS.RESOURCE_TYPE_CODE | JTF_OBJECTS_B |
JTF_TASK_TEMP_GROUPS_B.SOURCE_OBJECT_TYPE_CODE | JTF_OBJECTS_B |
OKC_K_ITEMS.JTOT_OBJECT1_CODE | JTF_OBJECTS_B |
OKC_K_PARTY_ROLES_B.JTOT_OBJECT1_CODE | JTF_OBJECTS_B |
OKC_CONTACT_SOURCES.JTOT_OBJECT_CODE | JTF_OBJECTS_B |
OKC_CONTACTS.JTOT_OBJECT1_CODE | JTF_OBJECTS_B |
OKC_LINE_STYLE_SOURCES.JTOT_OBJECT_CODE | JTF_OBJECTS_B |
OKC_RULE_DEF_SOURCES.JTOT_OBJECT_CODE | JTF_OBJECTS_B |
OKC_ROLE_SOURCES.JTOT_OBJECT_CODE | JTF_OBJECTS_B |
OKC_RULES_B.JTOT_OBJECT1_CODE | JTF_OBJECTS_B |
OKC_RULES_B.JTOT_OBJECT2_CODE | JTF_OBJECTS_B |
OKC_RULES_B.JTOT_OBJECT3_CODE | JTF_OBJECTS_B |
OKL_QUOTE_PARTIES.CONTACT_JTOT_OBJECT1_CODE | JTF_OBJECTS_B |
OKL_QUOTE_PARTIES.PARTY_JTOT_OBJECT1_CODE | JTF_OBJECTS_B |
OKR_IP_PARTY_RELS_B.JTOT_OBJECT1_CODE | JTF_OBJECTS_B |
OKS_K_DEFAULTS.JTOT_OBJECT_CODE | JTF_OBJECTS_B |
OKS_K_ORDER_CONTACTS.JTOT_OBJECT_CODE | JTF_OBJECTS_B |
OKS_RULES_DFF.JTOT_OBJECT1_CODE | JTF_OBJECTS_B |
OKS_RULES_DFF.JTOT_OBJECT2_CODE | JTF_OBJECTS_B |
OKS_RULES_DFF.JTOT_OBJECT3_CODE | JTF_OBJECTS_B |
OKS_SERV_AVAILS.JTOT_OBJECT1_CODE | JTF_OBJECTS_B |
OKS_SERV_AVAIL_EXCEPTS.JTOT_OBJECT1_CODE | JTF_OBJECTS_B |
JTF.JTF_OBJECTS_B does not reference any database object
JTF.JTF_OBJECTS_B is referenced by following:
Description: | Translation Table for JTF_OBJECTS_B |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_OBJECTS_TL.OBJECT_CODE | JTF_OBJECTS_B |
JTF.JTF_OBJECTS_TL does not reference any database object
JTF.JTF_OBJECTS_TL is referenced by following:
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. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_OBJECT_MAPPINGS.FLE_LOOKUP_TYPE
JTF_OBJECT_MAPPINGS.FLE_LANGUAGE JTF_OBJECT_MAPPINGS.FLE_LOOKUP_CODE JTF_OBJECT_MAPPINGS.FLE_SECURITY_GROUP_ID JTF_OBJECT_MAPPINGS.FLE_VIEW_APPLICATION_ID |
FND_LOOKUP_VALUES |
JTF_OBJECT_MAPPINGS.SOURCE_OBJECT_CODE | JTF_OBJECTS_B |
JTF.JTF_OBJECT_MAPPINGS does not reference any database object
JTF.JTF_OBJECT_MAPPINGS is referenced by following:
Description: |
---|
JTF.JTF_OBJECT_PG_DTLS does not reference any database object
JTF.JTF_OBJECT_PG_DTLS is referenced by following:
Description: |
---|
JTF.JTF_OBJECT_PG_PARAMS does not reference any database object
JTF.JTF_OBJECT_PG_PARAMS is referenced by following:
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. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_OBJECT_USAGES.OBJECT_CODE | JTF_OBJECTS_B |
JTF.JTF_OBJECT_USAGES does not reference any database object
JTF.JTF_OBJECT_USAGES is referenced by following:
Description: | Stores information about categories used in the Runtime Product Catalog |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PC_CATEGORIES_TL.CATEGORY_ID | JTF_PC_CATEGORIES_B |
JTF_PC_HIERARCHIES.NODE_REFERENCE | JTF_PC_CATEGORIES_B |
JTF.JTF_PC_CATEGORIES_B does not reference any database object
JTF.JTF_PC_CATEGORIES_B is referenced by following:
Description: | Translation table for JTF_PC_CATEGORIES_B |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PC_CATEGORIES_TL.CATEGORY_ID | JTF_PC_CATEGORIES_B |
JTF.JTF_PC_CATEGORIES_TL does not reference any database object
JTF.JTF_PC_CATEGORIES_TL is referenced by following:
Description: | Stores node hierarchy of Categories and Price Lists for the Runtime Product Catalog |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PC_HIERARCHIES.PARENT_NODE_ID | JTF_PC_HIERARCHIES |
JTF_PC_HIERARCHIES.NODE_REFERENCE | QP_LIST_LINES |
JTF_PC_HIERARCHIES.NODE_REFERENCE | JTF_PC_CATEGORIES_B |
JTF_PC_HIERARCHIES.TOP_NODE_ID | JTF_PC_HIERARCHIES |
Foreign Key Column | Foreign Table |
---|---|
JTF_PC_HIERARCHIES.PARENT_NODE_ID | JTF_PC_HIERARCHIES |
JTF_PC_HIERARCHIES.TOP_NODE_ID | JTF_PC_HIERARCHIES |
JTF.JTF_PC_HIERARCHIES does not reference any database object
JTF.JTF_PC_HIERARCHIES is referenced by following:
Description: | JTF_PERZ_DATA stores personalized data objects. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PERZ_DATA.PROFILE_ID | JTF_PERZ_PROFILE |
Foreign Key Column | Foreign Table |
---|---|
JTF_PERZ_DATA_ATTRIB.PERZ_DATA_ID | JTF_PERZ_DATA |
JTF.JTF_PERZ_DATA does not reference any database object
JTF.JTF_PERZ_DATA is referenced by following:
Description: | JTF_PERZ_DATA_ATTRIB stores the data attributes associated with a personalized data object. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PERZ_DATA_ATTRIB.PERZ_DATA_ID | JTF_PERZ_DATA |
JTF.JTF_PERZ_DATA_ATTRIB does not reference any database object
JTF.JTF_PERZ_DATA_ATTRIB is referenced by following:
Description: | JTF_PERZ_DATA_DEFAULT stores personalized data defaults. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PERZ_DATA_DEFAULT.PROFILE_ID | JTF_PERZ_PROFILE |
JTF.JTF_PERZ_DATA_DEFAULT does not reference any database object
JTF.JTF_PERZ_DATA_DEFAULT is referenced by following:
Description: | JTF_PERZ_LF_ATTRIB stores the attributes associated with an object type defined in JTF_PERZ_LF_OBJECT_TYPE. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PERZ_OBJ_TYPE_MAP.ATTRIBUTE_ID | JTF_PERZ_LF_ATTRIB |
JTF.JTF_PERZ_LF_ATTRIB does not reference any database object
JTF.JTF_PERZ_LF_ATTRIB is referenced by following:
Description: | JTF_PERZ_LF_OBJECT stores instances of look and feel objects created from the meta data defined in JTF_PERZ_LF_OBJECT_TYPE and JTF_PERZ_LF_ATTRIB. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PERZ_OBJ_MAP.OBJECT_ID | JTF_PERZ_LF_OBJECT |
JTF.JTF_PERZ_LF_OBJECT does not reference any database object
JTF.JTF_PERZ_LF_OBJECT is referenced by following:
Description: | JTF_PERZ_LF_OBJECT_TYPE stores the meta data for a look and feel object. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PERZ_OBJ_TYPE_MAP.OBJECT_TYPE_ID | JTF_PERZ_LF_OBJECT_TYPE |
JTF.JTF_PERZ_LF_OBJECT_TYPE does not reference any database object
JTF.JTF_PERZ_LF_OBJECT_TYPE is referenced by following:
Description: | JTF_PERZ_LF_VALUE store the values associated with the attributes of a look and feel object instance. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PERZ_LF_VALUE.OBJ_MAP_ID | JTF_PERZ_OBJ_MAP |
JTF_PERZ_LF_VALUE.PROFILE_ID | JTF_PERZ_PROFILE |
JTF.JTF_PERZ_LF_VALUE does not reference any database object
JTF.JTF_PERZ_LF_VALUE is referenced by following:
Description: | JTF_PERZ_OBJ_MAP stores the mapping between the look and feel object instance and the actual values for the attributes. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PERZ_OBJ_MAP.MAP_ID | JTF_PERZ_OBJ_TYPE_MAP |
JTF_PERZ_OBJ_MAP.OBJECT_ID | JTF_PERZ_LF_OBJECT |
Foreign Key Column | Foreign Table |
---|---|
JTF_PERZ_LF_VALUE.OBJ_MAP_ID | JTF_PERZ_OBJ_MAP |
JTF.JTF_PERZ_OBJ_MAP does not reference any database object
JTF.JTF_PERZ_OBJ_MAP is referenced by following:
Description: | JTF_PERZ_OBJ_TYPE_MAP stores the mapping between the object type and the object attributes. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PERZ_OBJ_TYPE_MAP.OBJECT_TYPE_ID | JTF_PERZ_LF_OBJECT_TYPE |
JTF_PERZ_OBJ_TYPE_MAP.ATTRIBUTE_ID | JTF_PERZ_LF_ATTRIB |
Foreign Key Column | Foreign Table |
---|---|
JTF_PERZ_OBJ_MAP.MAP_ID | JTF_PERZ_OBJ_TYPE_MAP |
JTF.JTF_PERZ_OBJ_TYPE_MAP does not reference any database object
JTF.JTF_PERZ_OBJ_TYPE_MAP is referenced by following:
Description: | JTF_PERZ_PROFILE stores the personalization tag or profile for an entity. The entity could be a user, an object, a group etc. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_MSITES_B.PROFILE_ID | JTF_PERZ_PROFILE |
JTF_PERZ_DATA_DEFAULT.PROFILE_ID | JTF_PERZ_PROFILE |
JTF_PERZ_DATA.PROFILE_ID | JTF_PERZ_PROFILE |
JTF_PERZ_LF_VALUE.PROFILE_ID | JTF_PERZ_PROFILE |
JTF_PERZ_PROFILE_ATTRIB.PROFILE_ID | JTF_PERZ_PROFILE |
JTF_PERZ_QUERY.PROFILE_ID | JTF_PERZ_PROFILE |
JTF.JTF_PERZ_PROFILE does not reference any database object
JTF.JTF_PERZ_PROFILE is referenced by following:
Description: | JTF_PERZ_PROFILE_ATTRIB stores the attributes associated with a personalization profile. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PERZ_PROFILE_ATTRIB.PROFILE_ID | JTF_PERZ_PROFILE |
JTF.JTF_PERZ_PROFILE_ATTRIB does not reference any database object
JTF.JTF_PERZ_PROFILE_ATTRIB is referenced by following:
Description: | JTF_PERZ_QUERY stores personalized query objects. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PERZ_QUERY.PROFILE_ID | JTF_PERZ_PROFILE |
Foreign Key Column | Foreign Table |
---|---|
JTF_PERZ_QUERY_ORDER_BY.QUERY_ID | JTF_PERZ_QUERY |
JTF_PERZ_QUERY_PARAM.QUERY_ID | JTF_PERZ_QUERY |
JTF_PERZ_QUERY_RAW_SQL.QUERY_ID | JTF_PERZ_QUERY |
JTF.JTF_PERZ_QUERY does not reference any database object
JTF.JTF_PERZ_QUERY is referenced by following:
Description: | JTF_PERZ_QUERY_ORDER_BY stores the order by parameters associated with a personalized query object. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PERZ_QUERY_ORDER_BY.QUERY_ID | JTF_PERZ_QUERY |
JTF.JTF_PERZ_QUERY_ORDER_BY does not reference any database object
JTF.JTF_PERZ_QUERY_ORDER_BY is referenced by following:
Description: | JTF_PERZ_QUERY_PARAM stores the query parameters associated with a personalized query object. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PERZ_QUERY_PARAM.QUERY_ID | JTF_PERZ_QUERY |
JTF.JTF_PERZ_QUERY_PARAM does not reference any database object
JTF.JTF_PERZ_QUERY_PARAM is referenced by following:
Description: | JTF_PERZ_QUERY_RAW_SQL stores the SQL string associated with a personalized query object. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PERZ_QUERY_RAW_SQL.QUERY_ID | JTF_PERZ_QUERY |
JTF.JTF_PERZ_QUERY_RAW_SQL does not reference any database object
JTF.JTF_PERZ_QUERY_RAW_SQL is referenced by following:
Description: | Record all the anonymous (not falling within any session) activities |
---|
JTF.JTF_PF_ANON_ACTIVITY does not reference any database object
JTF.JTF_PF_ANON_ACTIVITY is referenced by following:
Description: |
---|
JTF.JTF_PF_APP_SUMM does not reference any database object
JTF.JTF_PF_APP_SUMM is referenced by following:
Description: |
---|
JTF.JTF_PF_HOST_SUMM does not reference any database object
JTF.JTF_PF_HOST_SUMM is referenced by following:
Description: | Record all Declarative Page flow data |
---|
JTF.JTF_PF_LOGICAL_FLOWS does not reference any database object
JTF.JTF_PF_LOGICAL_FLOWS is referenced by following:
Description: |
---|
JTF.JTF_PF_PAGE_SUMM does not reference any database object
JTF.JTF_PF_PAGE_SUMM is referenced by following:
Description: |
---|
JTF.JTF_PF_PURGEABLE does not reference any database object
JTF.JTF_PF_PURGEABLE is referenced by following:
Description: |
---|
JTF.JTF_PF_SESSION_SUMM does not reference any database object
JTF.JTF_PF_SESSION_SUMM is referenced by following:
Description: | Record all the actvities that falls within a session |
---|
JTF.JTF_PF_SES_ACTIVITY does not reference any database object
JTF.JTF_PF_SES_ACTIVITY is referenced by following:
Description: | Temporary |
---|
JTF.JTF_PF_TMP_ACTIVITY does not reference any database object
JTF.JTF_PF_TMP_ACTIVITY is referenced by following:
Description: |
---|
JTF.JTF_PF_USER_SUMM does not reference any database object
JTF.JTF_PF_USER_SUMM is referenced by following:
Description: | JTF_PREFAB_CACHE_STATS captures the statistics of cache usage. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PREFAB_CACHE_STATS.WSH_PO_ID | JTF_PREFAB_WSH_POES_B |
JTF_PREFAB_CACHE_STATS.CA_COMP_ID | JTF_PREFAB_CA_COMPS_B |
JTF.JTF_PREFAB_CACHE_STATS does not reference any database object
JTF.JTF_PREFAB_CACHE_STATS is referenced by following:
Description: | JTF_PREFAB_CA_COMPS_B models a cache component for an application. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PREFAB_CACHE_STATS.CA_COMP_ID | JTF_PREFAB_CA_COMPS_B |
JTF_PREFAB_HA_COMPS.CA_COMP_ID | JTF_PREFAB_CA_COMPS_B |
JTF.JTF_PREFAB_CA_COMPS_B does not reference any database object
JTF.JTF_PREFAB_CA_COMPS_B is referenced by following:
Description: | JTF_PREFAB_CA_COMPS_TL is a translation table. |
---|
JTF.JTF_PREFAB_CA_COMPS_TL does not reference any database object
JTF.JTF_PREFAB_CA_COMPS_TL is referenced by following:
Description: | JTF_PREFAB_CA_FILTERS_B models a cache filter. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PREFAB_CA_FL_LANGS.CA_FILTER_ID | JTF_PREFAB_CA_FILTERS_B |
JTF_PREFAB_CA_FL_RESPS.CA_FILTER_ID | JTF_PREFAB_CA_FILTERS_B |
JTF_PREFAB_HA_FILTERS.CA_FILTER_ID | JTF_PREFAB_CA_FILTERS_B |
JTF.JTF_PREFAB_CA_FILTERS_B does not reference any database object
JTF.JTF_PREFAB_CA_FILTERS_B is referenced by following:
Description: | JTF_PREFAB_CA_FILTERS_TL is a translation table. |
---|
JTF.JTF_PREFAB_CA_FILTERS_TL does not reference any database object
JTF.JTF_PREFAB_CA_FILTERS_TL is referenced by following:
Description: | JTF_PREFAB_CA_FL_LANGS stores all the language codes associated with a cache filter in the table JTF_PREFAB_CA_FILTERS_B. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PREFAB_CA_FL_LANGS.CA_FILTER_ID | JTF_PREFAB_CA_FILTERS_B |
JTF.JTF_PREFAB_CA_FL_LANGS does not reference any database object
JTF.JTF_PREFAB_CA_FL_LANGS is referenced by following:
Description: | JTF_PREFAB_CA_FL_RESPS stores all the responsibility id's associated with a cache filter in the table JTF_PREFAB_CA_FILTERS_B. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PREFAB_CA_FL_RESPS.CA_FILTER_ID | JTF_PREFAB_CA_FILTERS_B |
JTF.JTF_PREFAB_CA_FL_RESPS does not reference any database object
JTF.JTF_PREFAB_CA_FL_RESPS is referenced by following:
Description: | JTF_PREFAB_FILTERS_B models a prefabrication filter. |
---|
JTF.JTF_PREFAB_FILTERS_B does not reference any database object
JTF.JTF_PREFAB_FILTERS_B is referenced by following:
Description: | JTF_PREFAB_FILTERS_TL is a translation table. |
---|
JTF.JTF_PREFAB_FILTERS_TL does not reference any database object
JTF.JTF_PREFAB_FILTERS_TL is referenced by following:
Description: | JTF_PREFAB_HA_COMPS models the policy for a cache component (CA_COMP_ID) on a specific host (HOST_APP_ID). |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PREFAB_HA_COMPS.HOST_APP_ID | JTF_PREFAB_HOST_APPS |
JTF_PREFAB_HA_COMPS.CA_COMP_ID | JTF_PREFAB_CA_COMPS_B |
JTF.JTF_PREFAB_HA_COMPS does not reference any database object
JTF.JTF_PREFAB_HA_COMPS is referenced by following:
Description: | JTF_PREFAB_HA_FILTERS stores the policy for a cache filter (CA_FILTER_ID) on a particular host (HOST_APP_ID). |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PREFAB_HA_FILTERS.HOST_APP_ID | JTF_PREFAB_HOST_APPS |
JTF_PREFAB_HA_FILTERS.CA_FILTER_ID | JTF_PREFAB_CA_FILTERS_B |
JTF.JTF_PREFAB_HA_FILTERS does not reference any database object
JTF.JTF_PREFAB_HA_FILTERS is referenced by following:
Description: | JTF_PREFAB_HOST_APPS models applications belonging to a host. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PREFAB_HOST_APPS.WSH_PO_ID | JTF_PREFAB_WSH_POES_B |
Foreign Key Column | Foreign Table |
---|---|
JTF_PREFAB_HA_COMPS.HOST_APP_ID | JTF_PREFAB_HOST_APPS |
JTF_PREFAB_HA_FILTERS.HOST_APP_ID | JTF_PREFAB_HOST_APPS |
JTF.JTF_PREFAB_HOST_APPS does not reference any database object
JTF.JTF_PREFAB_HOST_APPS is referenced by following:
Description: | JTF_PREFAB_POLICIES_B models prefabrication policies. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PREFAB_PRBS.POLICY_ID | JTF_PREFAB_POLICIES_B |
JTF_PREFAB_STATISTICS.POLICY_ID | JTF_PREFAB_POLICIES_B |
JTF_PREFAB_UR_POLICIES.POLICY_ID | JTF_PREFAB_POLICIES_B |
JTF.JTF_PREFAB_POLICIES_B does not reference any database object
JTF.JTF_PREFAB_POLICIES_B is referenced by following:
Description: | JTF_PREFAB_POLICIES_TL is a translation table. |
---|
JTF.JTF_PREFAB_POLICIES_TL does not reference any database object
JTF.JTF_PREFAB_POLICIES_TL is referenced by following:
Description: | JTF_PREFAB_PRBS models the PRBs for the prefabricator. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PREFAB_PRBS.POLICY_ID | JTF_PREFAB_POLICIES_B |
JTF.JTF_PREFAB_PRBS does not reference any database object
JTF.JTF_PREFAB_PRBS is referenced by following:
Description: | JTF_PREFAB_STATISTICS stores the statistics information of Prefabrication. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PREFAB_STATISTICS.POLICY_ID | JTF_PREFAB_POLICIES_B |
JTF_PREFAB_STATISTICS.WSH_PO_ID | JTF_PREFAB_WSH_POES_B |
JTF.JTF_PREFAB_STATISTICS does not reference any database object
JTF.JTF_PREFAB_STATISTICS is referenced by following:
Description: | JTF_PREFAB_SYS_POLICIES models the system-wide policy for the prefabrication system. |
---|
JTF.JTF_PREFAB_SYS_POLICIES does not reference any database object
JTF.JTF_PREFAB_SYS_POLICIES is referenced by following:
Description: | JTF_PREFAB_UD_KEYS models the user defined key for the prefabrication system. |
---|
JTF.JTF_PREFAB_UD_KEYS_B does not reference any database object
JTF.JTF_PREFAB_UD_KEYS_B is referenced by following:
Description: | JTF_PREFAB_UD_KEYS_TL is a translation table. |
---|
JTF.JTF_PREFAB_UD_KEYS_TL does not reference any database object
JTF.JTF_PREFAB_UD_KEYS_TL is referenced by following:
Description: | JTF_PREFAB_UR_POLICIES models user id's and responsibility id's that are associated with a policy in the table JTF_PREFAB_POLICIES_B. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PREFAB_UR_POLICIES.POLICY_ID | JTF_PREFAB_POLICIES_B |
JTF.JTF_PREFAB_UR_POLICIES does not reference any database object
JTF.JTF_PREFAB_UR_POLICIES is referenced by following:
Description: | JTF_PREFAB_WSHP_POLICIES models ports associated with a given host in the table JTF_PREFAB_WSH_POES_B. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PREFAB_WSHP_POLICIES.WSH_PO_ID | JTF_PREFAB_WSH_POES_B |
JTF.JTF_PREFAB_WSHP_POLICIES does not reference any database object
JTF.JTF_PREFAB_WSHP_POLICIES is referenced by following:
Description: | JTF_PREFAB_WSH_POES_B captures the list of web-servers and their associated characteristics. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PREFAB_CACHE_STATS.WSH_PO_ID | JTF_PREFAB_WSH_POES_B |
JTF_PREFAB_HOST_APPS.WSH_PO_ID | JTF_PREFAB_WSH_POES_B |
JTF_PREFAB_STATISTICS.WSH_PO_ID | JTF_PREFAB_WSH_POES_B |
JTF_PREFAB_WSHP_POLICIES.WSH_PO_ID | JTF_PREFAB_WSH_POES_B |
JTF_PREFAB_WSH_POES_TL.PWPB_WSH_PO_ID | JTF_PREFAB_WSH_POES_B |
JTF.JTF_PREFAB_WSH_POES_B does not reference any database object
JTF.JTF_PREFAB_WSH_POES_B is referenced by following:
Description: | JTF_PREFAB_WSH_POES_TL is a translation table. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PREFAB_WSH_POES_TL.PWPB_WSH_PO_ID | JTF_PREFAB_WSH_POES_B |
JTF.JTF_PREFAB_WSH_POES_TL does not reference any database object
JTF.JTF_PREFAB_WSH_POES_TL is referenced by following:
Description: | product level message queue |
---|
JTF.JTF_PROD_MSG_ROUTE does not reference any database object
JTF.JTF_PROD_MSG_ROUTE is referenced by following:
Description: | Contains base profile properties defined for profiles. This is not application specific |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PROFILEPROPERTIES_B.PROFILE_MAPPINGS_ID | JTF_PROFILE_MAPPINGS_B |
JTF_PROFILEPROPERTIES_B.OWNER_APPLICATION_ID | FND_APPLICATION |
Foreign Key Column | Foreign Table |
---|---|
JTF_PROFILEPROPERTIES_TL.PROFILEPROPERTIES_ID | JTF_PROFILEPROPERTIES_B |
JTF_PROFILE_METADATA_B.PROFILEPROPERTIES_ID | JTF_PROFILEPROPERTIES_B |
JTF.JTF_PROFILEPROPERTIES_B does not reference any database object
JTF.JTF_PROFILEPROPERTIES_B is referenced by following:
Description: | Contains the translation related columns for JTF_PROFILEPROPERTIES_B table |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PROFILEPROPERTIES_TL.PROFILEPROPERTIES_ID | JTF_PROFILEPROPERTIES_B |
JTF.JTF_PROFILEPROPERTIES_TL does not reference any database object
JTF.JTF_PROFILEPROPERTIES_TL is referenced by following:
Description: | Base table that contains mapping between a base table and corresponding profile table |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PROFILE_MAPPINGS_B.OWNERID | FND_APPLICATION |
Foreign Key Column | Foreign Table |
---|---|
JTF_PROFILEPROPERTIES_B.PROFILE_MAPPINGS_ID | JTF_PROFILE_MAPPINGS_B |
JTF_PROFILE_MAPPINGS_TL.PROFILE_MAPPINGS_ID | JTF_PROFILE_MAPPINGS_B |
JTF_SUBSCRIBED_PROFILES.PROFILE_MAPPINGS_ID | JTF_PROFILE_MAPPINGS_B |
JTF.JTF_PROFILE_MAPPINGS_B does not reference any database object
JTF.JTF_PROFILE_MAPPINGS_B is referenced by following:
Description: | Translation table that contains mapping between a base table and corresponding profile table |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PROFILE_MAPPINGS_TL.PROFILE_MAPPINGS_ID | JTF_PROFILE_MAPPINGS_B |
JTF.JTF_PROFILE_MAPPINGS_TL does not reference any database object
JTF.JTF_PROFILE_MAPPINGS_TL is referenced by following:
Description: | Contains metadata information about base and extended profile properties that is application specific. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PROFILE_METADATA_B.SUBSCRIBED_PROFILES_ID | JTF_SUBSCRIBED_PROFILES |
JTF_PROFILE_METADATA_B.PROFILEPROPERTIES_ID | JTF_PROFILEPROPERTIES_B |
JTF_PROFILE_METADATA_B.PROFILE_RULES_ID | JTF_PROFILE_RULES_B |
Foreign Key Column | Foreign Table |
---|---|
JTF_PROFILE_METADATA_TL.PROFILE_METADATA_ID | JTF_PROFILE_METADATA_B |
JTF_PROFILE_RULES_B.PROFILE_METADATA_ID | JTF_PROFILE_METADATA_B |
JTF.JTF_PROFILE_METADATA_B does not reference any database object
JTF.JTF_PROFILE_METADATA_B is referenced by following:
Description: | Translation table that contains metdata for profile columns |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PROFILE_METADATA_TL.PROFILE_METADATA_ID | JTF_PROFILE_METADATA_B |
JTF.JTF_PROFILE_METADATA_TL does not reference any database object
JTF.JTF_PROFILE_METADATA_TL is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PROFILE_RULES_B.PROFILE_METADATA_ID | JTF_PROFILE_METADATA_B |
Foreign Key Column | Foreign Table |
---|---|
JTF_PROFILE_METADATA_B.PROFILE_RULES_ID | JTF_PROFILE_RULES_B |
JTF_PROFILE_RULES_TL.PROFILE_RULES_ID | JTF_PROFILE_RULES_B |
JTF.JTF_PROFILE_RULES_B does not reference any database object
JTF.JTF_PROFILE_RULES_B is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_PROFILE_RULES_TL.PROFILE_RULES_ID | JTF_PROFILE_RULES_B |
JTF.JTF_PROFILE_RULES_TL does not reference any database object
JTF.JTF_PROFILE_RULES_TL is referenced by following:
Description: | This table will store the different transaction types that are processed by territories. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_QUAL_TYPE_USGS_ALL.QUAL_TYPE_ID | JTF_QUAL_TYPES_ALL |
JTF.JTF_QUAL_TYPES_ALL does not reference any database object
JTF.JTF_QUAL_TYPES_ALL is referenced by following:
Description: | This is an intersection table between JTF_SOURCES and JTF_QUAL_TYPES. This is the source of the qualifier type. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_QUAL_TYPE_USGS_ALL.QUAL_TYPE_ID | JTF_QUAL_TYPES_ALL |
JTF_QUAL_TYPE_USGS_ALL.SOURCE_ID | JTF_SOURCES_ALL |
Foreign Key Column | Foreign Table |
---|---|
JTF_QUAL_USGS_ALL.QUAL_TYPE_USG_ID | JTF_QUAL_TYPE_USGS_ALL |
JTF_TERR_QTYPE_USGS_ALL.QUAL_TYPE_USG_ID | JTF_QUAL_TYPE_USGS_ALL |
JTF_TYPE_QTYPE_USGS_ALL.QUAL_TYPE_USG_ID | JTF_QUAL_TYPE_USGS_ALL |
JTF.JTF_QUAL_TYPE_USGS_ALL does not reference any database object
JTF.JTF_QUAL_TYPE_USGS_ALL is referenced by following:
Description: | This table stores the association between a qualifer and the transaction type of a source via JTF_QUAL_TYPE_USGS (stores association between SOURCES/QUALIFER TYPES tables). |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_QUAL_USGS_ALL.SEEDED_QUAL_ID | JTF_SEEDED_QUAL_ALL_B |
JTF_QUAL_USGS_ALL.QUAL_TYPE_USG_ID | JTF_QUAL_TYPE_USGS_ALL |
Foreign Key Column | Foreign Table |
---|---|
JTF_TERR_QUAL_ALL.QUAL_USG_ID | JTF_QUAL_USGS_ALL |
JTF_TERR_TYPE_QUAL_ALL.QUAL_USG_ID | JTF_QUAL_USGS_ALL |
JTF_TTY_ACCT_QUAL_MAPS.QUAL_USG_ID | JTF_QUAL_USGS_ALL |
JTF.JTF_QUAL_USGS_ALL does not reference any database object
JTF.JTF_QUAL_USGS_ALL is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_QUERYDETAILS.QUERYOBJECT_ID | JTF_QUERYOBJECT |
JTF.JTF_QUERYDETAILS does not reference any database object
JTF.JTF_QUERYDETAILS is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_QUERYDETAILS.QUERYOBJECT_ID | JTF_QUERYOBJECT |
JTF.JTF_QUERYOBJECT does not reference any database object
JTF.JTF_QUERYOBJECT is referenced by following:
Description: | This Table contains only active group membership detais. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_RS_ACTIVE_GRP_MBRS.GROUP_MEMBER_ID | JTF_RS_GROUP_MEMBERS |
JTF_RS_ACTIVE_GRP_MBRS.GROUP_ID | JTF_RS_GROUPS_B |
JTF_RS_ACTIVE_GRP_MBRS.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF.JTF_RS_ACTIVE_GRP_MBRS does not reference any database object
JTF.JTF_RS_ACTIVE_GRP_MBRS is referenced by following:
Description: | This table stores the relations between Groups. Primary key is Group_relate_id. Ex. for relation_type is 'PARENT_GROUP' (Similar to JTF_RS_GRP_RELATIONS with a OPERATION_FLAG Column added) |
---|
JTF.JTF_RS_CHGD_GRP_RELATIONS does not reference any database object
JTF.JTF_RS_CHGD_GRP_RELATIONS is referenced by following:
Description: | This table stores the relations between Groups. Primary key is Group_relate_id. Ex. for relation_type is 'PARENT_GROUP' (Similar to JTF_RS_GRP_RELATIONS with a OPERATION_FLAG Column added) |
---|
JTF.JTF_RS_CHGD_ROLE_RELATIONS does not reference any database object
JTF.JTF_RS_CHGD_ROLE_RELATIONS is referenced by following:
Description: |
---|
JTF.JTF_RS_DBI_DENORM_RES_GROUPS does not reference any database object
JTF.JTF_RS_DBI_DENORM_RES_GROUPS is referenced by following:
Description: |
---|
JTF.JTF_RS_DBI_MGR_GROUPS does not reference any database object
JTF.JTF_RS_DBI_MGR_GROUPS is referenced by following:
Description: |
---|
JTF.JTF_RS_DEFAULT_GROUPS does not reference any database object
JTF.JTF_RS_DEFAULT_GROUPS is referenced by following:
Description: |
---|
JTF.JTF_RS_DEFAULT_GROUPS_INT does not reference any database object
JTF.JTF_RS_DEFAULT_GROUPS_INT is referenced by following:
Description: |
---|
JTF.JTF_RS_DEFAULT_GROUPS_STAGE does not reference any database object
JTF.JTF_RS_DEFAULT_GROUPS_STAGE is referenced by following:
Description: | Base Table JTF_RS_DYNAMIC_GROUPS_B stores general information about a given Dynamic Group. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_RS_DYNAMIC_GROUPS_TL.GROUP_ID | JTF_RS_DYNAMIC_GROUPS_B |
JTF.JTF_RS_DYNAMIC_GROUPS_B does not reference any database object
JTF.JTF_RS_DYNAMIC_GROUPS_B is referenced by following:
Description: | Translation table for JTF_RS_DYNAMIC_GROUPS_B. It is used to store all columns and data that are needed for Multi-Language Support. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_RS_DYNAMIC_GROUPS_TL.GROUP_ID | JTF_RS_DYNAMIC_GROUPS_B |
JTF.JTF_RS_DYNAMIC_GROUPS_TL does not reference any database object
JTF.JTF_RS_DYNAMIC_GROUPS_TL is referenced by following:
Description: | Base Table which stores audit information for a Group. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_RS_GROUPS_AUD_B.GROUP_ID | JTF_RS_GROUPS_B |
Foreign Key Column | Foreign Table |
---|---|
JTF_RS_GROUPS_AUD_TL.GROUP_AUDIT_ID | JTF_RS_GROUPS_AUD_B |
JTF.JTF_RS_GROUPS_AUD_B does not reference any database object
JTF.JTF_RS_GROUPS_AUD_B is referenced by following:
Description: | Translation Table which stores audit information for a Group. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_RS_GROUPS_AUD_TL.GROUP_AUDIT_ID | JTF_RS_GROUPS_AUD_B |
JTF.JTF_RS_GROUPS_AUD_TL does not reference any database object
JTF.JTF_RS_GROUPS_AUD_TL is referenced by following:
Description: | Base Table JTF_RS_GROUPS_B stores general information about a given Group. |
---|
Foreign Key Column | Foreign Table |
---|---|
AMS_ACT_ACCESS.USER_OR_ROLE_ID | JTF_RS_GROUPS_B |
AMV_U_ACCESS.USER_OR_GROUP_ID | JTF_RS_GROUPS_B |
AMV_U_MY_CHANNELS.USER_OR_GROUP_ID | JTF_RS_GROUPS_B |
AR_COLLECTORS.RESOURCE_ID | JTF_RS_GROUPS_B |
AR_REVENUE_ADJUSTMENTS_ALL.FROM_SALESGROUP_ID | JTF_RS_GROUPS_B |
AR_REVENUE_ADJUSTMENTS_ALL.TO_SALESGROUP_ID | JTF_RS_GROUPS_B |
ASO_APR_APPROVAL_DET_B.JTF_RS_APPROVER_GROUP_ID | JTF_RS_GROUPS_B |
ASO_APR_RULE_APPROVERS.JTF_RS_APPROVER_GROUP_ID | JTF_RS_GROUPS_B |
ASO_SALES_CREDITS.RESOURCE_GROUP_ID | JTF_RS_GROUPS_B |
AS_ACCESSES_ALL_ALL.SALES_GROUP_ID | JTF_RS_GROUPS_B |
AS_ACCESSES_ALL_ALL.SALES_GROUP_ID | JTF_RS_GROUPS_B |
AS_FORECAST_ACTUALS.SALES_GROUP_ID | JTF_RS_GROUPS_B |
AS_INTERNAL_FORECASTS.SALES_GROUP_ID | JTF_RS_GROUPS_B |
AS_LEADS_ALL.OWNER_SALES_GROUP_ID | JTF_RS_GROUPS_B |
AS_SALES_CREDITS_DENORM.SALES_GROUP_ID | JTF_RS_GROUPS_B |
AS_SALES_CREDITS.SALESGROUP_ID | JTF_RS_GROUPS_B |
AS_SALES_LEADS.ASSIGN_SALES_GROUP_ID | JTF_RS_GROUPS_B |
AS_TERR_RESOURCES_TMP.RESOURCE_GROUP_ID | JTF_RS_GROUPS_B |
CSF_PLAN_TERRS.GROUP_ID | JTF_RS_GROUPS_B |
CSS_DEF_DEFECTS_B.PHASE_OWNER_ID | JTF_RS_GROUPS_B |
CSS_DEF_DEF_CONTACTS.OBJECT_ID | JTF_RS_GROUPS_B |
CS_INCIDENTS_ALL_B.INCIDENT_OWNER_ID | JTF_RS_GROUPS_B |
CUG_SR_TASK_TYPE_DETS_B.OWNER_ID | JTF_RS_GROUPS_B |
FII_AR_SALES_CREDITS.SALESGROUP_ID | JTF_RS_GROUPS_B |
AST_GRP_CAMPAIGNS.GROUP_ID | JTF_RS_GROUPS_B |
JTF_RS_ACTIVE_GRP_MBRS.GROUP_ID | JTF_RS_GROUPS_B |
JTF_RS_GROUPS_AUD_B.GROUP_ID | JTF_RS_GROUPS_B |
JTF_RS_GROUPS_DENORM.GROUP_ID | JTF_RS_GROUPS_B |
JTF_RS_GROUPS_DENORM.PARENT_GROUP_ID | JTF_RS_GROUPS_B |
JTF_RS_GROUPS_TL.GROUP_ID | JTF_RS_GROUPS_B |
JTF_RS_GROUP_MEMBERS.GROUP_ID | JTF_RS_GROUPS_B |
JTF_RS_GROUP_USAGES.GROUP_ID | JTF_RS_GROUPS_B |
JTF_RS_GRP_RELATIONS.GROUP_ID | JTF_RS_GROUPS_B |
JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID | JTF_RS_GROUPS_B |
JTF_RS_REP_MANAGERS.GROUP_ID | JTF_RS_GROUPS_B |
JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID | JTF_RS_GROUPS_B |
JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID | JTF_RS_GROUPS_B |
JTF_TERR_RSC_ALL.GROUP_ID | JTF_RS_GROUPS_B |
JTF_TTY_ACCT_RSC_DN.RSC_GROUP_ID | JTF_RS_GROUPS_B |
JTF_TTY_ALIGN_PTERR.RSC_GROUP_ID | JTF_RS_GROUPS_B |
JTF_TTY_NAMED_ACCT_RSC.RSC_GROUP_ID | JTF_RS_GROUPS_B |
JTF_TTY_RSC_ACCT_SUMM.RSC_GROUP_ID | JTF_RS_GROUPS_B |
JTF_TTY_TERR_GRP_OWNERS.RSC_GROUP_ID | JTF_RS_GROUPS_B |
OKC_K_ACCESSES.GROUP_ID | JTF_RS_GROUPS_B |
RA_CUST_TRX_LINE_SALESREPS_ALL.REVENUE_SALESGROUP_ID | JTF_RS_GROUPS_B |
RA_CUST_TRX_LINE_SALESREPS_ALL.NON_REVENUE_SALESGROUP_ID | JTF_RS_GROUPS_B |
RA_INTERFACE_SALESCREDITS_ALL.SALESGROUP_ID | JTF_RS_GROUPS_B |
JTF.JTF_RS_GROUPS_B does not reference any database object
JTF.JTF_RS_GROUPS_B is referenced by following:
Description: | This is a denormalized table for Group. It stores information about parent group and immediate parent flag. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_RS_GROUPS_DENORM.GROUP_ID | JTF_RS_GROUPS_B |
JTF_RS_GROUPS_DENORM.PARENT_GROUP_ID | JTF_RS_GROUPS_B |
JTF.JTF_RS_GROUPS_DENORM does not reference any database object
JTF.JTF_RS_GROUPS_DENORM is referenced by following:
Description: | Translation table for JTF_RS_GROUPS_B. It is used to store all columns and data that are needed for Multi-Language Support. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_RS_GROUPS_TL.GROUP_ID | JTF_RS_GROUPS_B |
JTF.JTF_RS_GROUPS_TL does not reference any database object
JTF.JTF_RS_GROUPS_TL is referenced by following:
Description: | This table stores the resources who are assigned to be group members. Primary key is Group_member_id. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_RS_GROUP_MEMBERS.GROUP_ID | JTF_RS_GROUPS_B |
JTF_RS_GROUP_MEMBERS.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
Foreign Key Column | Foreign Table |
---|---|
JTF_RS_ACTIVE_GRP_MBRS.GROUP_MEMBER_ID | JTF_RS_GROUP_MEMBERS |
JTF_RS_GROUP_MEMBERS_AUD.GROUP_MEMBER_ID | JTF_RS_GROUP_MEMBERS |
JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID | JTF_RS_GROUP_MEMBERS |
JTF.JTF_RS_GROUP_MEMBERS does not reference any database object
JTF.JTF_RS_GROUP_MEMBERS is referenced by following:
Description: | Table which stores audit information for a Group Members. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_RS_GROUP_MEMBERS_AUD.GROUP_MEMBER_ID | JTF_RS_GROUP_MEMBERS |
JTF.JTF_RS_GROUP_MEMBERS_AUD does not reference any database object
JTF.JTF_RS_GROUP_MEMBERS_AUD is referenced by following:
Description: |
---|
JTF.JTF_RS_GROUP_ORGANIZATIONS does not reference any database object
JTF.JTF_RS_GROUP_ORGANIZATIONS is referenced by following:
Description: | This table stores the usages which are assigned to be groups. Primary key is Group_usage_id. Group_id and usage are unique key. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_RS_GROUP_USAGES.GROUP_ID | JTF_RS_GROUPS_B |
JTF.JTF_RS_GROUP_USAGES does not reference any database object
JTF.JTF_RS_GROUP_USAGES is referenced by following:
Description: | The table that stores audit information for a group relation |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_RS_GRP_RELATE_AUD.GROUP_RELATE_ID | JTF_RS_GRP_RELATIONS |
JTF.JTF_RS_GRP_RELATE_AUD does not reference any database object
JTF.JTF_RS_GRP_RELATE_AUD is referenced by following:
Description: | This table stores the relations between Groups. Primary key is Group_relate_id. Ex. for relation_type is 'PARENT_GROUP' |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_RS_GRP_RELATIONS.GROUP_ID | JTF_RS_GROUPS_B |
JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID | JTF_RS_GROUPS_B |
Foreign Key Column | Foreign Table |
---|---|
JTF_RS_GRP_RELATE_AUD.GROUP_RELATE_ID | JTF_RS_GRP_RELATIONS |
JTF.JTF_RS_GRP_RELATIONS does not reference any database object
JTF.JTF_RS_GRP_RELATIONS is referenced by following:
Description: | This table stores the relations between roles and jobs. Primary key is job_role_id. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_RS_JOB_ROLES.ROLE_ID | JTF_RS_ROLES_B |
JTF.JTF_RS_JOB_ROLES does not reference any database object
JTF.JTF_RS_JOB_ROLES is referenced by following:
Description: | Denormalized table that stores the reporting hierarchy of group members |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_RS_REP_MANAGERS.GROUP_ID | JTF_RS_GROUPS_B |
JTF_RS_REP_MANAGERS.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF.JTF_RS_REP_MANAGERS does not reference any database object
JTF.JTF_RS_REP_MANAGERS is referenced by following:
Description: | This is a denormalized table for Resources. It stores hierarchial information about resources. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_RS_RESOURCE_DENORM.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF_RS_RESOURCE_DENORM.PARENT_RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF.JTF_RS_RESOURCE_DENORM does not reference any database object
JTF.JTF_RS_RESOURCE_DENORM is referenced by following:
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. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_RS_RESOURCE_EXTNS.CATEGORY | JTF_OBJECTS_B |
JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID | HZ_PARTY_SITES |
JTF_RS_RESOURCE_EXTNS.CONTACT_ID | HZ_ORG_CONTACTS |
Foreign Key Column | Foreign Table |
---|---|
AMS_ACT_ACCESS_DENORM.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
AMS_ACT_RESOURCES.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
AMS_CAMPAIGNS_ALL_B.OWNER_USER_ID | JTF_RS_RESOURCE_EXTNS |
AMS_CAMPAIGN_SCHEDULES_B.OWNER_USER_ID | JTF_RS_RESOURCE_EXTNS |
AMS_CAMPAIGN_SCHEDULES_B.APPROVER_USER_ID | JTF_RS_RESOURCE_EXTNS |
AMS_CAMPAIGN_SCHEDULES_B.NOTIFY_USER_ID | JTF_RS_RESOURCE_EXTNS |
AMS_CELLS_ALL_B.OWNER_ID | JTF_RS_RESOURCE_EXTNS |
AMS_DELIVERABLES_ALL_B.OWNER_USER_ID | JTF_RS_RESOURCE_EXTNS |
AMS_DIALOGS_ALL_B.OWNER_ID | JTF_RS_RESOURCE_EXTNS |
AMS_DM_MODELS_ALL_B.OWNER_USER_ID | JTF_RS_RESOURCE_EXTNS |
AMS_EVENT_HEADERS_ALL_B.OWNER_USER_ID | JTF_RS_RESOURCE_EXTNS |
AMS_EVENT_HEADERS_ALL_B.COORDINATOR_ID | JTF_RS_RESOURCE_EXTNS |
AMS_EVENT_OFFERS_ALL_B.COORDINATOR_ID | JTF_RS_RESOURCE_EXTNS |
AMS_EVENT_OFFERS_ALL_B.OWNER_USER_ID | JTF_RS_RESOURCE_EXTNS |
AMS_EVENT_REGISTRATIONS.OWNER_USER_ID | JTF_RS_RESOURCE_EXTNS |
AMS_IMP_LIST_HEADERS_ALL.OWNER_USER_ID | JTF_RS_RESOURCE_EXTNS |
AMS_ITEM_ATTRIBUTES.OWNER_ID | JTF_RS_RESOURCE_EXTNS |
AMS_MESSAGES_B.OWNER_USER_ID | JTF_RS_RESOURCE_EXTNS |
AMS_OFFERS.OWNER_ID | JTF_RS_RESOURCE_EXTNS |
AMS_PRICE_LIST_ATTRIBUTES.OWNER_ID | JTF_RS_RESOURCE_EXTNS |
AMS_TRIGGER_ACTIONS.ACTION_APPROVER_USER_ID | JTF_RS_RESOURCE_EXTNS |
AMV_C_CHANNELS_B.OWNER_USER_ID | JTF_RS_RESOURCE_EXTNS |
AMV_C_CHANNELS_B.DEFAULT_APPROVER_USER_ID | JTF_RS_RESOURCE_EXTNS |
AMV_USER_TICKER.USER_ID | JTF_RS_RESOURCE_EXTNS |
AMV_U_ACCESS.USER_OR_GROUP_ID | JTF_RS_RESOURCE_EXTNS |
AMV_U_MY_CHANNELS.USER_OR_GROUP_ID | JTF_RS_RESOURCE_EXTNS |
AR_COLLECTORS.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
ASG_DEVICE_USERS.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
ASO_APR_APPROVAL_DET_B.JTF_RS_APPROVER_ID | JTF_RS_RESOURCE_EXTNS |
ASO_SALES_CREDITS.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
AS_ACCESSES_ALL_ALL.SALESFORCE_ID | JTF_RS_RESOURCE_EXTNS |
AS_AP_STRTGC_OBJECTIVES.OWNER_SALESFORCE_ID | JTF_RS_RESOURCE_EXTNS |
AS_AP_TRACKING_OBJECTIVES.OWNER_SALESFORCE_ID | JTF_RS_RESOURCE_EXTNS |
AS_FORECAST_ACTUALS.SALESFORCE_ID | JTF_RS_RESOURCE_EXTNS |
AS_INTERNAL_FORECASTS.SALESFORCE_ID | JTF_RS_RESOURCE_EXTNS |
AS_LEADS_ALL.OWNER_SALESFORCE_ID | JTF_RS_RESOURCE_EXTNS |
AS_REF_ASSET_USAGES.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
AS_SALES_CREDITS_DENORM.SALESFORCE_ID | JTF_RS_RESOURCE_EXTNS |
AS_SALES_CREDITS.SALESFORCE_ID | JTF_RS_RESOURCE_EXTNS |
AS_SALES_LEADS.ASSIGN_TO_SALESFORCE_ID | JTF_RS_RESOURCE_EXTNS |
AS_TERR_RESOURCES_TMP.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
CSD_REPAIRS.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
CSD_REPAIRS.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
CSS_DEF_DEFECTS_B.PHASE_OWNER_ID | JTF_RS_RESOURCE_EXTNS |
CSS_DEF_DEF_CONTACTS.OBJECT_ID | JTF_RS_RESOURCE_EXTNS |
CS_CONTACTS.CONTACT_ID | JTF_RS_RESOURCE_EXTNS |
CS_INCIDENTS_ALL_B.INCIDENT_OWNER_ID | JTF_RS_RESOURCE_EXTNS |
CUG_SR_TASK_TYPE_DETS_B.OWNER_ID | JTF_RS_RESOURCE_EXTNS |
CUG_SR_TYPE_DUP_CHK_INFO.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
IEU_MSG_MESSAGES.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
IEU_UWQM_ITEMS.ASSIGNEE_ID | JTF_RS_RESOURCE_EXTNS |
IEU_UWQM_ITEMS.OWNER_ID | JTF_RS_RESOURCE_EXTNS |
IEX_STRATEGY_WORK_ITEMS.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF_CAL_ADDRESSES.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF_IH_INTERACTIONS.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF_RS_ACTIVE_GRP_MBRS.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF_RS_GROUP_MEMBERS.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF_RS_REP_MANAGERS.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF_RS_RESOURCE_DENORM.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF_RS_RESOURCE_DENORM.PARENT_RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF_RS_RESOURCE_EXTN_AUD.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF_RS_RESOURCE_VALUES.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF_RS_SALESREPS.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF_TERR_RSC_ALL.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF_TTY_ACCT_RSC_DN.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF_TTY_ALIGNMENTS.OWNER_RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF_TTY_ALIGN_PTERR.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF_TTY_NAMED_ACCT_RSC.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF_TTY_RSC_ACCT_SUMM.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF_TTY_TERR_GRP_OWNERS.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
LNS_LOAN_HEADERS_ALL.LOAN_ASSIGNED_TO | JTF_RS_RESOURCE_EXTNS |
LNS_LOAN_HEADERS_ALL.LOAN_APPROVED_BY | JTF_RS_RESOURCE_EXTNS |
PV_REFERRALS_B.PARTNER_CONTACT_RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
OKC_K_ACCESSES.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
OKC_REP_CONTRACT_ACCESS.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
OKL_INS_POLICIES_ALL_B.ADJUSTED_BY_ID | JTF_RS_RESOURCE_EXTNS |
OKL_INS_POLICIES_ALL_B.SALES_REP_ID | JTF_RS_RESOURCE_EXTNS |
OKL_INS_POLICIES_B.ADJUSTED_BY_ID | JTF_RS_RESOURCE_EXTNS |
OKL_INS_POLICIES_B.SALES_REP_ID | JTF_RS_RESOURCE_EXTNS |
OZF_OFFERS.OWNER_ID | JTF_RS_RESOURCE_EXTNS |
OZF_PRICE_LIST_ATTRIBUTES.OWNER_ID | JTF_RS_RESOURCE_EXTNS |
PA_RESOURCES.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
PV_COUNTRY_RSBLTS.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
PV_LEAD_ASSIGNMENTS.CM_ID | JTF_RS_RESOURCE_EXTNS |
PV_MDF_OWNERS.CMM_RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
PV_PARTNER_PROFILES.CM_ID | JTF_RS_RESOURCE_EXTNS |
PV_PARTNER_PROFILES.PH_SUPPORT_REP | JTF_RS_RESOURCE_EXTNS |
PV_PARTY_NOTIFICATIONS.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
PV_PG_ENRL_REQUESTS.REQUESTOR_RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
PV_RELATIONSHIPS.SUBJECT_ID | JTF_RS_RESOURCE_EXTNS |
AST_RS_CAMPAIGNS.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
Description: | This interface table is used for population of Resource entity in JTF_RS_RESOURCE_EXTNS and JTF_RS_RESOURCE_EXTNS_TL tables. |
---|
JTF.JTF_RS_RESOURCE_EXTNS_INT does not reference any database object
JTF.JTF_RS_RESOURCE_EXTNS_INT is referenced by following:
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. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF.JTF_RS_RESOURCE_EXTNS_TL does not reference any database object
JTF.JTF_RS_RESOURCE_EXTNS_TL is referenced by following:
Description: | The table that stores audit information for Resources |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_RS_RESOURCE_EXTN_AUD.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF_RS_RESOURCE_EXTN_AUD.OLD_SUPPORT_SITE_ID | HZ_PARTY_SITES |
JTF_RS_RESOURCE_EXTN_AUD.NEW_SUPPORT_SITE_ID | HZ_PARTY_SITES |
JTF_RS_RESOURCE_EXTN_AUD.NEW_CONTACT_ID | HZ_ORG_CONTACTS |
JTF_RS_RESOURCE_EXTN_AUD.OLD_CONTACT_ID | HZ_ORG_CONTACTS |
Description: | This table stores resource params. Resource_param_id is the primary key. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_RS_RESOURCE_VALUES.RESOURCE_PARAM_ID | JTF_RS_RESOURCE_PARAMS |
JTF.JTF_RS_RESOURCE_PARAMS does not reference any database object
JTF.JTF_RS_RESOURCE_PARAMS is referenced by following:
Description: | This table is used to store the Pictures of individual resources. |
---|
JTF.JTF_RS_RESOURCE_PICTURES does not reference any database object
JTF.JTF_RS_RESOURCE_PICTURES is referenced by following:
Description: | This table stores the skills for individual resource |
---|
JTF.JTF_RS_RESOURCE_SKILLS does not reference any database object
JTF.JTF_RS_RESOURCE_SKILLS is referenced by following:
Description: | This table stores resource values. Resource_param_value_id is the primary key. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_RS_RESOURCE_VALUES.RESOURCE_PARAM_ID | JTF_RS_RESOURCE_PARAMS |
JTF_RS_RESOURCE_VALUES.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF.JTF_RS_RESOURCE_VALUES does not reference any database object
JTF.JTF_RS_RESOURCE_VALUES is referenced by following:
Description: | This table stores those resources who are unavailable |
---|
JTF.JTF_RS_RES_AVAILABILITY does not reference any database object
JTF.JTF_RS_RES_AVAILABILITY is referenced by following:
Description: | Base Table JTF_RS_ROLES_B stores general information about a given Role. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_RS_JOB_ROLES.ROLE_ID | JTF_RS_ROLES_B |
JTF_RS_ROLES_TL.ROLE_ID | JTF_RS_ROLES_B |
JTF_RS_ROLE_RELATIONS.ROLE_ID | JTF_RS_ROLES_B |
JTF.JTF_RS_ROLES_B does not reference any database object
JTF.JTF_RS_ROLES_B is referenced by following:
Description: | Translation table for JTF_RS_ROLES_B. It is used to store all columns and data that are needed for Multi-Language Support. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_RS_ROLES_TL.ROLE_ID | JTF_RS_ROLES_B |
JTF.JTF_RS_ROLES_TL does not reference any database object
JTF.JTF_RS_ROLES_TL is referenced by following:
Description: | Base Table which stores audit information for a Role Relation. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_RS_ROLE_RELATE_AUD.ROLE_RELATE_ID | JTF_RS_ROLE_RELATIONS |
JTF.JTF_RS_ROLE_RELATE_AUD does not reference any database object
JTF.JTF_RS_ROLE_RELATE_AUD is referenced by following:
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. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_RS_ROLE_RELATIONS.ROLE_ID | JTF_RS_ROLES_B |
JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID | JTF_RS_TEAMS_B |
JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID | JTF_RS_TEAM_MEMBERS |
JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID | JTF_RS_GROUPS_B |
JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID | JTF_RS_GROUP_MEMBERS |
JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE | JTF_OBJECTS_B |
Foreign Key Column | Foreign Table |
---|---|
JTF_RS_ROLE_RELATE_AUD.ROLE_RELATE_ID | JTF_RS_ROLE_RELATIONS |
JTF.JTF_RS_ROLE_RELATIONS does not reference any database object
JTF.JTF_RS_ROLE_RELATIONS is referenced by following:
Description: | This table stores information about salesreps. Salesrep_id is the primary key. If resource category is 'OTHERS' then salesrep_number and org_id are unique. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_RS_SALESREPS.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
Foreign Key Column | Foreign Table |
---|---|
FII_AR_SALES_CREDITS.SALESREP_ID | JTF_RS_SALESREPS |
JTF_RS_SRP_TERRITORIES.SALESREP_ID | JTF_RS_SALESREPS |
JTF.JTF_RS_SALESREPS does not reference any database object
JTF.JTF_RS_SALESREPS is referenced by following:
Description: | This interface table is used for populating data in JTF_RS_SALESREPS table |
---|
JTF.JTF_RS_SALESREPS_INT does not reference any database object
JTF.JTF_RS_SALESREPS_INT is referenced by following:
Description: | This table stores the Skill Levels (Master Data) |
---|
JTF.JTF_RS_SKILL_LEVELS_B does not reference any database object
JTF.JTF_RS_SKILL_LEVELS_B is referenced by following:
Description: | This table stores the Skill Levels (Master Data) - TL table |
---|
JTF.JTF_RS_SKILL_LEVELS_TL does not reference any database object
JTF.JTF_RS_SKILL_LEVELS_TL is referenced by following:
Description: | This table stores the primary group id for salesreps. This table is populated by concurrent program 'Update Primary Sales Groups for Salespersons'. |
---|
JTF.JTF_RS_SRP_GROUPS does not reference any database object
JTF.JTF_RS_SRP_GROUPS is referenced by following:
Description: | This is intermediate table for defaulting of groups for salesreps |
---|
JTF.JTF_RS_SRP_GROUPS_INT does not reference any database object
JTF.JTF_RS_SRP_GROUPS_INT is referenced by following:
Description: |
---|
JTF.JTF_RS_SRP_GROUPS_STAGE does not reference any database object
JTF.JTF_RS_SRP_GROUPS_STAGE is referenced by following:
Description: | This table stores information about combination of salesrep and territories. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_RS_SRP_TERRITORIES.SALESREP_ID | JTF_RS_SALESREPS |
JTF.JTF_RS_SRP_TERRITORIES does not reference any database object
JTF.JTF_RS_SRP_TERRITORIES is referenced by following:
Description: | Base Table JTF_RS_TABLE_ATTRIBUTES_B stores general information of Table attributes that can be modified by users |
---|
JTF.JTF_RS_TABLE_ATTRIBUTES_B does not reference any database object
JTF.JTF_RS_TABLE_ATTRIBUTES_B is referenced by following:
Description: | Translation table for JTF_RS_TABLE_ATTRIBUTES_B. It is used to store all columns and data that are needed for Multi-Language Support. |
---|
JTF.JTF_RS_TABLE_ATTRIBUTES_TL does not reference any database object
JTF.JTF_RS_TABLE_ATTRIBUTES_TL is referenced by following:
Description: | Base Table JTF_RS_TEAMS_B stores general information about a given Team. |
---|
Foreign Key Column | Foreign Table |
---|---|
CSS_DEF_DEFECTS_B.PHASE_OWNER_ID | JTF_RS_TEAMS_B |
CSS_DEF_DEF_CONTACTS.OBJECT_ID | JTF_RS_TEAMS_B |
CS_INCIDENTS_ALL_B.INCIDENT_OWNER_ID | JTF_RS_TEAMS_B |
CUG_SR_TASK_TYPE_DETS_B.OWNER_ID | JTF_RS_TEAMS_B |
JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID | JTF_RS_TEAMS_B |
JTF_RS_TEAMS_TL.TEAM_ID | JTF_RS_TEAMS_B |
JTF_RS_TEAM_MEMBERS.TEAM_ID | JTF_RS_TEAMS_B |
JTF_RS_TEAM_USAGES.TEAM_ID | JTF_RS_TEAMS_B |
OKL_ASSET_RETURNS_B.RMR_ID | JTF_RS_TEAMS_B |
OKL_ASSET_RETURNS_ALL_B.RMR_ID | JTF_RS_TEAMS_B |
OKL_DF_CTGY_RMK_TMS.RMR_ID | JTF_RS_TEAMS_B |
OKL_DF_CTGY_RMK_TMS_ALL.RMR_ID | JTF_RS_TEAMS_B |
OKL_PRTFL_LINES_B.TMB_ID | JTF_RS_TEAMS_B |
JTF.JTF_RS_TEAMS_B does not reference any database object
JTF.JTF_RS_TEAMS_B is referenced by following:
Description: | Translation table for JTF_RS_TEAMS_B. It is used to store all columns and data that are needed for Multi-Language Support. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_RS_TEAMS_TL.TEAM_ID | JTF_RS_TEAMS_B |
JTF.JTF_RS_TEAMS_TL does not reference any database object
JTF.JTF_RS_TEAMS_TL is referenced by following:
Description: | This table stores the resources who are assigned to be team members. Primary key is Team_member_id. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_RS_TEAM_MEMBERS.TEAM_ID | JTF_RS_TEAMS_B |
JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID | JTF_RS_GROUPS_B |
Foreign Key Column | Foreign Table |
---|---|
JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID | JTF_RS_TEAM_MEMBERS |
JTF.JTF_RS_TEAM_MEMBERS does not reference any database object
JTF.JTF_RS_TEAM_MEMBERS is referenced by following:
Description: | This table stores the usages which are assigned to be teams. Primary key is team_usage_id. Team_id and usage are unique key. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_RS_TEAM_USAGES.TEAM_ID | JTF_RS_TEAMS_B |
JTF.JTF_RS_TEAM_USAGES does not reference any database object
JTF.JTF_RS_TEAM_USAGES is referenced by following:
Description: | This table stroes the information about upload data. |
---|
JTF.JTF_RS_UPLOAD_DATA does not reference any database object
JTF.JTF_RS_UPLOAD_DATA is referenced by following:
Description: | Store Rule Defintion name, and description |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_R_RULECONTEXTS.RULE_ID | JTF_R_RULES_B |
JTF.JTF_R_RULECONTEXTS does not reference any database object
JTF.JTF_R_RULECONTEXTS is referenced by following:
Description: | group a set of rules into an application unit |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_R_RULESETS_TL.RULESET_ID | JTF_R_RULESETS_B |
JTF_R_RULES_B.RULESET_ID | JTF_R_RULESETS_B |
JTF.JTF_R_RULESETS_B does not reference any database object
JTF.JTF_R_RULESETS_B is referenced by following:
Description: | Translated table to store description of rule set information |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_R_RULESETS_TL.RULESET_ID | JTF_R_RULESETS_B |
JTF.JTF_R_RULESETS_TL does not reference any database object
JTF.JTF_R_RULESETS_TL is referenced by following:
Description: | name and describes the condition and action of a rule |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_R_RULES_B.RULESET_ID | JTF_R_RULESETS_B |
Foreign Key Column | Foreign Table |
---|---|
JTF_R_RULECONTEXTS.RULE_ID | JTF_R_RULES_B |
JTF_R_RULES_TL.RULE_ID | JTF_R_RULES_B |
JTF.JTF_R_RULES_B does not reference any database object
JTF.JTF_R_RULES_B is referenced by following:
Description: | rule definition translation table |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_R_RULES_TL.RULE_ID | JTF_R_RULES_B |
JTF.JTF_R_RULES_TL does not reference any database object
JTF.JTF_R_RULES_TL is referenced by following:
Description: | This table will contain all the qualifiers that are going to be used to define territories. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_SEEDED_QUAL_ALL_TL.SEEDED_QUAL_ID | JTF_SEEDED_QUAL_ALL_B |
JTF_QUAL_USGS_ALL.SEEDED_QUAL_ID | JTF_SEEDED_QUAL_ALL_B |
JTF.JTF_SEEDED_QUAL_ALL_B does not reference any database object
JTF.JTF_SEEDED_QUAL_ALL_B is referenced by following:
Description: | This is the MLS support table for the JTF_SEEDED_QUAL_B table. This table will contain all the translations in different languages for the territory qualifiers that are going to be used to define territories. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_SEEDED_QUAL_ALL_TL.SEEDED_QUAL_ID | JTF_SEEDED_QUAL_ALL_B |
JTF.JTF_SEEDED_QUAL_ALL_TL does not reference any database object
JTF.JTF_SEEDED_QUAL_ALL_TL is referenced by following:
Description: | Group Column Name |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_QUAL_TYPE_USGS_ALL.SOURCE_ID | JTF_SOURCES_ALL |
JTF_TERR_TYPE_USGS_ALL.SOURCE_ID | JTF_SOURCES_ALL |
JTF_TERR_USGS_ALL.SOURCE_ID | JTF_SOURCES_ALL |
JTF.JTF_SOURCES_ALL does not reference any database object
JTF.JTF_SOURCES_ALL is referenced by following:
Description: | Intersection table between State Rules and Responsibilities. It associates Rules with Responsibilities. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_STATE_RESPONSIBILITIES.RULE_ID | JTF_STATE_RULES_B |
JTF.JTF_STATE_RESPONSIBILITIES does not reference any database object
JTF.JTF_STATE_RESPONSIBILITIES is referenced by following:
Description: | Base table which stores rule definitions |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_STATE_RULES_B.STATE_TYPE | JTF_OBJECTS_B |
JTF_STATE_RULES_B.APPLICATION_ID | FND_APPLICATION |
JTF_STATE_RULES_B.STATE_TYPE | JTF_OBJECTS_B |
Foreign Key Column | Foreign Table |
---|---|
JTF_STATE_RESPONSIBILITIES.RULE_ID | JTF_STATE_RULES_B |
JTF_STATE_TRANSITIONS.RULE_ID | JTF_STATE_RULES_B |
JTF.JTF_STATE_RULES_B does not reference any database object
JTF.JTF_STATE_RULES_B is referenced by following:
Description: | Translation table for JTF_STATE_RULES_B. |
---|
JTF.JTF_STATE_RULES_TL does not reference any database object
JTF.JTF_STATE_RULES_TL is referenced by following:
Description: | Table for State Transitions. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_STATE_TRANSITIONS.RULE_ID | % |
JTF_STATE_TRANSITIONS.RULE_ID | JTF_STATE_RULES_B |
JTF.JTF_STATE_TRANSITIONS does not reference any database object
JTF.JTF_STATE_TRANSITIONS is referenced by following:
Description: | Stores details of a WEB store. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_MSITES_B.STORE_ID | JTF_STORES_B |
JTF_STORES_TL.STORE_ID | JTF_STORES_B |
JTF.JTF_STORES_B does not reference any database object
JTF.JTF_STORES_B is referenced by following:
Description: | Translation for JTF_STORES_B |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_STORES_TL.STORE_ID | JTF_STORES_B |
JTF.JTF_STORES_TL does not reference any database object
JTF.JTF_STORES_TL is referenced by following:
Description: | A subscription table that indicates whether an application has subscribed to a profile. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_SUBSCRIBED_PROFILES.PROFILE_MAPPINGS_ID | JTF_PROFILE_MAPPINGS_B |
JTF_SUBSCRIBED_PROFILES.APPLICATION_ID | FND_APPLICATION |
Foreign Key Column | Foreign Table |
---|---|
JTF_PROFILE_METADATA_B.SUBSCRIBED_PROFILES_ID | JTF_SUBSCRIBED_PROFILES |
JTF.JTF_SUBSCRIBED_PROFILES does not reference any database object
JTF.JTF_SUBSCRIBED_PROFILES is referenced by following:
Description: | This table is obsolete |
---|
JTF.JTF_SYNC_REPLY_MSG does not reference any database object
JTF.JTF_SYNC_REPLY_MSG is referenced by following:
Description: | This table stores stores the input data for the new mode BULK TAE |
---|
JTF.JTF_TAE_1001_ACCOUNT_NM_TRANS does not reference any database object
JTF.JTF_TAE_1001_ACCOUNT_NM_TRANS is referenced by following:
Description: | This table stores the input data for the new mode BULK TAE. |
---|
JTF.JTF_TAE_1001_LEAD_NM_TRANS does not reference any database object
JTF.JTF_TAE_1001_LEAD_NM_TRANS is referenced by following:
Description: | This table stores the input data for the new mode BULK TAE. |
---|
JTF.JTF_TAE_1001_OPPOR_NM_TRANS does not reference any database object
JTF.JTF_TAE_1001_OPPOR_NM_TRANS is referenced by following:
Description: | This table stores the input data for the new mode BULK TAE. |
---|
JTF.JTF_TAE_1001_PROP_NM_TRANS does not reference any database object
JTF.JTF_TAE_1001_PROP_NM_TRANS is referenced by following:
Description: | This table stores the input data for the new mode BULK TAE. |
---|
JTF.JTF_TAE_1001_QUOTE_NM_TRANS does not reference any database object
JTF.JTF_TAE_1001_QUOTE_NM_TRANS is referenced by following:
Description: | This table stores the input data for the new mode BULK TAE. |
---|
JTF.JTF_TAE_1600_CUST_NM_TRANS does not reference any database object
JTF.JTF_TAE_1600_CUST_NM_TRANS is referenced by following:
Description: | This table stores the factor data for the qualifier. |
---|
JTF.JTF_TAE_QUAL_FACTORS does not reference any database object
JTF.JTF_TAE_QUAL_FACTORS is referenced by following:
Description: | This table stores the product for the qualifier. |
---|
JTF.JTF_TAE_QUAL_PRODUCTS does not reference any database object
JTF.JTF_TAE_QUAL_PRODUCTS is referenced by following:
Description: | This table stores the SQL hints for the qualifier combination. |
---|
JTF.JTF_TAE_QUAL_PRODUCTS_HINTS does not reference any database object
JTF.JTF_TAE_QUAL_PRODUCTS_HINTS is referenced by following:
Description: | This table stores the product factors for the qualifier combination. |
---|
JTF.JTF_TAE_QUAL_PROD_FACTORS does not reference any database object
JTF.JTF_TAE_QUAL_PROD_FACTORS is referenced by following:
Description: | This table stores the input data for the BULK TAE. |
---|
JTF.JTF_TAE_RPT_OBJS does not reference any database object
JTF.JTF_TAE_RPT_OBJS is referenced by following:
Description: | This table stores the matching territories for reports |
---|
JTF.JTF_TAE_RPT_OBJ_MATCHES does not reference any database object
JTF.JTF_TAE_RPT_OBJ_MATCHES is referenced by following:
Description: | This table stores winning territories |
---|
JTF.JTF_TAE_RPT_OBJ_WINNERS does not reference any database object
JTF.JTF_TAE_RPT_OBJ_WINNERS is referenced by following:
Description: | This table stores input data for reports |
---|
JTF.JTF_TAE_RPT_STAGING_IN does not reference any database object
JTF.JTF_TAE_RPT_STAGING_IN is referenced by following:
Description: | This table stores final output data from which report is rendered |
---|
JTF.JTF_TAE_RPT_STAGING_OUT does not reference any database object
JTF.JTF_TAE_RPT_STAGING_OUT is referenced by following:
Description: | Base Table JTF_TASKS_B stores general information about a given Task. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TASKS_B.SOURCE_OBJECT_TYPE_CODE | JTF_OBJECTS_B |
JTF_TASKS_B.CUST_ACCOUNT_ID | HZ_CUST_ACCOUNTS |
JTF_TASKS_B.ADDRESS_ID | HZ_PARTY_SITES |
JTF_TASKS_B.SOURCE_OBJECT_ID | CS_INCIDENTS_ALL_B |
JTF_TASKS_B.ASSIGNED_BY_ID | FND_USER |
JTF_TASKS_B.CUSTOMER_ID | HZ_PARTIES |
JTF_TASKS_B.SOURCE_OBJECT_TYPE_CODE | JTF_OBJECTS_B |
JTF_TASKS_B.TIMEZONE_ID | HZ_TIMEZONES |
JTF_TASKS_B.TASK_PRIORITY_ID | JTF_TASK_PRIORITIES_B |
JTF_TASKS_B.TASK_STATUS_ID | JTF_TASK_STATUSES_B |
JTF_TASKS_B.TASK_TYPE_ID | JTF_TASK_TYPES_B |
JTF_TASKS_B.RECURRENCE_RULE_ID | JTF_TASK_RECUR_RULES |
JTF_TASKS_B.CUSTOMER_ID | HZ_PARTIES |
JTF_TASKS_B.CURRENCY_CODE | FND_CURRENCIES |
JTF_TASKS_B.PARENT_TASK_ID | JTF_TASKS_B |
JTF_TASKS_B.SOURCE_OBJECT_TYPE_CODE | % |
JTF_TASKS_B.CUST_ACCOUNT_ID | HZ_CUST_ACCOUNTS |
JTF_TASKS_B.SOURCE_OBJECT_ID | CS_INCIDENTS_ALL_B |
JTF_TASKS_B.TASK_PRIORITY_ID | JTF_TASK_PRIORITIES_B |
JTF_TASKS_B.TASK_STATUS_ID | JTF_TASK_STATUSES_B |
JTF_TASKS_B.TASK_TYPE_ID | JTF_TASK_TYPES_B |
JTF_TASKS_B.RECURRENCE_RULE_ID | JTF_TASK_RECUR_RULES |
JTF_TASKS_B.SOURCE_OBJECT_TYPE_CODE | HZ_PARTIES |
JTF_TASKS_B.CURRENCY_CODE | FND_CURRENCIES |
JTF_TASKS_B.PARENT_TASK_ID | JTF_TASKS_B |
JTF_TASKS_B.SOURCE_OBJECT_TYPE_CODE | HZ_PARTIES |
JTF_TASKS_B.ADDRESS_ID | HZ_PARTY_SITES |
Foreign Key Column | Foreign Table |
---|---|
AMS_CAMPAIGNS_ALL_B.TASK_ID | JTF_TASKS_B |
AMS_CAMPAIGN_SCHEDULES_B.TASK_ID | JTF_TASKS_B |
AS_SALES_METH_TASK_MAP.TASK_ID | JTF_TASKS_B |
CSD_REPAIRS.TASK_ID | JTF_TASKS_B |
CSF_ACCESS_HOURS_B.TASK_ID | JTF_TASKS_B |
CSP_REQUIREMENT_HEADERS.TASK_ID | JTF_TASKS_B |
JTF_IH_ACTIVITIES.TASK_ID | JTF_TASKS_B |
JTF_TASKS_B.PARENT_TASK_ID | JTF_TASKS_B |
JTF_TASKS_B.PARENT_TASK_ID | JTF_TASKS_B |
JTF_TASK_ASSIGNMENTS.TASK_ID | JTF_TASKS_B |
JTF_TASK_AUDITS_B.TASK_ID | JTF_TASKS_B |
JTF_TASK_AUDITS_B.NEW_PARENT_TASK_ID | JTF_TASKS_B |
JTF_TASK_AUDITS_B.OLD_PARENT_TASK_ID | JTF_TASKS_B |
JTF_TASK_CONTACTS.TASK_ID | JTF_TASKS_B |
JTF_TASK_DATES.TASK_ID | JTF_TASKS_B |
JTF_TASK_DEPENDS.TASK_ID | JTF_TASKS_B |
JTF_TASK_DEPENDS.DEPENDENT_ON_TASK_ID | JTF_TASKS_B |
JTF_TASK_REFERENCES_B.TASK_ID | JTF_TASKS_B |
JTF_TASK_RSC_REQS.TASK_ID | JTF_TASKS_B |
JTF.JTF_TASKS_B does not reference any database object
JTF.JTF_TASKS_B is referenced by following:
Description: | Translation table for JTF_TASKS_B. It is used to store all columns and data that are needed for Multi-Language Support. |
---|
JTF.JTF_TASKS_TL does not reference any database object
JTF.JTF_TASKS_TL is referenced by following:
Description: | JTF_TASK_ASSIGNMENTS stores information about the resource assignments associated with the task. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TASK_ASSIGNMENTS.TASK_ID | JTF_TASKS_B |
JTF_TASK_ASSIGNMENTS.RESOURCE_TYPE_CODE | JTF_OBJECTS_B |
JTF_TASK_ASSIGNMENTS.SHIFT_CONSTRUCT_ID | JTF_CAL_SHIFT_CONSTRUCTS |
Foreign Key Column | Foreign Table |
---|---|
CSF_DEBRIEF_HEADERS.TASK_ASSIGNMENT_ID | JTF_TASK_ASSIGNMENTS |
CSP_REQUIREMENT_HEADERS.TASK_ASSIGNMENT_ID | JTF_TASK_ASSIGNMENTS |
JTF.JTF_TASK_ASSIGNMENTS does not reference any database object
JTF.JTF_TASK_ASSIGNMENTS is referenced by following:
Description: | Table for stroing changes in Task Assignments.It has row for every change in Task Assignment. |
---|
JTF.JTF_TASK_ASSIGNMENTS_AUDIT_B does not reference any database object
JTF.JTF_TASK_ASSIGNMENTS_AUDIT_B is referenced by following:
Description: | Base Table which stores audit information for a task. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TASK_AUDITS_B.TASK_ID | JTF_TASKS_B |
JTF_TASK_AUDITS_B.NEW_TASK_STATUS_ID | JTF_TASK_STATUSES_B |
JTF_TASK_AUDITS_B.NEW_PARENT_TASK_ID | JTF_TASKS_B |
JTF_TASK_AUDITS_B.NEW_TASK_TYPE_ID | JTF_TASK_TYPES_B |
JTF_TASK_AUDITS_B.OLD_TASK_TYPE_ID | JTF_TASK_TYPES_B |
JTF_TASK_AUDITS_B.OLD_ADDRESS_ID | HZ_PARTY_SITES |
JTF_TASK_AUDITS_B.OLD_ASSIGNED_BY_ID | FND_USER |
JTF_TASK_AUDITS_B.OLD_CUSTOMER_ID | HZ_PARTIES |
JTF_TASK_AUDITS_B.OLD_CUST_ACCOUNT_ID | HZ_CUST_ACCOUNTS |
JTF_TASK_AUDITS_B.OLD_PARENT_TASK_ID | JTF_TASKS_B |
JTF_TASK_AUDITS_B.OLD_RECURRENCE_RULE_ID | JTF_TASK_RECUR_RULES |
JTF_TASK_AUDITS_B.NEW_ADDRESS_ID | HZ_PARTY_SITES |
JTF_TASK_AUDITS_B.NEW_TIMEZONE_ID | HZ_TIMEZONES |
JTF_TASK_AUDITS_B.OLD_TIMEZONE_ID | HZ_TIMEZONES |
JTF_TASK_AUDITS_B.OLD_SOURCE_OBJECT_ID | CS_INCIDENTS_ALL_B |
JTF_TASK_AUDITS_B.NEW_SOURCE_OBJECT_ID | CS_INCIDENTS_ALL_B |
JTF_TASK_AUDITS_B.NEW_ASSIGNED_BY_ID | FND_USER |
JTF_TASK_AUDITS_B.NEW_CUSTOMER_ID | HZ_PARTIES |
JTF_TASK_AUDITS_B.NEW_CUST_ACCOUNT_ID | HZ_CUST_ACCOUNTS |
JTF_TASK_AUDITS_B.NEW_RECURRENCE_RULE_ID | JTF_TASK_RECUR_RULES |
JTF_TASK_AUDITS_B.NEW_TASK_PRIORITY_ID | JTF_TASK_PRIORITIES_B |
JTF_TASK_AUDITS_B.OLD_TASK_PRIORITY_ID | JTF_TASK_PRIORITIES_B |
JTF_TASK_AUDITS_B.OLD_TASK_STATUS_ID | JTF_TASK_STATUSES_B |
JTF_TASK_AUDITS_B.TASK_ID | % |
JTF.JTF_TASK_AUDITS_B does not reference any database object
JTF.JTF_TASK_AUDITS_B is referenced by following:
Description: | Translation table for JTF_TASKS_B. It is used to store all columns and data that are needed for Multi-Language Support. |
---|
JTF.JTF_TASK_AUDITS_TL does not reference any database object
JTF.JTF_TASK_AUDITS_TL is referenced by following:
Description: | JTF_TASK_CONTACTS stores the contact information for a given customer. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TASK_CONTACTS.TASK_ID | JTF_TASKS_B |
JTF_TASK_CONTACTS.CONTACT_ID | HZ_PARTIES |
Foreign Key Column | Foreign Table |
---|---|
JTF_TASK_PHONES.TASK_CONTACT_ID | JTF_TASK_CONTACTS |
JTF.JTF_TASK_CONTACTS does not reference any database object
JTF.JTF_TASK_CONTACTS is referenced by following:
Description: | This table stores the custom color setup |
---|
JTF.JTF_TASK_CUSTOM_COLORS does not reference any database object
JTF.JTF_TASK_CUSTOM_COLORS is referenced by following:
Description: | JTF_TASK_DATES stores the actual date values for a task.... |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TASK_DATES.TASK_ID | JTF_TASKS_B |
JTF_TASK_DATES.DATE_TYPE_ID | JTF_TASK_DATE_TYPES_B |
JTF.JTF_TASK_DATES does not reference any database object
JTF.JTF_TASK_DATES is referenced by following:
Description: | Allows for the description of date types other than those included as basic date types within JTF_TASK. For example, a customer may want to use a date called ACTIVATED DATE. This is not one of the date types within JTF_TASK. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TASK_DATE_TYPES_B.DATE_TYPE_ID | % |
Foreign Key Column | Foreign Table |
---|---|
JTF_TASK_DATES.DATE_TYPE_ID | JTF_TASK_DATE_TYPES_B |
JTF_TASK_DATE_TYPES_TL.DATE_TYPE_ID | JTF_TASK_DATE_TYPES_B |
JTF.JTF_TASK_DATE_TYPES_B does not reference any database object
JTF.JTF_TASK_DATE_TYPES_B is referenced by following:
Description: | Translation table for JTF_TASKS_B. It is used to store all columns and data that are needed for Multi-Language Support. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TASK_DATE_TYPES_TL.DATE_TYPE_ID | JTF_TASK_DATE_TYPES_B |
JTF.JTF_TASK_DATE_TYPES_TL does not reference any database object
JTF.JTF_TASK_DATE_TYPES_TL is referenced by following:
Description: | JTF_TASK_DEPENDS stores the dependency information between the two tasks. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TASK_DEPENDS.TASK_ID | JTF_TASKS_B |
JTF_TASK_DEPENDS.DEPENDENT_ON_TASK_ID | JTF_TASKS_B |
JTF_TASK_DEPENDS.TASK_ID | JTF_TASK_TEMPLATES_B |
JTF_TASK_DEPENDS.DEPENDENT_ON_TASK_ID | JTF_TASK_TEMPLATES_B |
JTF.JTF_TASK_DEPENDS does not reference any database object
JTF.JTF_TASK_DEPENDS is referenced by following:
Description: | JTF_TASK_PHONES contains stores pointer for contact phones. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TASK_PHONES.TASK_CONTACT_ID | JTF_TASK_CONTACTS |
JTF_TASK_PHONES.PHONE_ID | HZ_CONTACT_POINTS |
JTF.JTF_TASK_PHONES does not reference any database object
JTF.JTF_TASK_PHONES is referenced by following:
Description: | This table stores information for all task priorities. |
---|
Foreign Key Column | Foreign Table |
---|---|
CUG_SR_TASK_TYPE_DETS_B.TASK_PRIORITY_ID | JTF_TASK_PRIORITIES_B |
JTF_TASKS_B.TASK_PRIORITY_ID | JTF_TASK_PRIORITIES_B |
JTF_TASKS_B.TASK_PRIORITY_ID | JTF_TASK_PRIORITIES_B |
JTF_TASK_AUDITS_B.NEW_TASK_PRIORITY_ID | JTF_TASK_PRIORITIES_B |
JTF_TASK_AUDITS_B.OLD_TASK_PRIORITY_ID | JTF_TASK_PRIORITIES_B |
JTF_TASK_TEMPLATES_B.TASK_PRIORITY_ID | JTF_TASK_PRIORITIES_B |
JTF.JTF_TASK_PRIORITIES_B does not reference any database object
JTF.JTF_TASK_PRIORITIES_B is referenced by following:
Description: | Translation table for JTF_TASKS_B. It is used to store all columns and data that are needed for Multi-Language Support. |
---|
JTF.JTF_TASK_PRIORITIES_TL does not reference any database object
JTF.JTF_TASK_PRIORITIES_TL is referenced by following:
Description: |
---|
JTF.JTF_TASK_PURGE does not reference any database object
JTF.JTF_TASK_PURGE is referenced by following:
Description: | This table stores all the recurrence rules. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TASKS_B.RECURRENCE_RULE_ID | JTF_TASK_RECUR_RULES |
JTF_TASKS_B.RECURRENCE_RULE_ID | JTF_TASK_RECUR_RULES |
JTF_TASK_AUDITS_B.OLD_RECURRENCE_RULE_ID | JTF_TASK_RECUR_RULES |
JTF_TASK_AUDITS_B.NEW_RECURRENCE_RULE_ID | JTF_TASK_RECUR_RULES |
JTF_TASK_TEMPLATES_B.RECURRENCE_RULE_ID | JTF_TASK_RECUR_RULES |
JTF.JTF_TASK_RECUR_RULES does not reference any database object
JTF.JTF_TASK_RECUR_RULES is referenced by following:
Description: | JTF_TASK_REFERENCES stores the reference details for a given task. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TASK_REFERENCES_B.OBJECT_TYPE_CODE | JTF_OBJECTS_B |
JTF_TASK_REFERENCES_B.TASK_ID | JTF_TASKS_B |
JTF_TASK_REFERENCES_B.OBJECT_ID | CS_INCIDENTS_ALL_B |
JTF_TASK_REFERENCES_B.OBJECT_TYPE_CODE | % |
JTF_TASK_REFERENCES_B.TASK_ID | % |
JTF.JTF_TASK_REFERENCES_B does not reference any database object
JTF.JTF_TASK_REFERENCES_B is referenced by following:
Description: | Translation table for JTF_TASKS_B. It is used to store all columns and data that are needed for Multi-Language Support. |
---|
JTF.JTF_TASK_REFERENCES_TL does not reference any database object
JTF.JTF_TASK_REFERENCES_TL is referenced by following:
Description: | JTF_TASK_RSC_REQS contains the resource requirements for a task. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TASK_RSC_REQS.TASK_TEMPLATE_ID | JTF_TASK_TEMPLATES_B |
JTF_TASK_RSC_REQS.TASK_TYPE_ID | % |
JTF_TASK_RSC_REQS.TASK_ID | % |
JTF_TASK_RSC_REQS.RESOURCE_TYPE_CODE | % |
JTF_TASK_RSC_REQS.TASK_TEMPLATE_ID | JTF_TASK_TEMPLATES_B |
JTF_TASK_RSC_REQS.TASK_TYPE_ID | JTF_TASK_TYPES_B |
JTF_TASK_RSC_REQS.TASK_ID | JTF_TASKS_B |
JTF_TASK_RSC_REQS.RESOURCE_TYPE_CODE | JTF_OBJECTS_B |
JTF.JTF_TASK_RSC_REQS does not reference any database object
JTF.JTF_TASK_RSC_REQS is referenced by following:
Description: | JTF_TASK_STATUSES stores all the task statuses. |
---|
Foreign Key Column | Foreign Table |
---|---|
CUG_SR_TASK_TYPE_DETS_B.TASK_STATUS_ID | JTF_TASK_STATUSES_B |
JTF_TASKS_B.TASK_STATUS_ID | JTF_TASK_STATUSES_B |
JTF_TASKS_B.TASK_STATUS_ID | JTF_TASK_STATUSES_B |
JTF_TASK_AUDITS_B.NEW_TASK_STATUS_ID | JTF_TASK_STATUSES_B |
JTF_TASK_AUDITS_B.OLD_TASK_STATUS_ID | JTF_TASK_STATUSES_B |
JTF_TASK_TEMPLATES_B.TASK_STATUS_ID | JTF_TASK_STATUSES_B |
JTF.JTF_TASK_STATUSES_B does not reference any database object
JTF.JTF_TASK_STATUSES_B is referenced by following:
Description: | Translation table for JTF_TASKS_B. It is used to store all columns and data that are needed for Multi-Language Support. |
---|
JTF.JTF_TASK_STATUSES_TL does not reference any database object
JTF.JTF_TASK_STATUSES_TL is referenced by following:
Description: | JTF_TASK_TEMPLATES_B stores all the Task templates. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TASK_TEMPLATES_B.RECURRENCE_RULE_ID | JTF_TASK_RECUR_RULES |
JTF_TASK_TEMPLATES_B.TASK_GROUP_ID | JTF_TASK_TEMP_GROUPS_B |
JTF_TASK_TEMPLATES_B.TASK_TYPE_ID | JTF_TASK_TYPES_B |
JTF_TASK_TEMPLATES_B.TASK_STATUS_ID | JTF_TASK_STATUSES_B |
JTF_TASK_TEMPLATES_B.TASK_PRIORITY_ID | JTF_TASK_PRIORITIES_B |
JTF_TASK_TEMPLATES_B.RECURRENCE_RULE_ID | % |
JTF_TASK_TEMPLATES_B.TASK_GROUP_ID | JTF_TASK_TEMP_GROUPS_B |
JTF_TASK_TEMPLATES_B.TASK_TYPE_ID | % |
JTF_TASK_TEMPLATES_B.TASK_STATUS_ID | % |
JTF_TASK_TEMPLATES_B.TASK_PRIORITY_ID | % |
Foreign Key Column | Foreign Table |
---|---|
AS_SALES_METH_TASK_MAP.TASK_TEMPLATE_ID | JTF_TASK_TEMPLATES_B |
CSP_PRODUCT_TASKS.TASK_TEMPLATE_ID | JTF_TASK_TEMPLATES_B |
JTF_TASK_DEPENDS.TASK_ID | JTF_TASK_TEMPLATES_B |
JTF_TASK_DEPENDS.DEPENDENT_ON_TASK_ID | JTF_TASK_TEMPLATES_B |
JTF_TASK_RSC_REQS.TASK_TEMPLATE_ID | JTF_TASK_TEMPLATES_B |
JTF_TASK_RSC_REQS.TASK_TEMPLATE_ID | JTF_TASK_TEMPLATES_B |
JTF.JTF_TASK_TEMPLATES_B does not reference any database object
JTF.JTF_TASK_TEMPLATES_B is referenced by following:
Description: | Translation table for JTF_TASKS_B. It is used to store all columns and data that are needed for Multi-Language Support. |
---|
JTF.JTF_TASK_TEMPLATES_TL does not reference any database object
JTF.JTF_TASK_TEMPLATES_TL is referenced by following:
Description: | JTF_TASK_TEMPLATES_B stores all task template groups. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TASK_TEMP_GROUPS_B.SOURCE_OBJECT_TYPE_CODE | % |
JTF_TASK_TEMP_GROUPS_B.SOURCE_OBJECT_TYPE_CODE | JTF_OBJECTS_B |
Foreign Key Column | Foreign Table |
---|---|
AHL_ROUTES_B.TASK_TEMPLATE_GROUP_ID | JTF_TASK_TEMP_GROUPS_B |
AS_SALES_METH_STAGE_MAP.TASK_TEMPLATE_GROUP_ID | JTF_TASK_TEMP_GROUPS_B |
AS_SALES_METH_TASK_MAP.TASK_TEMPLATE_GROUP_ID | JTF_TASK_TEMP_GROUPS_B |
JTF_TASK_TEMPLATES_B.TASK_GROUP_ID | JTF_TASK_TEMP_GROUPS_B |
JTF_TASK_TEMPLATES_B.TASK_GROUP_ID | JTF_TASK_TEMP_GROUPS_B |
OZF_CLAIMS_ALL.TASK_TEMPLATE_GROUP_ID | JTF_TASK_TEMP_GROUPS_B |
OZF_REASONS.TASK_TEMPLATE_GROUP_ID | JTF_TASK_TEMP_GROUPS_B |
OZF_REASON_CODES_ALL_B.REASON_TYPE_ID | JTF_TASK_TEMP_GROUPS_B |
OZF_REASONS.TASK_TEMPLATE_GROUP_ID | JTF_TASK_TEMP_GROUPS_B |
XNC_CS_SR_TASK_MAP.TASK_TEMPLATE_GROUP_ID | JTF_TASK_TEMP_GROUPS_B |
JTF.JTF_TASK_TEMP_GROUPS_B does not reference any database object
JTF.JTF_TASK_TEMP_GROUPS_B is referenced by following:
Description: | Translation table for JTF_TASKS_B. It is used to store all columns and data that are needed for Multi-Language Support. |
---|
JTF.JTF_TASK_TEMP_GROUPS_TL does not reference any database object
JTF.JTF_TASK_TEMP_GROUPS_TL is referenced by following:
Description: | JTF_TASK_TYPES stores all task types. |
---|
Foreign Key Column | Foreign Table |
---|---|
CUG_TSK_TYP_ATTR_DEPS_B.TASK_TYPE_ID | JTF_TASK_TYPES_B |
CUG_TSK_TYP_ATTR_MAPS_B.TASK_TYPE_ID | JTF_TASK_TYPES_B |
JTF_TASKS_B.TASK_TYPE_ID | JTF_TASK_TYPES_B |
JTF_TASKS_B.TASK_TYPE_ID | JTF_TASK_TYPES_B |
JTF_TASK_AUDITS_B.NEW_TASK_TYPE_ID | JTF_TASK_TYPES_B |
JTF_TASK_AUDITS_B.OLD_TASK_TYPE_ID | JTF_TASK_TYPES_B |
JTF_TASK_RSC_REQS.TASK_TYPE_ID | JTF_TASK_TYPES_B |
JTF_TASK_TEMPLATES_B.TASK_TYPE_ID | JTF_TASK_TYPES_B |
JTF.JTF_TASK_TYPES_B does not reference any database object
JTF.JTF_TASK_TYPES_B is referenced by following:
Description: | Translation table for JTF_TASKS_B. It is used to store all columns and data that are needed for Multi-Language Support. |
---|
JTF.JTF_TASK_TYPES_TL does not reference any database object
JTF.JTF_TASK_TYPES_TL is referenced by following:
Description: | Stores the definition of the territories. There are 3 categories of territories, Standard, Escalation and Template. Information stored in this table also includes comment about this territory, effective dates, and what type of territory it |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TERR_ALL.PARENT_TERRITORY_ID | JTF_TERR_ALL |
JTF_TERR_ALL.TEMPLATE_TERRITORY_ID | JTF_TERR_ALL |
JTF_TERR_ALL.ESCALATION_TERRITORY_ID | JTF_TERR_ALL |
JTF_TERR_ALL.TERRITORY_TYPE_ID | JTF_TERR_TYPES_ALL |
Foreign Key Column | Foreign Table |
---|---|
AMS_BASE_SALES_VOL_ALL.MRKT_LEVEL_VALUE | JTF_TERR_ALL |
AS_TERRITORY_ACCESSES.TERRITORY_ID | JTF_TERR_ALL |
AS_TERR_RESOURCES_TMP.TERR_ID | JTF_TERR_ALL |
CSF_PLAN_TERRS.TERR_ID | JTF_TERR_ALL |
CSS_DEF_AUDIT_HISTORY_B.TERRITORY_ID | JTF_TERR_ALL |
CSS_DEF_DEFECTS_B.TERRITORY_ID | JTF_TERR_ALL |
JTF_CHANGED_TERR_ALL.TERR_ID | JTF_TERR_ALL |
JTF_EXCEPTIONS_ALL.TERR_ID | JTF_TERR_ALL |
JTF_TERR_ALL.PARENT_TERRITORY_ID | JTF_TERR_ALL |
JTF_TERR_ALL.TEMPLATE_TERRITORY_ID | JTF_TERR_ALL |
JTF_TERR_ALL.ESCALATION_TERRITORY_ID | JTF_TERR_ALL |
JTF_TERR_QTYPE_USGS_ALL.TERR_ID | JTF_TERR_ALL |
JTF_TERR_QUAL_ALL.TERR_ID | JTF_TERR_ALL |
JTF_TERR_RSC_ALL.TERR_ID | JTF_TERR_ALL |
JTF_TERR_USGS_ALL.TERR_ID | JTF_TERR_ALL |
JTF_TTY_TERR_GROUPS.PARENT_TERR_ID | JTF_TERR_ALL |
OKR_IP_RELEASES.TERR_ID | JTF_TERR_ALL |
JTF.JTF_TERR_ALL does not reference any database object
JTF.JTF_TERR_ALL is referenced by following:
Description: | Stores the Customer Name Range Groups. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TERR_CNR_GROUP_VALUES.CNR_GROUP_ID | JTF_TERR_CNR_GROUPS |
JTF.JTF_TERR_CNR_GROUPS does not reference any database object
JTF.JTF_TERR_CNR_GROUPS is referenced by following:
Description: | Stores the values that have been assigned to the territory qualifiers. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TERR_CNR_GROUP_VALUES.CNR_GROUP_ID | JTF_TERR_CNR_GROUPS |
JTF.JTF_TERR_CNR_GROUP_VALUES does not reference any database object
JTF.JTF_TERR_CNR_GROUP_VALUES is referenced by following:
Description: | Denormalized Territory tables for reporting purposes |
---|
JTF.JTF_TERR_DENORM does not reference any database object
JTF.JTF_TERR_DENORM is referenced by following:
Description: | Denormalized Territory tables for performance purposes |
---|
JTF.JTF_TERR_DENORM_ALL does not reference any database object
JTF.JTF_TERR_DENORM_ALL is referenced by following:
Description: | Denormalized Territory tables for performance purposes |
---|
JTF.JTF_TERR_DENORM_RULES_ALL does not reference any database object
JTF.JTF_TERR_DENORM_RULES_ALL is referenced by following:
Description: | Stores the transaction types that can be assigned to a territory. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TERR_QTYPE_USGS_ALL.TERR_ID | JTF_TERR_ALL |
JTF_TERR_QTYPE_USGS_ALL.QUAL_TYPE_USG_ID | JTF_QUAL_TYPE_USGS_ALL |
JTF.JTF_TERR_QTYPE_USGS_ALL does not reference any database object
JTF.JTF_TERR_QTYPE_USGS_ALL is referenced by following:
Description: | Stores the qualifiers that used to define a territory. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TERR_QUAL_ALL.TERR_ID | JTF_TERR_ALL |
JTF_TERR_QUAL_ALL.QUAL_USG_ID | JTF_QUAL_USGS_ALL |
Foreign Key Column | Foreign Table |
---|---|
JTF_TERR_VALUES_ALL.TERR_QUAL_ID | JTF_TERR_QUAL_ALL |
JTF.JTF_TERR_QUAL_ALL does not reference any database object
JTF.JTF_TERR_QUAL_ALL is referenced by following:
Description: |
---|
JTF.JTF_TERR_RESULTS does not reference any database object
JTF.JTF_TERR_RESULTS is referenced by following:
Description: |
---|
APPS.JTF_TERR_RESULTS_GT_L1 does not reference any database object
APPS.JTF_TERR_RESULTS_GT_L1 is referenced by following:
Description: |
---|
APPS.JTF_TERR_RESULTS_GT_L2 does not reference any database object
APPS.JTF_TERR_RESULTS_GT_L2 is referenced by following:
Description: |
---|
APPS.JTF_TERR_RESULTS_GT_L3 does not reference any database object
APPS.JTF_TERR_RESULTS_GT_L3 is referenced by following:
Description: |
---|
APPS.JTF_TERR_RESULTS_GT_L4 does not reference any database object
APPS.JTF_TERR_RESULTS_GT_L4 is referenced by following:
Description: |
---|
APPS.JTF_TERR_RESULTS_GT_L5 does not reference any database object
APPS.JTF_TERR_RESULTS_GT_L5 is referenced by following:
Description: |
---|
APPS.JTF_TERR_RESULTS_GT_MT does not reference any database object
APPS.JTF_TERR_RESULTS_GT_MT is referenced by following:
Description: |
---|
APPS.JTF_TERR_RESULTS_GT_WT does not reference any database object
APPS.JTF_TERR_RESULTS_GT_WT is referenced by following:
Description: | Stores the access type that a resource has to a territory. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TERR_RSC_ACCESS_ALL.TERR_RSC_ID | JTF_TERR_RSC_ALL |
JTF.JTF_TERR_RSC_ACCESS_ALL does not reference any database object
JTF.JTF_TERR_RSC_ACCESS_ALL is referenced by following:
Description: | Stores the resources that are assigned to a territory. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TERR_RSC_ALL.TERR_ID | JTF_TERR_ALL |
JTF_TERR_RSC_ALL.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF_TERR_RSC_ALL.GROUP_ID | JTF_RS_GROUPS_B |
Foreign Key Column | Foreign Table |
---|---|
JTF_TERR_RSC_ACCESS_ALL.TERR_RSC_ID | JTF_TERR_RSC_ALL |
JTF.JTF_TERR_RSC_ALL does not reference any database object
JTF.JTF_TERR_RSC_ALL is referenced by following:
Description: | Stores the territory type definition. It holds the information about the types of territories defined for your organisation. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TERR_ALL.TERRITORY_TYPE_ID | JTF_TERR_TYPES_ALL |
JTF_TERR_TYPE_QUAL_ALL.TERR_TYPE_ID | JTF_TERR_TYPES_ALL |
JTF_TERR_TYPE_USGS_ALL.TERR_TYPE_ID | JTF_TERR_TYPES_ALL |
JTF_TYPE_QTYPE_USGS_ALL.TERR_TYPE_ID | JTF_TERR_TYPES_ALL |
JTF.JTF_TERR_TYPES_ALL does not reference any database object
JTF.JTF_TERR_TYPES_ALL is referenced by following:
Description: | Stores the qualifiers that used to define a territory type. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TERR_TYPE_QUAL_ALL.QUAL_USG_ID | JTF_QUAL_USGS_ALL |
JTF_TERR_TYPE_QUAL_ALL.TERR_TYPE_ID | JTF_TERR_TYPES_ALL |
JTF.JTF_TERR_TYPE_QUAL_ALL does not reference any database object
JTF.JTF_TERR_TYPE_QUAL_ALL is referenced by following:
Description: | Stores the association between territory types and the Oracle Application module(s) that use them. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TERR_TYPE_USGS_ALL.SOURCE_ID | JTF_SOURCES_ALL |
JTF_TERR_TYPE_USGS_ALL.TERR_TYPE_ID | JTF_TERR_TYPES_ALL |
JTF.JTF_TERR_TYPE_USGS_ALL does not reference any database object
JTF.JTF_TERR_TYPE_USGS_ALL is referenced by following:
Description: | Stores the association between territories and the Oracle Application module(s) that use them. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TERR_USGS_ALL.SOURCE_ID | JTF_SOURCES_ALL |
JTF_TERR_USGS_ALL.TERR_ID | JTF_TERR_ALL |
JTF.JTF_TERR_USGS_ALL does not reference any database object
JTF.JTF_TERR_USGS_ALL is referenced by following:
Description: | Stores the values that have been assigned to the territory qualifiers. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TERR_VALUES_ALL.TERR_QUAL_ID | JTF_TERR_QUAL_ALL |
JTF.JTF_TERR_VALUES_ALL does not reference any database object
JTF.JTF_TERR_VALUES_ALL is referenced by following:
Description: | Stores Alignment metrics data for each Named Account. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TTY_ACCT_METRICS.NAMED_ACCOUNT_ID | JTF_TTY_NAMED_ACCTS |
JTF.JTF_TTY_ACCT_METRICS does not reference any database object
JTF.JTF_TTY_ACCT_METRICS is referenced by following:
Description: | This table stores mapping for Named Accounts |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TTY_ACCT_QUAL_MAPS.NAMED_ACCOUNT_ID | JTF_TTY_NAMED_ACCTS |
JTF_TTY_ACCT_QUAL_MAPS.QUAL_USG_ID | JTF_QUAL_USGS_ALL |
JTF.JTF_TTY_ACCT_QUAL_MAPS does not reference any database object
JTF.JTF_TTY_ACCT_QUAL_MAPS is referenced by following:
Description: | This table stores named account assignments in denormalized manner |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TTY_ACCT_RSC_DN.TERR_GROUP_ACCOUNT_ID | JTF_TTY_TERR_GRP_ACCTS |
JTF_TTY_ACCT_RSC_DN.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF_TTY_ACCT_RSC_DN.RSC_GROUP_ID | JTF_RS_GROUPS_B |
JTF.JTF_TTY_ACCT_RSC_DN does not reference any database object
JTF.JTF_TTY_ACCT_RSC_DN is referenced by following:
Description: | This table stores summarized data for territory administrator bins |
---|
JTF.JTF_TTY_ADMIN_BIN_SUMM does not reference any database object
JTF.JTF_TTY_ADMIN_BIN_SUMM is referenced by following:
Description: | Contains basic Alignment information |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TTY_ALIGNMENTS.OWNER_RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
Foreign Key Column | Foreign Table |
---|---|
JTF_TTY_ALIGN_ACCTS.ALIGNMENT_ID | JTF_TTY_ALIGNMENTS |
JTF_TTY_ALIGN_PTERR.ALIGNMENT_ID | JTF_TTY_ALIGNMENTS |
JTF.JTF_TTY_ALIGNMENTS does not reference any database object
JTF.JTF_TTY_ALIGNMENTS is referenced by following:
Description: | Stores Accounts used in an Alignment |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TTY_ALIGN_ACCTS.ALIGNMENT_ID | JTF_TTY_ALIGNMENTS |
JTF_TTY_ALIGN_ACCTS.TERR_GROUP_ACCOUNT_ID | JTF_TTY_TERR_GRP_ACCTS |
Foreign Key Column | Foreign Table |
---|---|
JTF_TTY_PTERR_ACCTS.ALIGN_ACCT_ID | JTF_TTY_ALIGN_ACCTS |
JTF.JTF_TTY_ALIGN_ACCTS does not reference any database object
JTF.JTF_TTY_ALIGN_ACCTS is referenced by following:
Description: | Stores the Resources used in the Alignment and their proposed quotas |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TTY_ALIGN_PTERR.ALIGNMENT_ID | JTF_TTY_ALIGNMENTS |
JTF_TTY_ALIGN_PTERR.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF_TTY_ALIGN_PTERR.RSC_GROUP_ID | JTF_RS_GROUPS_B |
Foreign Key Column | Foreign Table |
---|---|
JTF_TTY_PTERR_ACCTS.ALIGN_PROPOSED_TERR_ID | JTF_TTY_ALIGN_PTERR |
JTF_TTY_PTERR_METRICS.ALIGN_PROPOSED_TERR_ID | JTF_TTY_ALIGN_PTERR |
JTF.JTF_TTY_ALIGN_PTERR does not reference any database object
JTF.JTF_TTY_ALIGN_PTERR is referenced by following:
Description: | This table stores source geography data |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TTY_GEO_GRP_VALUES.GEO_ID_FROM | JTF_TTY_GEOGRAPHIES |
JTF_TTY_GEO_TERR_VALUES.GEO_ID | JTF_TTY_GEOGRAPHIES |
JTF.JTF_TTY_GEOGRAPHIES does not reference any database object
JTF.JTF_TTY_GEOGRAPHIES is referenced by following:
Description: | This table stores Geography Territory Group Values |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TTY_GEO_GRP_VALUES.GEO_ID_FROM | JTF_TTY_GEOGRAPHIES |
JTF.JTF_TTY_GEO_GRP_VALUES does not reference any database object
JTF.JTF_TTY_GEO_GRP_VALUES is referenced by following:
Description: | This table stores Geography Territory data |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TTY_GEO_TERR.TERR_GROUP_ID | JTF_TTY_TERR_GROUPS |
JTF_TTY_GEO_TERR.PARENT_GEO_TERR_ID | JTF_TTY_GEO_TERR |
Foreign Key Column | Foreign Table |
---|---|
JTF_TTY_GEO_TERR.PARENT_GEO_TERR_ID | JTF_TTY_GEO_TERR |
JTF_TTY_GEO_TERR_RSC.GEO_TERRITORY_ID | JTF_TTY_GEO_TERR |
JTF_TTY_GEO_TERR_VALUES.GEO_TERRITORY_ID | JTF_TTY_GEO_TERR |
JTF.JTF_TTY_GEO_TERR does not reference any database object
JTF.JTF_TTY_GEO_TERR is referenced by following:
Description: | This table stores sales person assignments for Geography Territories |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TTY_GEO_TERR_RSC.GEO_TERRITORY_ID | JTF_TTY_GEO_TERR |
JTF.JTF_TTY_GEO_TERR_RSC does not reference any database object
JTF.JTF_TTY_GEO_TERR_RSC is referenced by following:
Description: | This table stores geography territory values like postal code assignment |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TTY_GEO_TERR_VALUES.GEO_TERRITORY_ID | JTF_TTY_GEO_TERR |
JTF_TTY_GEO_TERR_VALUES.GEO_ID | JTF_TTY_GEOGRAPHIES |
JTF.JTF_TTY_GEO_TERR_VALUES does not reference any database object
JTF.JTF_TTY_GEO_TERR_VALUES is referenced by following:
Description: | Geography WEB ADI interface table |
---|
JTF.JTF_TTY_GEO_WEBADI_INTERFACE does not reference any database object
JTF.JTF_TTY_GEO_WEBADI_INTERFACE is referenced by following:
Description: | Stores Named Accounts |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TTY_NAMED_ACCTS.PARTY_ID | HZ_PARTIES |
Foreign Key Column | Foreign Table |
---|---|
JTF_TTY_ACCT_METRICS.NAMED_ACCOUNT_ID | JTF_TTY_NAMED_ACCTS |
JTF_TTY_ACCT_QUAL_MAPS.NAMED_ACCOUNT_ID | JTF_TTY_NAMED_ACCTS |
JTF_TTY_TERR_GRP_ACCTS.NAMED_ACCOUNT_ID | JTF_TTY_NAMED_ACCTS |
JTF.JTF_TTY_NAMED_ACCTS does not reference any database object
JTF.JTF_TTY_NAMED_ACCTS is referenced by following:
Description: | This table stores the changes in the self service territory groups. |
---|
JTF.JTF_TTY_NAMED_ACCT_CHANGES does not reference any database object
JTF.JTF_TTY_NAMED_ACCT_CHANGES is referenced by following:
Description: | Contains Named Account assignments. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TTY_NAMED_ACCT_RSC.TERR_GROUP_ACCOUNT_ID | JTF_TTY_TERR_GRP_ACCTS |
JTF_TTY_NAMED_ACCT_RSC.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF_TTY_NAMED_ACCT_RSC.RSC_GROUP_ID | JTF_RS_GROUPS_B |
JTF.JTF_TTY_NAMED_ACCT_RSC does not reference any database object
JTF.JTF_TTY_NAMED_ACCT_RSC is referenced by following:
Description: | Stores the Proposed Territory assignments in the Alignment |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TTY_PTERR_ACCTS.ALIGN_PROPOSED_TERR_ID | JTF_TTY_ALIGN_PTERR |
JTF_TTY_PTERR_ACCTS.ALIGN_ACCT_ID | JTF_TTY_ALIGN_ACCTS |
JTF.JTF_TTY_PTERR_ACCTS does not reference any database object
JTF.JTF_TTY_PTERR_ACCTS is referenced by following:
Description: | Stores Alignment metrics data for each Proposed Territory in an Alignment |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TTY_PTERR_METRICS.ALIGN_PROPOSED_TERR_ID | JTF_TTY_ALIGN_PTERR |
JTF.JTF_TTY_PTERR_METRICS does not reference any database object
JTF.JTF_TTY_PTERR_METRICS is referenced by following:
Description: | This table stores role access for territory groups |
---|
JTF.JTF_TTY_ROLE_ACCESS does not reference any database object
JTF.JTF_TTY_ROLE_ACCESS is referenced by following:
Description: | This table stores product interest for territory groups |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TTY_ROLE_PROD_INT.TERR_GROUP_ROLE_ID | JTF_TTY_TERR_GRP_ROLES |
JTF.JTF_TTY_ROLE_PROD_INT does not reference any database object
JTF.JTF_TTY_ROLE_PROD_INT is referenced by following:
Description: | This table stores summarized data for sales RM bin |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TTY_RSC_ACCT_SUMM.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF_TTY_RSC_ACCT_SUMM.RSC_GROUP_ID | JTF_RS_GROUPS_B |
JTF.JTF_TTY_RSC_ACCT_SUMM does not reference any database object
JTF.JTF_TTY_RSC_ACCT_SUMM is referenced by following:
Description: | This table stores territory group data |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TTY_TERR_GROUPS.PARENT_TERR_ID | JTF_TERR_ALL |
Foreign Key Column | Foreign Table |
---|---|
JTF_TTY_GEO_TERR.TERR_GROUP_ID | JTF_TTY_TERR_GROUPS |
JTF_TTY_TERR_GRP_ACCTS.TERR_GROUP_ID | JTF_TTY_TERR_GROUPS |
JTF_TTY_TERR_GRP_OWNERS.TERR_GROUP_ID | JTF_TTY_TERR_GROUPS |
JTF_TTY_TERR_GRP_ROLES.TERR_GROUP_ID | JTF_TTY_TERR_GROUPS |
JTF.JTF_TTY_TERR_GROUPS does not reference any database object
JTF.JTF_TTY_TERR_GROUPS is referenced by following:
Description: | This table stores named accounts information for territory groups |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TTY_TERR_GRP_ACCTS.NAMED_ACCOUNT_ID | JTF_TTY_NAMED_ACCTS |
JTF_TTY_TERR_GRP_ACCTS.TERR_GROUP_ID | JTF_TTY_TERR_GROUPS |
Foreign Key Column | Foreign Table |
---|---|
JTF_TTY_ACCT_RSC_DN.TERR_GROUP_ACCOUNT_ID | JTF_TTY_TERR_GRP_ACCTS |
JTF_TTY_ALIGN_ACCTS.TERR_GROUP_ACCOUNT_ID | JTF_TTY_TERR_GRP_ACCTS |
JTF_TTY_NAMED_ACCT_RSC.TERR_GROUP_ACCOUNT_ID | JTF_TTY_TERR_GRP_ACCTS |
JTF.JTF_TTY_TERR_GRP_ACCTS does not reference any database object
JTF.JTF_TTY_TERR_GRP_ACCTS is referenced by following:
Description: | This table stores owner information for territory groups |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TTY_TERR_GRP_OWNERS.TERR_GROUP_ID | JTF_TTY_TERR_GROUPS |
JTF_TTY_TERR_GRP_OWNERS.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
JTF_TTY_TERR_GRP_OWNERS.RSC_GROUP_ID | JTF_RS_GROUPS_B |
JTF.JTF_TTY_TERR_GRP_OWNERS does not reference any database object
JTF.JTF_TTY_TERR_GRP_OWNERS is referenced by following:
Description: | This table stores roles for Territory Groups |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TTY_TERR_GRP_ROLES.TERR_GROUP_ID | JTF_TTY_TERR_GROUPS |
Foreign Key Column | Foreign Table |
---|---|
JTF_TTY_ROLE_PROD_INT.TERR_GROUP_ROLE_ID | JTF_TTY_TERR_GRP_ROLES |
JTF.JTF_TTY_TERR_GRP_ROLES does not reference any database object
JTF.JTF_TTY_TERR_GRP_ROLES is referenced by following:
Description: | Interface table to store data that needs to be displayed in Excel |
---|
JTF.JTF_TTY_WEBADI_INTERFACE does not reference any database object
JTF.JTF_TTY_WEBADI_INTERFACE is referenced by following:
Description: | Interface table to store data that needs to be displayed in Excel |
---|
JTF.JTF_TTY_WEBADI_INTERFACES does not reference any database object
JTF.JTF_TTY_WEBADI_INTERFACES is referenced by following:
Description: | Stores the transaction types that can be assigned to a territory type. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_TYPE_QTYPE_USGS_ALL.TERR_TYPE_ID | JTF_TERR_TYPES_ALL |
JTF_TYPE_QTYPE_USGS_ALL.QUAL_TYPE_USG_ID | JTF_QUAL_TYPE_USGS_ALL |
JTF.JTF_TYPE_QTYPE_USGS_ALL does not reference any database object
JTF.JTF_TYPE_QTYPE_USGS_ALL is referenced by following:
Description: | . |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_UM_APPROVALS_B.WF_ITEM_TYPE | WF_ITEM_TYPES |
Foreign Key Column | Foreign Table |
---|---|
JTF_UM_APPROVALS_TL.APPROVAL_ID | JTF_UM_APPROVALS_B |
JTF_UM_APPROVERS.APPROVAL_ID | JTF_UM_APPROVALS_B |
JTF.JTF_UM_APPROVALS_B does not reference any database object
JTF.JTF_UM_APPROVALS_B is referenced by following:
Description: | Translation table for JTF_UM_APPROVALS_B. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_UM_APPROVALS_TL.APPROVAL_ID | JTF_UM_APPROVALS_B |
JTF.JTF_UM_APPROVALS_TL does not reference any database object
JTF.JTF_UM_APPROVALS_TL is referenced by following:
Description: | Defines the individual approvers for an approval (JTF_UM_APPROVAL_B). The approvers can be defined globally, as well as overridden for a given organization (HZ_PARTIES). Approvers don't necessarily have to be specified as fnd_user, we will |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_UM_APPROVERS.APPROVAL_ID | JTF_UM_APPROVALS_B |
JTF_UM_APPROVERS.ORG_PARTY_ID | HZ_PARTIES |
JTF_UM_APPROVERS.USER_ID | FND_USER |
JTF.JTF_UM_APPROVERS does not reference any database object
JTF.JTF_UM_APPROVERS is referenced by following:
Description: | An enrollment usually gives access to some specific part of the system through roles, permissions, and the responsibility defined for the enrollment. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_UM_SUBSCRIPTIONS_B.AUTH_DELEGATION_ROLE_ID | JTF_AUTH_PRINCIPALS_B |
Foreign Key Column | Foreign Table |
---|---|
JTF_UM_SUBSCRIPTIONS_TL.SUBSCRIPTION_ID | JTF_UM_SUBSCRIPTIONS_B |
JTF_UM_SUBSCRIPTION_REG.SUBSCRIPTION_ID | JTF_UM_SUBSCRIPTIONS_B |
JTF_UM_SUBSCRIPTION_RESP.SUBSCRIPTION_ID | JTF_UM_SUBSCRIPTIONS_B |
JTF_UM_SUBSCRIPTION_ROLE.SUBSCRIPTION_ID | JTF_UM_SUBSCRIPTIONS_B |
JTF_UM_SUBSCRIPTION_TMPL.SUBSCRIPTION_ID | JTF_UM_SUBSCRIPTIONS_B |
JTF_UM_USERTYPE_SUBSCRIP.SUBSCRIPTION_ID | JTF_UM_SUBSCRIPTIONS_B |
JTF.JTF_UM_SUBSCRIPTIONS_B does not reference any database object
JTF.JTF_UM_SUBSCRIPTIONS_B is referenced by following:
Description: | Translation table for JTF_UM_SUBSCRIPTIONS_B |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_UM_SUBSCRIPTIONS_TL.SUBSCRIPTION_ID | JTF_UM_SUBSCRIPTIONS_B |
JTF.JTF_UM_SUBSCRIPTIONS_TL does not reference any database object
JTF.JTF_UM_SUBSCRIPTIONS_TL is referenced by following:
Description: | Stores the enrollments that a user has signed up for, whether approved, rejected, pending, removed. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_UM_SUBSCRIPTION_REG.SUBSCRIPTION_ID | JTF_UM_SUBSCRIPTIONS_B |
JTF_UM_SUBSCRIPTION_REG.USER_ID | FND_USER |
JTF_UM_SUBSCRIPTION_REG.WF_ITEM_TYPE
JTF_UM_SUBSCRIPTION_REG.SUBSCRIPTION_REG_ID |
WF_ITEMS |
JTF_UM_SUBSCRIPTION_REG.APPROVER_USER_ID | FND_USER |
JTF.JTF_UM_SUBSCRIPTION_REG does not reference any database object
JTF.JTF_UM_SUBSCRIPTION_REG is referenced by following:
Description: | Intersection table which defines what responsibility is attached to each enrollment. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_UM_SUBSCRIPTION_RESP.SUBSCRIPTION_ID | JTF_UM_SUBSCRIPTIONS_B |
JTF.JTF_UM_SUBSCRIPTION_RESP does not reference any database object
JTF.JTF_UM_SUBSCRIPTION_RESP is referenced by following:
Description: | Intersection table which defines what roles are attached to each enrollment. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_UM_SUBSCRIPTION_ROLE.SUBSCRIPTION_ID | JTF_UM_SUBSCRIPTIONS_B |
JTF_UM_SUBSCRIPTION_ROLE.PRINCIPAL_NAME | JTF_AUTH_PRINCIPALS_B |
JTF.JTF_UM_SUBSCRIPTION_ROLE does not reference any database object
JTF.JTF_UM_SUBSCRIPTION_ROLE is referenced by following:
Description: | Intersection table where a subscription is attached to one or more templates. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_UM_SUBSCRIPTION_TMPL.SUBSCRIPTION_ID | JTF_UM_SUBSCRIPTIONS_B |
JTF_UM_SUBSCRIPTION_TMPL.TEMPLATE_ID | JTF_UM_TEMPLATES_B |
JTF.JTF_UM_SUBSCRIPTION_TMPL does not reference any database object
JTF.JTF_UM_SUBSCRIPTION_TMPL is referenced by following:
Description: | A template is used to capture information about the user for an enrollment or a usertype. A template is essentially one or more jsp pages as well as a template handler. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_UM_SUBSCRIPTION_TMPL.TEMPLATE_ID | JTF_UM_TEMPLATES_B |
JTF_UM_TEMPLATES_TL.TEMPLATE_ID | JTF_UM_TEMPLATES_B |
JTF_UM_USERTYPE_TMPL.TEMPLATE_ID | JTF_UM_TEMPLATES_B |
JTF.JTF_UM_TEMPLATES_B does not reference any database object
JTF.JTF_UM_TEMPLATES_B is referenced by following:
Description: | Translation table for JTF_UM_TEMPLATES_B. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_UM_TEMPLATES_TL.TEMPLATE_ID | JTF_UM_TEMPLATES_B |
JTF.JTF_UM_TEMPLATES_TL does not reference any database object
JTF.JTF_UM_TEMPLATES_TL is referenced by following:
Description: | . |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_UM_USERTYPES_TL.USERTYPE_ID | JTF_UM_USERTYPES_B |
JTF_UM_USERTYPE_REG.USERTYPE_ID | JTF_UM_USERTYPES_B |
JTF_UM_USERTYPE_RESP.USERTYPE_ID | JTF_UM_USERTYPES_B |
JTF_UM_USERTYPE_ROLE.USERTYPE_ID | JTF_UM_USERTYPES_B |
JTF_UM_USERTYPE_SUBSCRIP.USERTYPE_ID | JTF_UM_USERTYPES_B |
JTF_UM_USERTYPE_TMPL.USERTYPE_ID | JTF_UM_USERTYPES_B |
JTF.JTF_UM_USERTYPES_B does not reference any database object
JTF.JTF_UM_USERTYPES_B is referenced by following:
Description: | Translation table for JTF_UM_USERTYPES_B |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_UM_USERTYPES_TL.USERTYPE_ID | JTF_UM_USERTYPES_B |
JTF.JTF_UM_USERTYPES_TL does not reference any database object
JTF.JTF_UM_USERTYPES_TL is referenced by following:
Description: | Stores what usertype a user has been registered as. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_UM_USERTYPE_REG.USERTYPE_ID | JTF_UM_USERTYPES_B |
JTF_UM_USERTYPE_REG.USER_ID | FND_USER |
JTF_UM_USERTYPE_REG.WF_ITEM_TYPE
JTF_UM_USERTYPE_REG.USERTYPE_REG_ID |
WF_ITEMS |
JTF_UM_USERTYPE_REG.APPROVER_USER_ID | FND_USER |
JTF.JTF_UM_USERTYPE_REG does not reference any database object
JTF.JTF_UM_USERTYPE_REG is referenced by following:
Description: | Stores what responsibilities are attached to each usertype. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_UM_USERTYPE_RESP.USERTYPE_ID | JTF_UM_USERTYPES_B |
JTF.JTF_UM_USERTYPE_RESP does not reference any database object
JTF.JTF_UM_USERTYPE_RESP is referenced by following:
Description: | Stores what roles are assigned to each usertype. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_UM_USERTYPE_ROLE.USERTYPE_ID | JTF_UM_USERTYPES_B |
JTF_UM_USERTYPE_ROLE.PRINCIPAL_NAME | JTF_AUTH_PRINCIPALS_B |
JTF.JTF_UM_USERTYPE_ROLE does not reference any database object
JTF.JTF_UM_USERTYPE_ROLE is referenced by following:
Description: | Intersection table storing the enrollments that should be available to each usertype.. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_UM_USERTYPE_SUBSCRIP.USERTYPE_ID | JTF_UM_USERTYPES_B |
JTF_UM_USERTYPE_SUBSCRIP.SUBSCRIPTION_ID | JTF_UM_SUBSCRIPTIONS_B |
JTF.JTF_UM_USERTYPE_SUBSCRIP does not reference any database object
JTF.JTF_UM_USERTYPE_SUBSCRIP is referenced by following:
Description: | Intersection table where a usertype is attached to one or more templates. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_UM_USERTYPE_TMPL.USERTYPE_ID | JTF_UM_USERTYPES_B |
JTF_UM_USERTYPE_TMPL.TEMPLATE_ID | JTF_UM_TEMPLATES_B |
JTF.JTF_UM_USERTYPE_TMPL does not reference any database object
JTF.JTF_UM_USERTYPE_TMPL is referenced by following:
Description: | Stores Execution status for user hooks |
---|
JTF.JTF_USER_HOOKS does not reference any database object
JTF.JTF_USER_HOOKS is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_VAL_RULES.VAL_TYPE_ID | JTF_VAL_TYPES |
JTF.JTF_VAL_RULES does not reference any database object
JTF.JTF_VAL_RULES is referenced by following:
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_VAL_RULES.VAL_TYPE_ID | JTF_VAL_TYPES |
JTF.JTF_VAL_TYPES does not reference any database object
JTF.JTF_VAL_TYPES is referenced by following:
Description: | Mapping table between XML Services Events and XML Services Subscribers |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_XML_EVENT_MAPPINGS.INV_ID | JTF_XML_INVOCATIONS_B |
JTF_XML_EVENT_MAPPINGS.INV_SERVICE_ID | JTF_XML_INV_SERVICES_B |
JTF.JTF_XML_EVENT_MAPPINGS does not reference any database object
JTF.JTF_XML_EVENT_MAPPINGS is referenced by following:
Description: | Table that stores XML Services Events |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_XML_INVOCATIONS_B.APPLICATION_ID | FND_APPLICATION |
Foreign Key Column | Foreign Table |
---|---|
JTF_XML_EVENT_MAPPINGS.INV_ID | JTF_XML_INVOCATIONS_B |
JTF_XML_INVOCATIONS_TL.INV_ID | JTF_XML_INVOCATIONS_B |
JTF.JTF_XML_INVOCATIONS_B does not reference any database object
JTF.JTF_XML_INVOCATIONS_B is referenced by following:
Description: | Table that stores authentication profiles |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_XML_INV_SERVICES_B.AUTH_ID | JTF_XML_INV_AUTHS |
JTF.JTF_XML_INV_AUTHS does not reference any database object
JTF.JTF_XML_INV_AUTHS is referenced by following:
Description: | Table that stores input parameters info for an invocation |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_XML_INV_PARAMS.INV_SERVICE_ID | JTF_XML_INV_SERVICES_B |
JTF.JTF_XML_INV_PARAMS does not reference any database object
JTF.JTF_XML_INV_PARAMS is referenced by following:
Description: | Table that stores invocations. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_XML_INV_SERVICES_B.APPLICATION_ID | FND_APPLICATION |
JTF_XML_INV_SERVICES_B.AUTH_ID | JTF_XML_INV_AUTHS |
Foreign Key Column | Foreign Table |
---|---|
JTF_XML_EVENT_MAPPINGS.INV_SERVICE_ID | JTF_XML_INV_SERVICES_B |
JTF_XML_INV_PARAMS.INV_SERVICE_ID | JTF_XML_INV_SERVICES_B |
JTF_XML_INV_SERVICES_TL.INV_SERVICE_ID | JTF_XML_INV_SERVICES_B |
JTF_XML_INV_TMAPPINGS.INV_SERVICE_ID | JTF_XML_INV_SERVICES_B |
JTF.JTF_XML_INV_SERVICES_B does not reference any database object
JTF.JTF_XML_INV_SERVICES_B is referenced by following:
Description: | Table that stores type mapping info for the XML Services Client |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_XML_INV_TMAPPINGS.INV_SERVICE_ID | JTF_XML_INV_SERVICES_B |
JTF.JTF_XML_INV_TMAPPINGS does not reference any database object
JTF.JTF_XML_INV_TMAPPINGS is referenced by following:
Description: | Table that stores services. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_XML_SERVICES_B.SERVICE_GROUP_ID | JTF_XML_SVC_GROUPS_B |
Foreign Key Column | Foreign Table |
---|---|
JTF_XML_SERVICES_TL.SERVICE_ID | JTF_XML_SERVICES_B |
JTF.JTF_XML_SERVICES_B does not reference any database object
JTF.JTF_XML_SERVICES_B is referenced by following:
Description: | Table that stores the Service Groups. |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_XML_SVC_GROUPS_B.APPLICATION_ID | FND_APPLICATION |
Foreign Key Column | Foreign Table |
---|---|
JTF_XML_SERVICES_B.SERVICE_GROUP_ID | JTF_XML_SVC_GROUPS_B |
JTF_XML_SVC_GROUPS_TL.SERVICE_GROUP_ID | JTF_XML_SVC_GROUPS_B |
JTF_XML_TYPE_MAPPINGS.SERVICE_GROUP_ID | JTF_XML_SVC_GROUPS_B |
JTF.JTF_XML_SVC_GROUPS_B does not reference any database object
JTF.JTF_XML_SVC_GROUPS_B is referenced by following:
Description: | Table that stores typemapping information for the Execution Engine |
---|
Foreign Key Column | Foreign Table |
---|---|
JTF_XML_TYPE_MAPPINGS.SERVICE_GROUP_ID | JTF_XML_SVC_GROUPS_B |
JTF.JTF_XML_TYPE_MAPPINGS does not reference any database object
JTF.JTF_XML_TYPE_MAPPINGS is referenced by following:
Description: | This table stores denormalized territory values. |
---|
JTF.JTY_1001_DENORM_ATTR_VALUES does not reference any database object
JTF.JTY_1001_DENORM_ATTR_VALUES is referenced by following:
Description: | This table stores denormalized territory values for date effectivity assignment. |
---|
JTF.JTY_1001_DENORM_DEA_VALUES does not reference any database object
JTF.JTY_1001_DENORM_DEA_VALUES is referenced by following:
Description: | This table stores denormalized territory values. |
---|
JTF.JTY_1002_DENORM_ATTR_VALUES does not reference any database object
JTF.JTY_1002_DENORM_ATTR_VALUES is referenced by following:
Description: | This table stores denormalized territory values. |
---|
JTF.JTY_1003_DENORM_ATTR_VALUES does not reference any database object
JTF.JTY_1003_DENORM_ATTR_VALUES is referenced by following:
Description: | This table stores denormalized territory values. |
---|
JTF.JTY_1004_DENORM_ATTR_VALUES does not reference any database object
JTF.JTY_1004_DENORM_ATTR_VALUES is referenced by following:
Description: | This table stores denormalized territory values. |
---|
JTF.JTY_1500_DENORM_ATTR_VALUES does not reference any database object
JTF.JTY_1500_DENORM_ATTR_VALUES is referenced by following:
Description: | This table stores denormalized territory values. |
---|
JTF.JTY_1600_DENORM_ATTR_VALUES does not reference any database object
JTF.JTY_1600_DENORM_ATTR_VALUES is referenced by following:
Description: | This table stores denormalized territory values. |
---|
JTF.JTY_1700_DENORM_ATTR_VALUES does not reference any database object
JTF.JTY_1700_DENORM_ATTR_VALUES is referenced by following:
Description: |
---|
JTF.JTY_CHANGED_DEA_TERRS does not reference any database object
JTF.JTY_CHANGED_DEA_TERRS is referenced by following:
Description: | This table stores changed territories. |
---|
JTF.JTY_CHANGED_TERRS does not reference any database object
JTF.JTY_CHANGED_TERRS is referenced by following:
Description: |
---|
APPS.JTY_CHANGED_TERRS_GT does not reference any database object
APPS.JTY_CHANGED_TERRS_GT is referenced by following:
Description: | This table stores concurrent request summary. |
---|
JTF.JTY_CONC_REQ_SUMM does not reference any database object
JTF.JTY_CONC_REQ_SUMM is referenced by following:
Description: | This table stores attribute factors for date effectivity assignment. |
---|
JTF.JTY_DEA_ATTR_FACTORS does not reference any database object
JTF.JTY_DEA_ATTR_FACTORS is referenced by following:
Description: | This table stores attribute product for date effectivity assignment. |
---|
JTF.JTY_DEA_ATTR_PRODUCTS does not reference any database object
JTF.JTY_DEA_ATTR_PRODUCTS is referenced by following:
Description: | This table stores attribute product SQL for date effectivity assignment. |
---|
JTF.JTY_DEA_ATTR_PRODUCTS_SQL does not reference any database object
JTF.JTY_DEA_ATTR_PRODUCTS_SQL is referenced by following:
Description: | This table stores attribute product factors for date effectivity assignment. |
---|
JTF.JTY_DEA_ATTR_PROD_FACTORS does not reference any database object
JTF.JTY_DEA_ATTR_PROD_FACTORS is referenced by following:
Description: | This table stores indexes for date effectivity assignment. |
---|
JTF.JTY_DEA_VALUES_IDX_DETAILS does not reference any database object
JTF.JTY_DEA_VALUES_IDX_DETAILS is referenced by following:
Description: | This table stores indexes for date effectivity assignment. |
---|
JTF.JTY_DEA_VALUES_IDX_HEADER does not reference any database object
JTF.JTY_DEA_VALUES_IDX_HEADER is referenced by following:
Description: | This table stores denormalized territories for date effectivity assignment. |
---|
JTF.JTY_DENORM_DEA_RULES_ALL does not reference any database object
JTF.JTY_DENORM_DEA_RULES_ALL is referenced by following:
Description: |
---|
APPS.JTY_STR_TO_TABLE_GT does not reference any database object
APPS.JTY_STR_TO_TABLE_GT is referenced by following:
Description: | This table stores attribute product SQL for TAE. |
---|
JTF.JTY_TAE_ATTR_PRODUCTS_SQL does not reference any database object
JTF.JTY_TAE_ATTR_PRODUCTS_SQL is referenced by following:
Description: |
---|
APPS.JTY_TERR_1001_ACCOUNT_TRANS_GT does not reference any database object
APPS.JTY_TERR_1001_ACCOUNT_TRANS_GT is referenced by following:
Description: |
---|
APPS.JTY_TERR_1001_LEAD_TRANS_GT does not reference any database object
APPS.JTY_TERR_1001_LEAD_TRANS_GT is not referenced by any database object
Description: |
---|
APPS.JTY_TERR_1001_OPPOR_TRANS_GT does not reference any database object
APPS.JTY_TERR_1001_OPPOR_TRANS_GT is not referenced by any database object
Description: |
---|
APPS.JTY_TERR_1001_PROP_TRANS_GT does not reference any database object
APPS.JTY_TERR_1001_PROP_TRANS_GT is not referenced by any database object
Description: |
---|
APPS.JTY_TERR_1001_QUOTE_TRANS_GT does not reference any database object
APPS.JTY_TERR_1001_QUOTE_TRANS_GT is not referenced by any database object
Description: |
---|
APPS.JTY_TERR_1003_CLAIM_TRANS_GT does not reference any database object
APPS.JTY_TERR_1003_CLAIM_TRANS_GT is referenced by following:
Description: |
---|
APPS.JTY_TERR_1003_OFFER_TRANS_GT does not reference any database object
APPS.JTY_TERR_1003_OFFER_TRANS_GT is referenced by following:
Description: |
---|
APPS.JTY_TERR_1500_CNTRCT_TRANS_GT does not reference any database object
APPS.JTY_TERR_1500_CNTRCT_TRANS_GT is referenced by following:
Description: |
---|
APPS.JTY_TERR_1600_CUST_TRANS_GT does not reference any database object
APPS.JTY_TERR_1600_CUST_TRANS_GT is not referenced by any database object
Description: |
---|
APPS.JTY_TERR_1600_DELQCY_TRANS_GT does not reference any database object
APPS.JTY_TERR_1600_DELQCY_TRANS_GT is not referenced by any database object
Description: |
---|
APPS.JTY_TERR_1700_PARTNER_TRANS_GT does not reference any database object
APPS.JTY_TERR_1700_PARTNER_TRANS_GT is referenced by following:
Description: |
---|
APPS.JTY_TERR_NVP_TRANS_GT does not reference any database object
APPS.JTY_TERR_NVP_TRANS_GT is referenced by following:
Description: | This table stores indexes for territory values. |
---|
JTF.JTY_TERR_VALUES_IDX_DETAILS does not reference any database object
JTF.JTY_TERR_VALUES_IDX_DETAILS is referenced by following:
Description: | This table stores indexes for territory values. |
---|
JTF.JTY_TERR_VALUES_IDX_HEADER does not reference any database object
JTF.JTY_TERR_VALUES_IDX_HEADER is referenced by following:
Description: | This table stores program details for bulk TAE. |
---|
JTF.JTY_TRANS_USG_PGM_DETAILS does not reference any database object
JTF.JTY_TRANS_USG_PGM_DETAILS is referenced by following:
Description: | This table stores program SQL for bulk TAE. |
---|
JTF.JTY_TRANS_USG_PGM_SQL does not reference any database object
JTF.JTY_TRANS_USG_PGM_SQL is referenced by following:
Description: | Interface table to store data that needs to be displayed in Excel |
---|
JTF.JTY_WEBADI_OTH_TERR_INTF does not reference any database object
JTF.JTY_WEBADI_OTH_TERR_INTF is referenced by following:
Description: | Interface table to store data that needs to be displayed in Excel |
---|
JTF.JTY_WEBADI_QUAL_HEADER does not reference any database object
JTF.JTY_WEBADI_QUAL_HEADER is referenced by following:
Description: | Interface table to store data that needs to be displayed in Excel |
---|
JTF.JTY_WEBADI_QUAL_TYPE_HEADER does not reference any database object
JTF.JTY_WEBADI_QUAL_TYPE_HEADER is referenced by following:
Description: | Interface table to store data that needs to be displayed in Excel |
---|
JTF.JTY_WEBADI_RESOURCES does not reference any database object
JTF.JTY_WEBADI_RESOURCES is referenced by following:
APPS.CAC_SR_EXCEPTIONS_VL is not referenced by any database object
APPS.CAC_SR_PERIODS_VL is not referenced by any database object
APPS.CAC_SR_PERIOD_CATS_VL is not referenced by any database object
APPS.CAC_SR_PERIOD_DTL_TYPES_VL is not referenced by any database object
APPS.CAC_SR_SCHEDULES_VL is not referenced by any database object
APPS.CAC_SR_TEMPLATES_VL is not referenced by any database object
APPS.JTA_UM_MAIL_PREFERENCE_V is not referenced by any database object
APPS.JTF_AGENDA_TA_V is not referenced by any database object
APPS.JTF_AGENDA_V is not referenced by any database object
APPS.JTF_AMV_ITEM_AUTHORS_V is not referenced by any database object
APPS.JTF_AM_SCREEN_SETUPS_VL is not referenced by any database object
APPS.JTF_AM_TASK_DTLS_V is not referenced by any database object
APPS.JTF_BILLING_PREFERENCES_V is not referenced by any database object
APPS.JTF_BRM_3D_TASK_V is not referenced by any database object
APPS.JTF_BRM_EXPRESSION_LINES_V is not referenced by any database object
APPS.JTF_BRM_PARAMETERS_V is not referenced by any database object
APPS.JTF_BRM_RULES_V is not referenced by any database object
APPS.JTF_BRM_RULES_VL is not referenced by any database object
APPS.JTF_BRM_WF_ATTR_V is not referenced by any database object
APPS.JTF_BRM_WF_ATTR_VALUES_V is not referenced by any database object
APPS.JTF_CAL_EXCP_ASSIGN_V is not referenced by any database object
APPS.JTF_CAL_RES_ASSIGN_V is not referenced by any database object
APPS.JTF_CAL_SHIFT_ASSIGN_V is not referenced by any database object
APPS.JTF_CAL_SHIFT_CONS_V is not referenced by any database object
APPS.JTF_CONTACT_POINTS_V is not referenced by any database object
APPS.JTF_CONTACT_RESTRICTIONS_V is not referenced by any database object
APPS.JTF_CUSTOMER_PROFILES_V is not referenced by any database object
APPS.JTF_CUST_ACCOUNTS_ALL_V is not referenced by any database object
APPS.JTF_CUST_ACCOUNTS_ROLES_V is not referenced by any database object
APPS.JTF_CUST_ACCOUNTS_V is not referenced by any database object
APPS.JTF_CUST_ACCT_SITES_V is not referenced by any database object
APPS.JTF_DPF_LOGICAL_FLOWS_VL is not referenced by any database object
APPS.JTF_DPF_LOGICAL_PAGES_VL is not referenced by any database object
APPS.JTF_DPF_RULES_VL is not referenced by any database object
APPS.JTF_DSP_ATTACHMENTS_V is not referenced by any database object
APPS.JTF_DSP_CONTEXT_V is not referenced by any database object
APPS.JTF_DSP_FEATURED_MEDIA_V is not referenced by any database object
APPS.JTF_DSP_LGL_PHYS_MAP_V is not referenced by any database object
APPS.JTF_DSP_LGL_TEMPLATES_V is not referenced by any database object
APPS.JTF_DSP_OBJ_LGL_CTNT_V is not referenced by any database object
APPS.JTF_DSP_SECTIONS_VL is not referenced by any database object
APPS.JTF_DSP_TPL_CONTEXT_V is not referenced by any database object
APPS.JTF_DSP_TPL_CTG_V is not referenced by any database object
APPS.JTF_DSP_TPL_ITEM_CTG_V is not referenced by any database object
APPS.JTF_EC_ESC_CONTACTS_REF_DOCS is not referenced by any database object
APPS.JTF_EXCEPTIONS is not referenced by any database object
APPS.JTF_FM_AMV_ATTACH_VL is not referenced by any database object
APPS.JTF_FM_AMV_ITEMS_VL is not referenced by any database object
APPS.JTF_FM_CONTENT_HISTORY_V is not referenced by any database object
APPS.JTF_FM_DISPATCHERS_V is not referenced by any database object
APPS.JTF_FM_EMAIL_JTF_FM_GROUPS_V is not referenced by any database object
APPS.JTF_FM_EMAIL_STATS_V is not referenced by any database object
APPS.JTF_FM_EMAIL_V is not referenced by any database object
APPS.JTF_FM_FAILURES_V is not referenced by any database object
APPS.JTF_FM_FAX_JTF_FM_GROUPS_V is not referenced by any database object
APPS.JTF_FM_FAX_V is not referenced by any database object
APPS.JTF_FM_FILE_JTF_FM_GROUPS_V is not referenced by any database object
APPS.JTF_FM_FILE_V is not referenced by any database object
APPS.JTF_FM_FND_LOBS_V is not referenced by any database object
APPS.JTF_FM_FND_PRINTER_V is not referenced by any database object
APPS.JTF_FM_FND_USER_V is not referenced by any database object
APPS.JTF_FM_GROUP is not referenced by any database object
APPS.JTF_FM_GROUP_FND_USER_V is not referenced by any database object
APPS.JTF_FM_HIST_V is not referenced by any database object
APPS.JTF_FM_MASTER_DOC_V is not referenced by any database object
APPS.JTF_FM_PREVIEWS_V is not referenced by any database object
APPS.JTF_FM_PRINTER_JTF_FM_GROUPS_V is not referenced by any database object
APPS.JTF_FM_PRINTER_LOOKUPS_USERS_V is not referenced by any database object
APPS.JTF_FM_PRINTER_LOOKUPS_V is not referenced by any database object
APPS.JTF_FM_PRINTER_V is not referenced by any database object
APPS.JTF_FM_PROCESSED_V is not referenced by any database object
APPS.JTF_FM_QUERY is not referenced by any database object
APPS.JTF_FM_QUERY_MES_V is not referenced by any database object
APPS.JTF_FM_SERVICE is not referenced by any database object
APPS.JTF_FM_STATUS is not referenced by any database object
APPS.JTF_FM_TEMPLATE is not referenced by any database object
APPS.JTF_FM_TEMPLATE_CONTENTS_V is not referenced by any database object
APPS.JTF_FM_TEMPLATE_CONTENTS_V2 is not referenced by any database object
APPS.JTF_GRID_COLS_VL is not referenced by any database object
APPS.JTF_GRID_DATASOURCES_VL is not referenced by any database object
APPS.JTF_HZ_CUST_ACCT_RELATE_V is not referenced by any database object
APPS.JTF_HZ_ORGANIZATION_PROFILES_V is not referenced by any database object
APPS.JTF_HZ_PARTIES_V is not referenced by any database object
APPS.JTF_HZ_PARTY_LOCATIONS_V is not referenced by any database object
APPS.JTF_IAPP_FAMILIES_VL is not referenced by any database object
APPS.JTF_IH_ACTION_ACTION_ITEMS_VL is not referenced by any database object
APPS.JTF_IH_ACTIVE_ACTIONS_VL is not referenced by any database object
APPS.JTF_IH_ACTIVE_ACTION_ITEMS_VL is not referenced by any database object
APPS.JTF_IH_ACTIVE_OUTCOMES_VL is not referenced by any database object
APPS.JTF_IH_ACTIVE_REASONS_VL is not referenced by any database object
APPS.JTF_IH_ACTIVE_RESULTS_VL is not referenced by any database object
APPS.JTF_IH_ACTIVE_WRAP_UPS_VL is not referenced by any database object
APPS.JTF_IH_ACTIVITIES_V is not referenced by any database object
APPS.JTF_IH_ACTIVITIES_VL2 is not referenced by any database object
APPS.JTF_IH_ACTIVITIES_VL3 is not referenced by any database object
APPS.JTF_IH_ACTIVITIES_VL4 is not referenced by any database object
APPS.JTF_IH_ALL_NOTES_VL is not referenced by any database object
APPS.JTF_IH_INTERACTIONS_ONLY_VL is not referenced by any database object
APPS.JTF_IH_INTERACTIONS_VL is not referenced by any database object
APPS.JTF_IH_INTERACTIONS_VL2 is not referenced by any database object
APPS.JTF_IH_MEDIA_ITEMS_V is not referenced by any database object
APPS.JTF_IH_MEDIA_ITEM_LC_SEGS_V is not referenced by any database object
APPS.JTF_IH_NOTES_ACT_VL is not referenced by any database object
APPS.JTF_IH_NOTES_VL is not referenced by any database object
APPS.JTF_IH_OUTCOME_RESULTS_VL is not referenced by any database object
APPS.JTF_IH_RESULT_REASONS_VL is not referenced by any database object
APPS.JTF_IH_WRAPUP_OUTCOMES_VL is not referenced by any database object
APPS.JTF_IH_WRAPUP_REASONS_VL is not referenced by any database object
APPS.JTF_IH_WRAPUP_RESULTS_VL is not referenced by any database object
APPS.JTF_LOC_AREAS_VL is not referenced by any database object
APPS.JTF_LOC_HIERARCHIES_VL is not referenced by any database object
APPS.JTF_LOC_TYPES_VL is not referenced by any database object
APPS.JTF_LOOKUPS_AK_ATTRIBUTE_V is not referenced by any database object
APPS.JTF_MSITE_RESPS_VL is not referenced by any database object
APPS.JTF_NAV_TABS_VL is not referenced by any database object
APPS.JTF_NAV_VIEWBYS_VL is not referenced by any database object
APPS.JTF_NOTES_SOURCE_TYPE_MAP_V is not referenced by any database object
APPS.JTF_NOTE_CONTEXTS_V is not referenced by any database object
APPS.JTF_NOTE_TYPES_V is not referenced by any database object
APPS.JTF_OBJECT_USAGES_V is not referenced by any database object
APPS.JTF_ORG_CONTACTS_V is not referenced by any database object
APPS.JTF_PARTIES_ALL_V is not referenced by any database object
APPS.JTF_PARTIES_V is not referenced by any database object
APPS.JTF_PARTY_ACCOUNTS_V is not referenced by any database object
APPS.JTF_PARTY_ADDRESSES_V is not referenced by any database object
APPS.JTF_PARTY_ALL_CONTACTS_V is not referenced by any database object
APPS.JTF_PARTY_CONTACTS_V is not referenced by any database object
APPS.JTF_PARTY_CONT_POINTS_V is not referenced by any database object
APPS.JTF_PARTY_CUSTOMERS_V is not referenced by any database object
APPS.JTF_PARTY_LOCATIONS_V is not referenced by any database object
APPS.JTF_PARTY_PHONES_V is not referenced by any database object
APPS.JTF_PARTY_RELATIONSHIPS_V is not referenced by any database object
APPS.JTF_PC_CATEGORIES_VL is not referenced by any database object
APPS.JTF_PERZ_DATA_V is not referenced by any database object
APPS.JTF_PERZ_QUERY_PARAM_V is not referenced by any database object
APPS.JTF_PF_ALL_ACTIVITY_VL is not referenced by any database object
APPS.JTF_PF_APP_SUMMARY_VL is not referenced by any database object
APPS.JTF_PF_HOST_SUMMARY_VL is not referenced by any database object
APPS.JTF_PF_PAGE_SUMMARY_VL is not referenced by any database object
APPS.JTF_PF_SEQ_VL is not referenced by any database object
APPS.JTF_PF_SESSION_SUMMARY_VL is not referenced by any database object
APPS.JTF_PF_USER_SUMMARY_VL is not referenced by any database object
APPS.JTF_PREFAB_CA_COMPS_VL is not referenced by any database object
APPS.JTF_PREFAB_CA_FILTERS_VL is not referenced by any database object
APPS.JTF_PREFAB_FILTERS_VL is not referenced by any database object
APPS.JTF_PREFAB_POLICIES_VL is not referenced by any database object
APPS.JTF_PREFAB_UD_KEYS_VL is not referenced by any database object
APPS.JTF_PREFAB_WSH_POES_VL is not referenced by any database object
APPS.JTF_QUAL_TYPE_DENORM_V is not referenced by any database object
APPS.JTF_RS_ACTIVE_RESOURCES_VL is not referenced by any database object
APPS.JTF_RS_CCT_MIDDLEWARES_V is not referenced by any database object
APPS.JTF_RS_COMPONENTS_V is not referenced by any database object
APPS.JTF_RS_DBI_UNSEC_GRPS_V is not referenced by any database object
APPS.JTF_RS_DEFRESGROUPS_VL is not referenced by any database object
APPS.JTF_RS_DEFRESOURCES_VL is not referenced by any database object
APPS.JTF_RS_DEFRESROLES_VL is not referenced by any database object
APPS.JTF_RS_DEFRESTEAMS_VL is not referenced by any database object
APPS.JTF_RS_DYNAMIC_GROUPS_VL is not referenced by any database object
APPS.JTF_RS_EMAIL_ACCOUNTS_V is not referenced by any database object
APPS.JTF_RS_EMPLOYEES_VL is not referenced by any database object
APPS.JTF_RS_EMP_ADDRESS_VL is not referenced by any database object
APPS.JTF_RS_EMP_DTLS_VL is not referenced by any database object
APPS.JTF_RS_GROUPS_AUD_VL is not referenced by any database object
APPS.JTF_RS_GROUP_DTLS_VL is not referenced by any database object
APPS.JTF_RS_GROUP_USAGES_VL is not referenced by any database object
APPS.JTF_RS_GRP_DENORM_VL is not referenced by any database object
APPS.JTF_RS_GRP_HIER_MEM_V is not referenced by any database object
APPS.JTF_RS_GRP_HIER_V is not referenced by any database object
APPS.JTF_RS_GRP_RELATIONS_VL is not referenced by any database object
APPS.JTF_RS_ITEM_CATEGORIES_V is not referenced by any database object
APPS.JTF_RS_JOB_ROLES_VL is not referenced by any database object
APPS.JTF_RS_OTHER_DTLS_VL is not referenced by any database object
APPS.JTF_RS_PARTIES_VL is not referenced by any database object
APPS.JTF_RS_PARTNERS_VL is not referenced by any database object
APPS.JTF_RS_PARTNER_DTLS_VL is not referenced by any database object
APPS.JTF_RS_PARTY_DTLS_VL is not referenced by any database object
APPS.JTF_RS_PLATFORMS_V is not referenced by any database object
APPS.JTF_RS_PROBLEM_CODES_V is not referenced by any database object
APPS.JTF_RS_PRODUCTS_V is not referenced by any database object
APPS.JTF_RS_PTNR_MIGR_VL is not referenced by any database object
APPS.JTF_RS_REP_MANAGERS_VL is not referenced by any database object
APPS.JTF_RS_RESOURCES_VL is not referenced by any database object
APPS.JTF_RS_RESOURCE_VALUES_VL is not referenced by any database object
APPS.JTF_RS_RES_EMP_VL is not referenced by any database object
APPS.JTF_RS_ROLE_DETAILS_VL is not referenced by any database object
APPS.JTF_RS_SKILL_LEVELS_VL is not referenced by any database object
APPS.JTF_RS_SRP_GROUPS_V is not referenced by any database object
APPS.JTF_RS_SRP_TERRITORIES_V is not referenced by any database object
APPS.JTF_RS_SRP_VL is not referenced by any database object
APPS.JTF_RS_SUPPLIERS_VL is not referenced by any database object
APPS.JTF_RS_SUPPLIER_DTLS_VL is not referenced by any database object
APPS.JTF_RS_TABLE_ATTRIBUTES_VL is not referenced by any database object
APPS.JTF_RS_TEAM_MEMBERS_VL is not referenced by any database object
APPS.JTF_RS_TEAM_USAGES_VL is not referenced by any database object
APPS.JTF_RS_VENUE_DTLS_VL is not referenced by any database object
APPS.JTF_RS_WEB_AVAILABLE_V is not referenced by any database object
APPS.JTF_R_RULESETS_V is not referenced by any database object
APPS.JTF_R_RULES_V is not referenced by any database object
APPS.JTF_SEEDED_QUAL_ALL_VL is not referenced by any database object
APPS.JTF_STATE_RESPONSIBILITIES_V is not referenced by any database object
APPS.JTF_STATE_TRANSITIONS_V is not referenced by any database object
APPS.JTF_STORES_VL is not referenced by any database object
APPS.JTF_SUSPENSION_ACTIVITY_V is not referenced by any database object
APPS.JTF_TASK_ALL_ASSIGNMENTS_V is not referenced by any database object
APPS.JTF_TASK_ALL_STATUSES_VL is not referenced by any database object
APPS.JTF_TASK_AUDITS_VL is not referenced by any database object
APPS.JTF_TASK_DATES_V is not referenced by any database object
APPS.JTF_TASK_DATE_TYPES_VL is not referenced by any database object
APPS.JTF_TASK_DEPENDS_V is not referenced by any database object
APPS.JTF_TASK_PARTY_CONTACTS_V is not referenced by any database object
APPS.JTF_TASK_PRIORITIES_VL is not referenced by any database object
APPS.JTF_TASK_SECURITY_V is not referenced by any database object
APPS.JTF_TASK_TEMP_DEPENDS_V is not referenced by any database object
APPS.JTF_TASK_TEMP_GROUPS_VL is not referenced by any database object
APPS.JTF_TASK_TERRITORY_V is not referenced by any database object
APPS.JTF_TASK_TYPES_VL is not referenced by any database object
APPS.JTF_TASK_UWQ_ALL_REF_V is not referenced by any database object
APPS.JTF_TASK_UWQ_ALL_V is not referenced by any database object
APPS.JTF_TASK_UWQ_MYOWN_V is not referenced by any database object
APPS.JTF_TASK_UWQ_V is not referenced by any database object
APPS.JTF_TERRITORIES_NAV is not referenced by any database object
APPS.JTF_TERR_COLUMNS_V is not referenced by any database object
APPS.JTF_TERR_DENORM_RULES is not referenced by any database object
APPS.JTF_TERR_ESCALATIONS_NAV is not referenced by any database object
APPS.JTF_TERR_INHERITED_QUAL_V is not referenced by any database object
APPS.JTF_TERR_OVERVIEW_V is not referenced by any database object
APPS.JTF_TERR_QLFY_RSC_DST_V is not referenced by any database object
APPS.JTF_TERR_QLFY_RSC_V is not referenced by any database object
APPS.JTF_TERR_RSC_ACCESS_V is not referenced by any database object
APPS.JTF_TERR_RSC_LANG_V is not referenced by any database object
APPS.JTF_TERR_SRCH_ADV_ESCL_V is not referenced by any database object
APPS.JTF_TERR_SRCH_ADV_GEN_V is not referenced by any database object
APPS.JTF_TERR_SRCH_ADV_MAIN_V is not referenced by any database object
APPS.JTF_TERR_SRCH_ADV_TEMP_V is not referenced by any database object
APPS.JTF_TERR_SRCH_ADV_TYPE_V is not referenced by any database object
APPS.JTF_TERR_SRCH_ESCL_V is not referenced by any database object
APPS.JTF_TERR_SRCH_MAIN_V is not referenced by any database object
APPS.JTF_TERR_SRCH_TEMP_V is not referenced by any database object
APPS.JTF_TERR_SRCH_TYPE_V is not referenced by any database object
APPS.JTF_TERR_TABLES_V is not referenced by any database object
APPS.JTF_TERR_TEMPLATES_NAV is not referenced by any database object
APPS.JTF_TERR_TRANSACTIONS_V is not referenced by any database object
APPS.JTF_TERR_TRANS_DENORM_V is not referenced by any database object
APPS.JTF_TERR_TYPES_NAV is not referenced by any database object
APPS.JTF_TERR_TYPES_V is not referenced by any database object
APPS.JTF_TERR_TYPE_QUAL_V is not referenced by any database object
APPS.JTF_TERR_T_TRANS_DENORM_V is not referenced by any database object
APPS.JTF_TERR_VALUES_DESC_V is not referenced by any database object
APPS.JTF_TERR_WINNERS_V is not referenced by any database object
APPS.JTF_TR_ALL_RESOURCES_V is not referenced by any database object
APPS.JTF_TR_SOURCE_DENORM_V is not referenced by any database object
APPS.JTF_TTY_ALL_RESOURCES_V is not referenced by any database object
APPS.JTF_TTY_GEO_TERR_OWNER_LOV_V is not referenced by any database object
APPS.JTF_TTY_MY_DIRECTS_V is not referenced by any database object
APPS.JTF_TTY_MY_RESOURCES_V is not referenced by any database object
APPS.JTF_TTY_SRCH_MY_RESOURCES_V is not referenced by any database object
APPS.JTF_TTY_WEBADI_TERR_GRP_V is not referenced by any database object
APPS.JTF_TYPE_QTYPE_USGS_V is not referenced by any database object
APPS.JTF_TYPE_TRANSACTIONS_V is not referenced by any database object
APPS.JTF_UM_APPROVALS_VL is not referenced by any database object
APPS.JTF_UM_SUBSCRIPTIONS_VL is not referenced by any database object
APPS.JTF_UM_TEMPLATES_VL is not referenced by any database object
APPS.JTF_UM_USERTYPES_VL is not referenced by any database object
APPS.JTF_USER_CUSTOM_GRIDS is not referenced by any database object
APPS.JTY_ALL_ENABLED_ATTRIBUTES_V is not referenced by any database object
APPS.JTY_ESCALATION_TERRITORIES_V is not referenced by any database object
APPS.JTY_WEBADI_OTH_TERR_V is not referenced by any database object
|
|
Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |