Table: JTF_LOC_HIERARCHIES_B | Oracle EBS ETRM Search

Table: JTF_LOC_HIERARCHIES_B 12.1.1 satellite-leaning

owner JTF·JTF - CRM Foundation·31 columns

Stores a flattened out structure of all geographical information.

JTF.JTF_LOC_HIERARCHIES_B·Explore JTF module →

View: BIC_CITIES_V 12.1.1

BIC - Customer Intelligence (obsolete)·5 columns

This view fetches city names from bic_dimv_geography.

APPS.BIC_CITIES_V·↳ BIC_DIMV_GEOGRAPHY·↳ FND_GLOBAL·Explore BIC module →

View: JTF_LOC_HIERARCHIES_VL 12.1.1

JTF - CRM Foundation·41 columns

View based on JTF_LOC_HIERARCHIES_B table.

APPS.JTF_LOC_HIERARCHIES_VL·↳ JTF_LOC_AREAS_TL·↳ JTF_LOC_HIERARCHIES_B·↳ JTF_LOC_POSTAL_CODES·Explore JTF module →

View: OPI_EDW_PRODUCT_GROSS_MARGIN_V 12.1.1

OPI - Operations Intelligence·27 columns

Product Gross Margin report source view

APPS.OPI_EDW_PRODUCT_GROSS_MARGIN_V·↳ EDW_GEOGRAPHY_M·↳ EDW_ITEMS_M·↳ EDW_OE_SLCHNL_M·Explore OPI module →

Table: JTF_LOC_HIERARCHIES_B 12.2.2 satellite-leaning

owner JTF·JTF - CRM Foundation·31 columns

Stores a flattened out structure of all geographical information.

JTF.JTF_LOC_HIERARCHIES_B·Explore JTF module →

View: JTF_LOC_HIERARCHIES_VL 12.2.2

JTF - CRM Foundation·41 columns

View based on JTF_LOC_HIERARCHIES_B table.

APPS.JTF_LOC_HIERARCHIES_VL·↳ JTF_LOC_AREAS_TL·↳ JTF_LOC_HIERARCHIES_B·↳ JTF_LOC_POSTAL_CODES·Explore JTF module →

View: OPI_EDW_PRODUCT_SALES_REV_V 12.1.1

OPI - Operations Intelligence·27 columns

Product Sales Revenue report source view

APPS.OPI_EDW_PRODUCT_SALES_REV_V·↳ EDW_GEOGRAPHY_M·↳ EDW_ITEMS_M·↳ EDW_OE_SLCHNL_M·Explore OPI module →

Table: AMS_CAMPAIGNS_ALL_B 12.1.1 hub

owner AMS·AMS - Marketing·113 columns

Base table to store the details of a campaign.

AMS.AMS_CAMPAIGNS_ALL_B·Explore AMS module →

View: AMS_CAMPAIGNS_V 12.2.2

AMS - Marketing·119 columns

This view returns all marketing campaigns and related information.

APPS.AMS_CAMPAIGNS_V·↳ AMS_CAMPAIGNS_ALL_TL·↳ AMS_CAMPAIGNS_VL·↳ AMS_USER_STATUSES_VL·Explore AMS module →

View: AMS_CAMPAIGNS_V 12.1.1

AMS - Marketing·119 columns

This view returns all marketing campaigns and related information.

APPS.AMS_CAMPAIGNS_V·↳ AMS_CAMPAIGNS_ALL_TL·↳ AMS_CAMPAIGNS_VL·↳ AMS_USER_STATUSES_VL·Explore AMS module →

View: AMS_P_CAMPAIGNS_V 12.2.2

AMS - Marketing·48 columns

This public view returns all marketing campaigns and related information.

APPS.AMS_P_CAMPAIGNS_V·↳ AMS_CAMPAIGNS_VL·Explore AMS module →

View: AMS_P_CAMPAIGNS_V 12.1.1

AMS - Marketing·48 columns

This public view returns all marketing campaigns and related information.

APPS.AMS_P_CAMPAIGNS_V·↳ AMS_CAMPAIGNS_VL·Explore AMS module →

Table: AMS_CAMPAIGNS_ALL_B 12.2.2 hub

owner AMS·AMS - Marketing·113 columns

Base table to store the details of a campaign.

AMS.AMS_CAMPAIGNS_ALL_B·Explore AMS module →

View: AMS_CAMPAIGNS_VL 12.1.1

AMS - Marketing·115 columns

This is the view for marketing campaigns.

APPS.AMS_CAMPAIGNS_VL·↳ AMS_CAMPAIGNS_ALL_B·↳ AMS_CAMPAIGNS_ALL_TL·Explore AMS module →

View: AMS_CAMPAIGNS_VL 12.2.2

AMS - Marketing·115 columns

This is the view for marketing campaigns.

APPS.AMS_CAMPAIGNS_VL·↳ AMS_CAMPAIGNS_ALL_B·↳ AMS_CAMPAIGNS_ALL_TL·Explore AMS module →

View: BIC_CITIES_V 12.2.2

BIC - Customer Intelligence(Obsolete)

This view fetches city names from bic_dimv_geography.

Not implemented in this database·Explore BIC module →

VIEW: JTF.JTF_LOC_HIERARCHIES_B# 12.2.2

APPS.JTF_LOC_PVT SQL Statements 12.1.1

APPS.JTF_LOC_PVT SQL Statements 12.2.2

VIEW: APPS.BIC_CITIES_V 12.1.1

View: OPI_EDW_PRODUCT_GROSS_MARGIN_V 12.2.2

OPI - Operations Intelligence (Obsolete)

Product Gross Margin report source view

Not implemented in this database·Explore OPI module →

VIEW: APPS.OPI_EDW_PRODUCT_SALES_REV_V 12.1.1

VIEW: APPS.BIC_CITIES_V 12.1.1

VIEW: APPS.OPI_EDW_PRODUCT_GROSS_MARGIN_V 12.1.1

VIEW: JTF.JTF_LOC_HIERARCHIES_B# 12.2.2

owner JTF

TABLE: JTF.JTF_LOC_HIERARCHIES_B 12.2.2

owner JTF

View: OPI_EDW_PRODUCT_SALES_REV_V 12.2.2

OPI - Operations Intelligence (Obsolete)

Product Sales Revenue report source view

Not implemented in this database·Explore OPI module →

TABLE: JTF.JTF_LOC_HIERARCHIES_B 12.1.1

owner JTF

VIEW: AMS.AMS_CAMPAIGNS_ALL_B# 12.2.2

VIEW: APPS.OPI_EDW_PRODUCT_SALES_REV_V 12.1.1

VIEW: APPS.JTF_LOC_HIERARCHIES_VL 12.1.1

VIEW: APPS.OPI_EDW_PRODUCT_GROSS_MARGIN_V 12.1.1

VIEW: APPS.JTF_LOC_HIERARCHIES_VL 12.2.2

APPS.JTF_LOC_HIERARCHIES_PVT SQL Statements 12.1.1

APPS.JTF_LOC_HIERARCHIES_PVT SQL Statements 12.2.2

PACKAGE BODY: APPS.JTF_LOC_PVT 12.1.1

VIEW: AMS.AMS_CAMPAIGNS_ALL_B# 12.2.2

owner AMS

PACKAGE BODY: APPS.JTF_LOC_PVT 12.2.2

VIEW: APPS.AMS_P_CAMPAIGNS_V 12.2.2

APPS.JTF_LOC_HIERARCHIES_PKG SQL Statements 12.1.1

APPS.AMS_CAMPAIGNRULES_PVT SQL Statements 12.2.2

VIEW: APPS.AMS_P_CAMPAIGNS_V 12.1.1

APPS.JTF_LOC_HIERARCHIES_PKG SQL Statements 12.2.2

APPS.AMS_CAMPAIGNRULES_PVT SQL Statements 12.1.1

TABLE: AMS.AMS_CAMPAIGNS_ALL_B 12.1.1

owner AMS

TABLE: AMS.AMS_CAMPAIGNS_ALL_B 12.2.2

owner AMS

PACKAGE BODY: APPS.JTF_LOC_HIERARCHIES_PKG 12.2.2

VIEW: APPS.AMS_CAMPAIGNS_V 12.2.2

VIEW: APPS.AMS_CAMPAIGNS_V 12.1.1

PACKAGE BODY: APPS.JTF_LOC_HIERARCHIES_PKG 12.1.1

Results for “city_id”