View: JTF_RS_PARTY_DTLS_VL | Oracle EBS ETRM Search

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.

JTF.JTF_RS_RESOURCE_EXTNS·Explore JTF module →

View: JTF_RS_DEFRESOURCES_V 12.1.1

FND - Application Object Library·83 columns

APPS.JTF_RS_DEFRESOURCES_V·↳ JTF_OBJECTS_VL·↳ JTF_RS_RESOURCE_EXTNS_VL·Explore FND module →

View: JTF_RS_PARTNER_DTLS_VL 12.2.2

JTF - CRM Foundation·30 columns

This view has the details of all the resources whose category='PARTNER'

APPS.JTF_RS_PARTNER_DTLS_VL·↳ JTF_RS_RESOURCE_EXTNS_VL·Explore JTF module →

View: JTF_RS_SUPPLIER_DTLS_VL 12.2.2

JTF - CRM Foundation·30 columns

This view has the details of all the resources whose category='SUPPLIER_CONTACT'

APPS.JTF_RS_SUPPLIER_DTLS_VL·↳ JTF_RS_RESOURCE_EXTNS_VL·Explore JTF module →

View: JTF_RS_SUPPLIER_DTLS_VL 12.1.1

JTF - CRM Foundation·30 columns

This view has the details of all the resources whose category='SUPPLIER_CONTACT'

APPS.JTF_RS_SUPPLIER_DTLS_VL·↳ JTF_RS_RESOURCE_EXTNS_VL·Explore JTF module →

View: JTF_RS_DEFRESOURCES_V 12.2.2

FND - Application Object Library·83 columns

APPS.JTF_RS_DEFRESOURCES_V·↳ JTF_OBJECTS_VL·↳ JTF_RS_RESOURCE_EXTNS_VL·Explore FND module →

View: JTF_RS_RESOURCE_EXTNS_VL 12.1.1

JTF - CRM Foundation·84 columns

Main resource view that stores all resource data.

APPS.JTF_RS_RESOURCE_EXTNS_VL·↳ JTF_RS_RESOURCE_EXTNS·↳ JTF_RS_RESOURCE_EXTNS_TL·Explore JTF module →

View: JTF_RS_DEFRESOURCES_VL 12.2.2

JTF - CRM Foundation·86 columns

APPS.JTF_RS_DEFRESOURCES_VL·↳ JTF_OBJECTS_VL·↳ JTF_RS_RESOURCE_EXTNS_VL·↳ JTF_RS_SALESREPS_MO_V·Explore JTF module →

View: JTF_RS_RESOURCE_EXTNS_VL 12.2.2

JTF - CRM Foundation·85 columns

Main resource view that stores all resource data.

APPS.JTF_RS_RESOURCE_EXTNS_VL·↳ JTF_RS_RESOURCE_EXTNS·↳ JTF_RS_RESOURCE_EXTNS_TL·Explore JTF module →

View: JTF_RS_EMP_DTLS_VL 12.2.2

JTF - CRM Foundation·43 columns

This view has the details of all the resources whose category='EMPLOYEE'

APPS.JTF_RS_EMP_DTLS_VL·↳ JTF_RS_RESOURCE_EXTNS_VL·Explore JTF module →

View: JTF_RS_DEFRESOURCES_V 12.2.2

JTF - CRM Foundation·83 columns

APPS.JTF_RS_DEFRESOURCES_V·↳ JTF_OBJECTS_VL·↳ JTF_RS_RESOURCE_EXTNS_VL·Explore JTF module →

View: JTF_RS_DEFRESOURCES_VL 12.1.1

JTF - CRM Foundation·86 columns

APPS.JTF_RS_DEFRESOURCES_VL·↳ JTF_OBJECTS_VL·↳ JTF_RS_RESOURCE_EXTNS_VL·↳ JTF_RS_SALESREPS_MO_V·Explore JTF module →

Table: JTF_RS_RESOURCE_EXTNS_INT 12.2.2

owner JTF·JTF - CRM Foundation·52 columns

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·Explore JTF module →

View: JTF_RS_ACTIVE_RESOURCES_VL 12.1.1

JTF - CRM Foundation·81 columns

This view stores active resources as of sysdate

APPS.JTF_RS_ACTIVE_RESOURCES_VL·↳ JTF_RS_RESOURCE_EXTNS·↳ JTF_RS_RESOURCE_EXTNS_TL·Explore JTF module →

Table: JTF_RS_RESOURCE_EXTNS 12.2.2 hub

owner JTF·JTF - CRM Foundation·86 columns

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.

JTF.JTF_RS_RESOURCE_EXTNS·Explore JTF module →

VIEW: JTF.JTF_RS_RESOURCE_EXTNS_INT# 12.2.2

VIEW: APPS.JTF_TERR_RSC_LANG_V 12.2.2

VIEW: APPS.JTF_TERR_RSC_LANG_V 12.1.1

View: JTF_TERR_RSC_LANG_V 12.1.1

JTF - CRM Foundation·2 columns

This shows a resource's language(s).

APPS.JTF_TERR_RSC_LANG_V·↳ JTF_RS_RESOURCE_EXTNS·Explore JTF module →

VIEW: JTF.JTF_RS_RESOURCE_EXTNS# 12.2.2

APPS.JTF_RS_RESOURCE_WF_PUB SQL Statements 12.2.2

APPS.JTF_RS_RESOURCE_WF_PUB SQL Statements 12.1.1

View: JTF_TERR_RSC_LANG_V 12.2.2