View: JTF_TERR_SRCH_TYPE_V | Oracle EBS ETRM Search

View: JTF_TERR_SRCH_TYPE_V 12.2.2

JTF - CRM Foundation·6 columns

View for territory type search

APPS.JTF_TERR_SRCH_TYPE_V·↳ FND_GLOBAL·↳ JTF_SOURCES·↳ JTF_TERR_TYPES·Explore JTF module →

Table: JTF_TERR_TYPE_QUAL_ALL 12.1.1 link

owner JTF·JTF - CRM Foundation·15 columns

Stores the qualifiers that used to define a territory type.

JTF.JTF_TERR_TYPE_QUAL_ALL·Explore JTF module →

Table: JTF_TYPE_QTYPE_USGS_ALL 12.1.1 link

owner JTF·JTF - CRM Foundation·10 columns

Stores the transaction types that can be assigned to a territory type.

JTF.JTF_TYPE_QTYPE_USGS_ALL·Explore JTF module →

Table: JTF_TERR_TYPE_USGS_ALL 12.2.2 link

owner JTF·JTF - CRM Foundation·11 columns

Stores the association between territory types and the Oracle Application module(s) that use them.

JTF.JTF_TERR_TYPE_USGS_ALL·Explore JTF module →

View: JTF_TERR_SRCH_ADV_TYPE_V 12.2.2

JTF - CRM Foundation·8 columns

View for advanced territory type search

APPS.JTF_TERR_SRCH_ADV_TYPE_V·↳ FND_GLOBAL·↳ JTF_SOURCES·↳ JTF_TERR_TYPES·Explore JTF module →

View: JTF_TERR_SRCH_TYPE_V 12.1.1

JTF - CRM Foundation·6 columns

View for territory type search

APPS.JTF_TERR_SRCH_TYPE_V·↳ FND_GLOBAL·↳ JTF_SOURCES·↳ JTF_TERR_TYPES·Explore JTF module →

View: JTF_TYPE_TRANSACTIONS_V 12.1.1

JTF - CRM Foundation·14 columns

Shows the transaction types ( Qualifier types) associated with a Territory Type

APPS.JTF_TYPE_TRANSACTIONS_V·↳ FND_GLOBAL·↳ JTF_QUAL_TYPES·↳ JTF_QUAL_TYPE_USGS·Explore JTF module →

View: JTF_TERR_SRCH_ADV_TYPE_V 12.1.1

JTF - CRM Foundation·8 columns

View for advanced territory type search

APPS.JTF_TERR_SRCH_ADV_TYPE_V·↳ FND_GLOBAL·↳ JTF_SOURCES·↳ JTF_TERR_TYPES·Explore JTF module →

View: JTF_TERR_TYPE_QUAL_V 12.2.2

JTF - CRM Foundation·16 columns

Shows Territory Type's qualifer and qualifer type usage description

APPS.JTF_TERR_TYPE_QUAL_V·↳ FND_ACCESS_CONTROL_UTIL·↳ FND_GLOBAL·↳ JTF_SEEDED_QUAL_USGS_V·Explore JTF module →

Table: JTF_TYPE_QTYPE_USGS_ALL 12.2.2 link

owner JTF·JTF - CRM Foundation·10 columns

Stores the transaction types that can be assigned to a territory type.

JTF.JTF_TYPE_QTYPE_USGS_ALL·Explore JTF module →

Table: JTF_TERR_TYPE_USGS_ALL 12.1.1 link

owner JTF·JTF - CRM Foundation·11 columns

Stores the association between territory types and the Oracle Application module(s) that use them.

JTF.JTF_TERR_TYPE_USGS_ALL·Explore JTF module →

View: JTF_TERR_T_TRANS_DENORM_V 12.2.2

JTF - CRM Foundation·11 columns

This shows the denormalised territory type transactions horizontally.

APPS.JTF_TERR_T_TRANS_DENORM_V·↳ JTF_QUAL_TYPE_USGS·↳ JTF_TERR_TYPES·↳ JTF_TYPE_QTYPE_USGS·Explore JTF module →

Table: JTF_TERR_TYPE_QUAL_ALL 12.2.2 link

owner JTF·JTF - CRM Foundation·15 columns

Stores the qualifiers that used to define a territory type.

JTF.JTF_TERR_TYPE_QUAL_ALL·Explore JTF module →

View: JTF_TERR_TYPE_QUAL_V 12.1.1

JTF - CRM Foundation·16 columns

Shows Territory Type's qualifer and qualifer type usage description

APPS.JTF_TERR_TYPE_QUAL_V·↳ FND_ACCESS_CONTROL_UTIL·↳ FND_GLOBAL·↳ JTF_SEEDED_QUAL_USGS_V·Explore JTF module →

Table: JTF_TERR_TYPES_ALL 12.1.1 hub-leaning

owner JTF·JTF - CRM Foundation·34 columns

Stores the territory type definition. It holds the information about the types of territories defined for your organisation.

JTF.JTF_TERR_TYPES_ALL·Explore JTF module →

View: JTF_TYPE_TRANSACTIONS_V 12.2.2

JTF - CRM Foundation·14 columns

Shows the transaction types ( Qualifier types) associated with a Territory Type

APPS.JTF_TYPE_TRANSACTIONS_V·↳ FND_GLOBAL·↳ JTF_QUAL_TYPES·↳ JTF_QUAL_TYPE_USGS·Explore JTF module →

View: JTF_TERR_T_TRANS_DENORM_V 12.1.1

JTF - CRM Foundation·11 columns

This shows the denormalised territory type transactions horizontally.

APPS.JTF_TERR_T_TRANS_DENORM_V·↳ JTF_QUAL_TYPE_USGS·↳ JTF_TERR_TYPES·↳ JTF_TYPE_QTYPE_USGS·Explore JTF module →

View: JTF_TYPE_QTYPE_USGS_V 12.2.2

JTF - CRM Foundation·12 columns

Shows Territory Type's qualifer type usage description

APPS.JTF_TYPE_QTYPE_USGS_V·↳ FND_GLOBAL·↳ JTF_QUAL_TYPES·↳ JTF_QUAL_TYPE_USGS·Explore JTF module →

View: JTF_TYPE_QTYPE_USGS_V 12.1.1

JTF - CRM Foundation·12 columns

Shows Territory Type's qualifer type usage description

APPS.JTF_TYPE_QTYPE_USGS_V·↳ FND_GLOBAL·↳ JTF_QUAL_TYPES·↳ JTF_QUAL_TYPE_USGS·Explore JTF module →

Table: AMS_TERR_LEVELS_ALL 12.2.2 standalone

owner AMS·AMS - Marketing·35 columns

This table stores the levels that corrospond to territory types in JTF.

AMS.AMS_TERR_LEVELS_ALL·Explore AMS module →

Table: OZF_TERR_LEVELS_ALL 12.1.1 standalone

owner OZF·OZF - Trade Management·39 columns

This table stores the levels that corrospond to territory types in JTF.

OZF.OZF_TERR_LEVELS_ALL·Explore OZF module →

View: JTF_TERR_TYPE_QUALIFIERS_V 12.1.1

JTF - CRM Foundation·32 columns

Shows Territory Type's qualifer type usage and the qualifer details.

APPS.JTF_TERR_TYPE_QUALIFIERS_V·↳ FND_GLOBAL·↳ JTF_QUAL_TYPES·↳ JTF_QUAL_TYPE_USGS·Explore JTF module →

Table: JTF_TERR_TYPES_ALL 12.2.2 hub-leaning

owner JTF·JTF - CRM Foundation·34 columns

Stores the territory type definition. It holds the information about the types of territories defined for your organisation.

JTF.JTF_TERR_TYPES_ALL·Explore JTF module →

Table: OZF_TERR_LEVELS_ALL 12.2.2 standalone

owner OZF·OZF - Trade Management·39 columns

This table stores the levels that corrospond to territory types in JTF.

OZF.OZF_TERR_LEVELS_ALL·Explore OZF module →

Table: AMS_TERR_LEVELS_ALL 12.1.1 standalone

owner AMS·AMS - Marketing·35 columns

This table stores the levels that corrospond to territory types in JTF.

AMS.AMS_TERR_LEVELS_ALL·Explore AMS module →

View: JTF_TERR_TYPE_QUALIFIERS_V 12.2.2

JTF - CRM Foundation·32 columns

Shows Territory Type's qualifer type usage and the qualifer details.

APPS.JTF_TERR_TYPE_QUALIFIERS_V·↳ FND_GLOBAL·↳ JTF_QUAL_TYPES·↳ JTF_QUAL_TYPE_USGS·Explore JTF module →

View: JTF_TERR_TYPES_V 12.2.2

JTF - CRM Foundation·34 columns

Shows Territory Type usage by joining the JTF_TERR_TYPE_USGS table

APPS.JTF_TERR_TYPES_V·↳ FND_ACCESS_CONTROL_UTIL·↳ JTF_SOURCES_ALL·↳ JTF_TERR_TYPES·Explore JTF module →

View: JTF_TERR_TYPES_V 12.1.1

JTF - CRM Foundation·34 columns

Shows Territory Type usage by joining the JTF_TERR_TYPE_USGS table

APPS.JTF_TERR_TYPES_V·↳ FND_ACCESS_CONTROL_UTIL·↳ JTF_SOURCES_ALL·↳ JTF_TERR_TYPES·Explore JTF module →

View: JTY_WEBADI_OTH_TERR_V 12.2.2

JTF - CRM Foundation·412 columns

APPS.JTY_WEBADI_OTH_TERR_V·↳ JTY_WEBADI_OTH_TERR_INTF·↳ JTY_WEBADI_RESOURCES·Explore JTF module →

View: JTY_WEBADI_OTH_TERR_V 12.1.1

JTF - CRM Foundation·212 columns

View for Other Territories Excel Download

APPS.JTY_WEBADI_OTH_TERR_V·↳ JTY_WEBADI_OTH_TERR_INTF·↳ JTY_WEBADI_RESOURCES·Explore JTF module →

Table: JTY_WEBADI_OTH_TERR_INTF 12.2.2 standalone

owner JTF·JTF - CRM Foundation·497 columns

Interface table to store data that needs to be displayed in Excel

JTF.JTY_WEBADI_OTH_TERR_INTF·Explore JTF module →

Table: JTY_WEBADI_OTH_TERR_INTF 12.1.1 standalone

owner JTF·JTF - CRM Foundation·197 columns

Interface table to store data that needs to be displayed in Excel

JTF.JTY_WEBADI_OTH_TERR_INTF·Explore JTF module →

PACKAGE BODY: APPS.JTY_TERR_SPARES_PVT 12.2.2 PVT API

used by 1

VIEW: APPS.JTF_TERR_T_TRANS_DENORM_V 12.1.1

VIEW: JTF.JTF_TERR_TYPE_USGS_ALL# 12.2.2

PACKAGE: APPS.JTY_TERR_SPARES_PVT 12.2.2 PVT API

used by 1

VIEW: APPS.JTF_TERR_T_TRANS_DENORM_V 12.2.2

VIEW: AMS.AMS_TERR_LEVELS_ALL# 12.2.2

VIEW: OZF.OZF_TERR_LEVELS_ALL# 12.2.2

TABLE: JTF.JTF_TYPE_QTYPE_USGS_ALL 12.1.1

owner JTF

VIEW: JTF.JTF_TERR_TYPE_QUAL_ALL# 12.2.2

View: JTF_TYPE_QTYPE_USGS 12.2.2

JTF - CRM Foundation

Same as JTF_TYPE_QTYPE_USGS_ALL table

Not implemented in this database·Explore JTF module →

View: JTF_TERR_TYPE_USGS 12.2.2

JTF - CRM Foundation

Same as JTF_TERR_TYPE_USGS_ALL table

Not implemented in this database·Explore JTF module →

View: JTF_TERR_TYPE_QUAL 12.1.1

JTF - CRM Foundation

Same as JTF_TERR_TYPE_QUAL_ALL table

Not implemented in this database·Explore JTF module →

VIEW: JTF.JTF_TYPE_QTYPE_USGS_ALL# 12.2.2

VIEW: APPS.JTF_TYPE_TRANSACTIONS_V 12.1.1

VIEW: APPS.JTF_TYPE_TRANSACTIONS_V 12.2.2

View: JTF_TERR_TYPE_USGS 12.1.1

JTF - CRM Foundation

Same as JTF_TERR_TYPE_USGS_ALL table

Not implemented in this database·Explore JTF module →

View: JTF_TYPE_QTYPE_USGS 12.1.1

JTF - CRM Foundation

Same as JTF_TYPE_QTYPE_USGS_ALL table

Not implemented in this database·Explore JTF module →

VIEW: APPS.JTF_TERR_T_TRANS_DENORM_V 12.1.1

Results for “terr_type_id”