Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

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.

eTRM - OZF Tables and Views

TABLE - OZF.OZF_ACCOUNT_ALLOCATIONS
TABLE - OZF.OZF_ACCTNG_EVENTS_ALL
TABLE - OZF.OZF_ACTIVITY_CUSTOMERS
TABLE - OZF.OZF_ACTIVITY_CUSTOMERS_TEMP
TABLE - OZF.OZF_ACTIVITY_HL_DENORM
TABLE - OZF.OZF_ACTIVITY_PRODUCTS
TABLE - OZF.OZF_ACTIVITY_PRODUCTS_TEMP
TABLE - OZF.OZF_ACT_BUDGETS
TABLE - OZF.OZF_ACT_BUDGETS_INT
TABLE - OZF.OZF_ACT_FORECASTS_ALL
TABLE - OZF.OZF_ACT_METRICS_ALL
TABLE - OZF.OZF_ACT_METRIC_FACTS_ALL
TABLE - OZF.OZF_ACT_METRIC_FORMULAS
TABLE - OZF.OZF_ACT_METRIC_FORM_ENT
TABLE - OZF.OZF_ACT_OFFERS
TABLE - OZF.OZF_ADJ_TEMP_ELIGIBILITY
TABLE - OZF.OZF_AE_HEADERS_ALL
TABLE - OZF.OZF_AE_LINES_ALL
TABLE - OZF.OZF_AGING_BUCKET_DATES
TABLE - OZF.OZF_AGING_SUMMARY_ALL
TABLE - OZF.OZF_APPROVAL_ACCESS
TABLE - OZF.OZF_BASELINE_SALES_FACTS
TABLE - OZF.OZF_BASELINE_SALES_HISTORY
TABLE - OZF.OZF_BASELINE_SALES_INTERFACE
TABLE - OZF.OZF_BASELINE_SALES_MV
TABLE - OZF.OZF_BASELINE_SALES_MV_TEMP
TABLE - OZF.OZF_BATCHES_ALL
TABLE - OZF.OZF_CHARGEBACK_INT_ALL
TABLE - OZF.OZF_CHARGEBACK_INT_LOG
TABLE - OZF.OZF_CHARGEBACK_PRICE_ADJ_ALL
TABLE - OZF.OZF_CLAIMS_ALL
TABLE - OZF.OZF_CLAIMS_HISTORY_ALL
TABLE - OZF.OZF_CLAIMS_INT_ALL
TABLE - OZF.OZF_CLAIM_ADJUSTMENTS_ALL
TABLE - OZF.OZF_CLAIM_DEF_RULES_ALL
TABLE - OZF.OZF_CLAIM_LINES_ALL
TABLE - OZF.OZF_CLAIM_LINES_HIST_ALL
TABLE - OZF.OZF_CLAIM_LINES_INT_ALL
TABLE - OZF.OZF_CLAIM_LINES_UTIL_ALL
TABLE - OZF.OZF_CLAIM_OFFER_PERF_ALL
TABLE - OZF.OZF_CLAIM_STTLMNT_METHODS_ALL
TABLE - OZF.OZF_CLAIM_THRESHOLD_ALL
TABLE - OZF.OZF_CLAIM_TYPES_ALL_B
TABLE - OZF.OZF_CLAIM_TYPES_ALL_TL
TABLE - OZF.OZF_CODE_CONVERSIONS_ALL
TABLE - OZF.OZF_COMPETITOR_PRICE_POINTS
TABLE - OZF.OZF_CUST_DAILY_FACTS
TABLE - OZF.OZF_CUST_PROD_CONT_ALL
TABLE - OZF.OZF_CUST_TRD_PRFLS_ALL
TABLE - OZF.OZF_DASHB_DAILY_KPI
TABLE - OZF.OZF_DENORM_QUERIES
TABLE - OZF.OZF_DISCOUNT_PRODUCT_RELN
TABLE - APPS.OZF_EARNING_SUMMARY_MV
TABLE - OZF.OZF_FORECAST_CUSTOMERS
TABLE - OZF.OZF_FORECAST_DIMENTIONS
TABLE - OZF.OZF_FORECAST_PERIODS
TABLE - OZF.OZF_FORECAST_PRODUCTS
TABLE - OZF.OZF_FORECAST_PROD_EXCLUSIONS
TABLE - OZF.OZF_FUNDS_ALL_B
TABLE - OZF.OZF_FUNDS_ALL_B_INT
TABLE - OZF.OZF_FUNDS_ALL_TL
TABLE - OZF.OZF_FUNDS_PAID_ALL
TABLE - OZF.OZF_FUNDS_UTILIZED_ALL_B
TABLE - OZF.OZF_FUNDS_UTILIZED_ALL_TL
TABLE - OZF.OZF_FUND_REQUESTS
TABLE - OZF.OZF_INTERFACE_ERRORS
TABLE - OZF.OZF_INVENTORY_SUMMARY_MV
TABLE - OZF.OZF_INVENTORY_SUMMARY_MV_TEMP
TABLE - OZF.OZF_INVENTORY_TMP_T
TABLE - OZF.OZF_LIFT_FACTORS_FACTS
TABLE - OZF.OZF_LIFT_FACTORS_HISTORY
TABLE - OZF.OZF_LIFT_FACTORS_INTERFACE
TABLE - OZF.OZF_MARKET_PRESET_TIERS
TABLE - OZF.OZF_MC_TRANSACTIONS_ALL
TABLE - OZF.OZF_MULTI_CURR_UTIL_BCK
TABLE - OZF.OZF_NAE_COMPLETION_TIME
TABLE - OZF.OZF_NA_CONC_EXCEPTIONS
TABLE - OZF.OZF_NA_CUSTOMERS_TEMP
TABLE - OZF.OZF_NA_DEDUCTION_RULES_B
TABLE - OZF.OZF_NA_DEDUCTION_RULES_TL
TABLE - OZF.OZF_NA_PRODUCTS_TEMP
TABLE - OZF.OZF_NA_RULE_HEADERS_B
TABLE - OZF.OZF_NA_RULE_HEADERS_TL
TABLE - OZF.OZF_NA_RULE_LINES
TABLE - OZF.OZF_NA_UNIQUE_PRODUCTS_TEMP
TABLE - OZF.OZF_OBJECT_FUND_SUMMARY
TABLE - OZF.OZF_OFFERS
TABLE - OZF.OZF_OFFER_ADJUSTMENTS_B
TABLE - OZF.OZF_OFFER_ADJUSTMENTS_TL
TABLE - OZF.OZF_OFFER_ADJUSTMENT_LINES
TABLE - OZF.OZF_OFFER_ADJUSTMENT_PRODUCTS
TABLE - OZF.OZF_OFFER_ADJUSTMENT_TIERS
TABLE - OZF.OZF_OFFER_ADJ_NEW_LINES
TABLE - OZF.OZF_OFFER_ADJ_NEW_PRODUCTS
TABLE - OZF.OZF_OFFER_ADJ_RLTD_LINES
TABLE - OZF.OZF_OFFER_DISCOUNT_LINES
TABLE - OZF.OZF_OFFER_DISCOUNT_PRODUCTS
TABLE - OZF.OZF_OFFER_PARTIES
TABLE - OZF.OZF_OFFER_PARTIES_TEMP
TABLE - OZF.OZF_OFFER_PERFORMANCES
TABLE - OZF.OZF_OFFER_PRODUCTS
TABLE - OZF.OZF_OFFER_PRODUCTS_TEMP
TABLE - OZF.OZF_OFFER_QUALIFIERS
TABLE - OZF.OZF_OFFR_DISC_STRUCT_NAME_B
TABLE - OZF.OZF_OFFR_DISC_STRUCT_NAME_TL
TABLE - OZF.OZF_OFFR_MARKET_OPTIONS
TABLE - OZF.OZF_ORDER_GROUP_PROD
TABLE - OZF.OZF_ORDER_MESSAGE_COUNTER
TABLE - OZF.OZF_ORDER_SALES_SUMRY_MV
TABLE - OZF.OZF_ORDER_SALES_SUMRY_MV_TEMP
TABLE - APPS.OZF_PARTY_MARKET_SEGMENTS_T
TABLE - OZF.OZF_PRICE_LIST_ATTRIBUTES
TABLE - OZF.OZF_PROCESS_SETUP_ALL
TABLE - OZF.OZF_PRODUCT_ALLOCATIONS
TABLE - OZF.OZF_QP_DISCOUNTS
TABLE - OZF.OZF_QP_PRODUCTS
TABLE - OZF.OZF_QUALIFIER_MARKET_OPTION
TABLE - OZF.OZF_QUOTA_ALERTS
TABLE - OZF.OZF_REASONS
TABLE - OZF.OZF_REASON_CODES_ALL_B
TABLE - OZF.OZF_REASON_CODES_ALL_TL
TABLE - OZF.OZF_RELATED_DEAL_LINES
TABLE - OZF.OZF_REQUEST_HEADERS_ALL_B
TABLE - OZF.OZF_REQUEST_HEADERS_ALL_TL
TABLE - OZF.OZF_REQUEST_LINES_ALL
TABLE - OZF.OZF_RESALE_ADJUSTMENTS_ALL
TABLE - OZF.OZF_RESALE_BATCHES_ALL
TABLE - OZF.OZF_RESALE_BATCH_LINE_MAPS_ALL
TABLE - OZF.OZF_RESALE_HEADERS_ALL
TABLE - OZF.OZF_RESALE_LINES_ALL
TABLE - OZF.OZF_RESALE_LINES_INT_ALL
TABLE - OZF.OZF_RESALE_LOGS_ALL
TABLE - OZF.OZF_RES_CUST_PROD
TABLE - OZF.OZF_RES_CUST_PROD_FACTS
TABLE - OZF.OZF_RETAIL_PRICE_POINTS
TABLE - OZF.OZF_RULE_BASED_LOG
TABLE - OZF.OZF_SALES_TRANSACTIONS_ALL
TABLE - OZF.OZF_SD_BATCH_HEADERS_ALL
TABLE - OZF.OZF_SD_BATCH_LINES_ALL
TABLE - OZF.OZF_SD_BATCH_LINES_INT_ALL
TABLE - OZF.OZF_SD_BATCH_LINE_DISPUTES
TABLE - OZF.OZF_SD_CUSTOMER_DETAILS
TABLE - OZF.OZF_SD_REQUEST_ACCESS
TABLE - OZF.OZF_SD_REQUEST_HEADERS_ALL_B
TABLE - OZF.OZF_SD_REQUEST_HEADERS_ALL_TL
TABLE - OZF.OZF_SD_REQUEST_LINES_ALL
TABLE - OZF.OZF_SD_RES_CUST_INTF
TABLE - OZF.OZF_SD_RES_DIST_PRICES_INTF
TABLE - OZF.OZF_SD_RES_HEADER_INTF
TABLE - OZF.OZF_SD_RES_PROD_INTF
TABLE - OZF.OZF_SD_STATUS_TRANSITIONS
TABLE - OZF.OZF_SETTLEMENT_DOCS_ALL
TABLE - OZF.OZF_SUPP_CODE_CONVERSIONS_ALL
TABLE - OZF.OZF_SUPP_TRD_PRFLS_ALL
TABLE - OZF.OZF_SYS_PARAMETERS_ALL
TABLE - OZF.OZF_TERR_LEVELS_ALL
TABLE - OZF.OZF_THRESHOLDS_ALL_B
TABLE - OZF.OZF_THRESHOLDS_ALL_TL
TABLE - OZF.OZF_THRESHOLD_RULES_ALL
TABLE - OZF.OZF_TIME_ALLOCATIONS
TABLE - OZF.OZF_TIME_DAY
TABLE - OZF.OZF_TIME_ENT_PERIOD
TABLE - OZF.OZF_TIME_ENT_QTR
TABLE - OZF.OZF_TIME_ENT_YEAR
TABLE - OZF.OZF_TIME_RPT_STRUCT
TABLE - OZF.OZF_TIME_WEEK
TABLE - OZF.OZF_TP_TERRUSG_MAP
TABLE - OZF.OZF_TRADE_TACTICS_MAPPING
TABLE - OZF.OZF_VOLUME_DETAIL
TABLE - OZF.OZF_VOLUME_OFFER_TIERS
TABLE - OZF.OZF_VOLUME_SUMMARY
TABLE - OZF.OZF_VO_PRODUCTS_TEMP
TABLE - OZF.OZF_WORKSHEET_HEADERS_B
TABLE - OZF.OZF_WORKSHEET_HEADERS_TL
TABLE - OZF.OZF_WORKSHEET_LINES
TABLE - OZF.OZF_WORKSHEET_QUALIFIERS
TABLE - OZF.OZF_XLA_ACCRUALS
TABLE - OZF.OZF_XLA_ACCRUALS_BACKUP
TABLE - OZF.OZF_XLA_CLAIM_HEADERS
TABLE - OZF.OZF_XLA_CLAIM_HEADERS_BACKUP
TABLE - OZF.OZF_XLA_CLAIM_LINES
TABLE - OZF.OZF_XLA_CLAIM_LINES_BACKUP
TABLE - OZF.OZF_XREF_MAP
VIEW - APPS.OZF_BATCHES
VIEW - APPS.OZF_CLAIMS_HISTORY_V
VIEW - APPS.OZF_CLAIMS_V
VIEW - APPS.OZF_CLAIM_LINES_HIST_V
VIEW - APPS.OZF_CLAIM_LINES_V
VIEW - APPS.OZF_CLAIM_TYPES_ALL_VL
VIEW - APPS.OZF_CLAIM_TYPES_VL
VIEW - APPS.OZF_CUST_PROD_CONT
VIEW - APPS.OZF_CUST_TRD_PRFLS_V
VIEW - APPS.OZF_FUNDS
VIEW - APPS.OZF_FUNDS_ALL_VL
VIEW - APPS.OZF_FUNDS_PAID
VIEW - APPS.OZF_FUNDS_PAID_V
VIEW - APPS.OZF_FUNDS_UTILIZED_ALL_VL
VIEW - APPS.OZF_FUNDS_UTILIZED_VL
VIEW - APPS.OZF_FUNDS_VL
VIEW - APPS.OZF_FUND_ALLOCATIONS_V
VIEW - APPS.OZF_FUND_ALLOCTREE_V
VIEW - APPS.OZF_FUND_CHECKBOOK_V
VIEW - APPS.OZF_FUND_DETAILS_V
VIEW - APPS.OZF_FUND_REQUESTS_V
VIEW - APPS.OZF_JE_CATEGORIES_V
VIEW - APPS.OZF_LOOKUPS
VIEW - APPS.OZF_LOOKUP_TYPES
VIEW - APPS.OZF_MC_TRANSACTIONS
VIEW - APPS.OZF_REASON_CODES_ALL_VL
VIEW - APPS.OZF_REASON_CODES_VL
VIEW - APPS.OZF_THRESHOLDS
VIEW - APPS.OZF_THRESHOLDS_ALL_VL
VIEW - APPS.OZF_THRESHOLDS_VL
VIEW - APPS.OZF_THRESHOLD_RULES
VIEW - APPS.OZF_X_AGING_BUCKETS
VIEW - APPS.OZF_X_AGING_BUCKET_LNS
VIEW - APPS.OZF_X_CUST_SITE_USES
VIEW - APPS.OZF_X_GET_TRX_TYPES
VIEW - APPS.OZF_X_INVOICES_V
VIEW - APPS.OZF_X_INVOICE_LINE_V

Table: OZF_ACCOUNT_ALLOCATIONS

Description: Table to store the Account Allocations
Primary Key: OZF_ACCOUNT_ALLOCATIONS
  1. ACCOUNT_ALLOCATION_ID
Primary Key: OZF_ACCOUNT_ALLOCATIONS_PK
  1. ACCOUNT_ALLOCATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_ACCOUNT_ALLOCATIONS.ALLOCATION_FOR_ID OZF_FUNDS_ALL_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
OZF_PRODUCT_ALLOCATIONS.ALLOCATION_FOR_ID OZF_ACCOUNT_ALLOCATIONS
OZF_TIME_ALLOCATIONS.ALLOCATION_FOR_ID OZF_ACCOUNT_ALLOCATIONS

[top of page]

OZF.OZF_ACCOUNT_ALLOCATIONS does not reference any database object

OZF.OZF_ACCOUNT_ALLOCATIONS is referenced by following:

OZF
VIEW - OZF_ACCOUNT_ALLOCATIONS#

[top of page]

Table: OZF_ACCTNG_EVENTS_ALL

Description: This table stores accounting events occuring on a Claim
Primary Key: OZF_ACCTNG_EVENTS_ALL_PK
  1. ACCOUNTING_EVENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_ACCTNG_EVENTS_ALL.SOURCE_ID OZF_CLAIMS_ALL
OZF_ACCTNG_EVENTS_ALL.SOURCE_ID OZF_FUNDS_ALL_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
OZF_AE_HEADERS_ALL.ACCOUNTING_EVENT_ID OZF_ACCTNG_EVENTS_ALL

[top of page]

OZF.OZF_ACCTNG_EVENTS_ALL does not reference any database object

OZF.OZF_ACCTNG_EVENTS_ALL is referenced by following:

OZF
VIEW - OZF_ACCTNG_EVENTS_ALL#
- OZF_ACCTNG_EVENTS_ALL#

[top of page]

Table: OZF_ACTIVITY_CUSTOMERS

Description: Denorm table for Offer and Schedules Market Eligibility
Primary Key: OZF_ACTIVITY_CUSTOMERS_PK
  1. ACTIVITY_CUSTOMER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_ACTIVITY_CUSTOMERS.OBJECT_ID OZF_OFFERS
OZF_ACTIVITY_CUSTOMERS.HZ_PARTIES_PARTY_ID HZ_PARTIES

[top of page]

OZF.OZF_ACTIVITY_CUSTOMERS does not reference any database object

OZF.OZF_ACTIVITY_CUSTOMERS is referenced by following:

OZF
VIEW - OZF_ACTIVITY_CUSTOMERS#

[top of page]

Table: OZF_ACTIVITY_CUSTOMERS_TEMP

Description: Temporary Table for Trade Management Activitiy denorm program
Primary Key: OZF_ACTIVITY_CUSTOMERS_TEMP_PK
  1. ACTIVITY_CUSTOMER_ID

[top of page]

OZF.OZF_ACTIVITY_CUSTOMERS_TEMP does not reference any database object

OZF.OZF_ACTIVITY_CUSTOMERS_TEMP is referenced by following:

OZF
VIEW - OZF_ACTIVITY_CUSTOMERS_TEMP#

[top of page]

Table: OZF_ACTIVITY_HL_DENORM

Description: Denorm table for Campaign Schedules
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_ACTIVITY_HL_DENORM.CAMPAIGN_ID AMS_CAMPAIGNS_ALL_B
OZF_ACTIVITY_HL_DENORM.LIST_HEADER_ID QP_LIST_HEADERS_B

[top of page]

OZF.OZF_ACTIVITY_HL_DENORM does not reference any database object

OZF.OZF_ACTIVITY_HL_DENORM is referenced by following:

OZF
VIEW - OZF_ACTIVITY_HL_DENORM#

[top of page]

Table: OZF_ACTIVITY_PRODUCTS

Description: Denorm table for Offer and Schedules Product Eligibility
Primary Key: OZF_ACTIVITY_PRODUCTS_PK
  1. ACTIVITY_PRODUCT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_ACTIVITY_PRODUCTS.OBJECT_ID OZF_OFFERS

[top of page]

OZF.OZF_ACTIVITY_PRODUCTS does not reference any database object

OZF.OZF_ACTIVITY_PRODUCTS is referenced by following:

OZF
VIEW - OZF_ACTIVITY_PRODUCTS#

[top of page]

Table: OZF_ACTIVITY_PRODUCTS_TEMP

Description: Temporary Table for Trade Management Activitiy denorm program
Primary Key: OZF_ACTIVITY_PRODUCTS_TEMP_PK
  1. ACTIVITY_PRODUCT_ID

[top of page]

OZF.OZF_ACTIVITY_PRODUCTS_TEMP does not reference any database object

OZF.OZF_ACTIVITY_PRODUCTS_TEMP is referenced by following:

OZF
VIEW - OZF_ACTIVITY_PRODUCTS_TEMP#

[top of page]

Table: OZF_ACT_BUDGETS

Description: Holds the information about budget sources for a marketing activity.
Primary Key: OZF_ACT_BUDGETS_PK
  1. ACTIVITY_BUDGET_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_ACT_BUDGETS.ACT_BUDGET_USED_BY_ID AMS_CAMPAIGNS_ALL_B
OZF_ACT_BUDGETS.ACT_BUDGET_USED_BY_ID AMS_EVENT_HEADERS_ALL_B
OZF_ACT_BUDGETS.BUDGET_SOURCE_ID AMS_CAMPAIGNS_ALL_B
OZF_ACT_BUDGETS.BUDGET_SOURCE_ID AMS_EVENT_HEADERS_ALL_B
OZF_ACT_BUDGETS.ACT_BUDGET_USED_BY_ID AMS_DELIVERABLES_ALL_B
OZF_ACT_BUDGETS.ACT_BUDGET_USED_BY_ID OZF_FUNDS_ALL_B

[top of page]

OZF.OZF_ACT_BUDGETS does not reference any database object

OZF.OZF_ACT_BUDGETS is referenced by following:

OZF
VIEW - OZF_ACT_BUDGETS#

[top of page]

Table: OZF_ACT_BUDGETS_INT

Description: Interface table to store data of ozf_act_budgets table when Chargeback Batch upload or Third Party Accrual programs are run in parallel.

[top of page]

OZF.OZF_ACT_BUDGETS_INT does not reference any database object

OZF.OZF_ACT_BUDGETS_INT is referenced by following:

OZF
VIEW - OZF_ACT_BUDGETS_INT#

[top of page]

Table: OZF_ACT_FORECASTS_ALL

Description: This table stores the Forecasts planned for a Marketing Activity.
Primary Key: OZF_ACT_FORECASTS_ALL_PK
  1. FORECAST_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_ACT_FORECASTS_ALL.ACT_FCAST_USED_BY_ID AMS_CAMPAIGNS_ALL_B
OZF_ACT_FORECASTS_ALL.ACT_FCAST_USED_BY_ID OZF_OFFERS
OZF_ACT_FORECASTS_ALL.ACT_FCAST_USED_BY_ID OZF_WORKSHEET_HEADERS_B

[top of page]

OZF.OZF_ACT_FORECASTS_ALL does not reference any database object

OZF.OZF_ACT_FORECASTS_ALL is referenced by following:

OZF
VIEW - OZF_ACT_FORECASTS_ALL#

[top of page]

Table: OZF_ACT_METRICS_ALL

Description: This table stores the value for budget or quota allocation
Primary Key: OZF_ACT_METRICS_ALL_PK
  1. ACTIVITY_METRIC_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_ACT_METRICS_ALL.ACT_METRIC_USED_BY_ID OZF_FUNDS_ALL_B
OZF_ACT_METRICS_ALL.FUNCTIONAL_CURRENCY_CODE FND_CURRENCIES
OZF_ACT_METRICS_ALL.APPLICATION_ID FND_APPLICATION
OZF_ACT_METRICS_ALL.TRANSACTION_CURRENCY_CODE FND_CURRENCIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
OZF_ACT_METRIC_FACTS_ALL.ACTIVITY_METRIC_ID OZF_ACT_METRICS_ALL
OZF_ACT_METRIC_FORMULAS.ACTIVITY_METRIC_ID OZF_ACT_METRICS_ALL

[top of page]

OZF.OZF_ACT_METRICS_ALL does not reference any database object

OZF.OZF_ACT_METRICS_ALL is referenced by following:

OZF
VIEW - OZF_ACT_METRICS_ALL#

[top of page]

Table: OZF_ACT_METRIC_FACTS_ALL

Description: Store detail allocation value for each node
Primary Key: OZF_ACT_METRIC_FACTS_ALL_PK
  1. ACTIVITY_METRIC_FACT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_ACT_METRIC_FACTS_ALL.ACTIVITY_METRIC_ID OZF_ACT_METRICS_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
OZF_PRODUCT_ALLOCATIONS.ALLOCATION_FOR_ID OZF_ACT_METRIC_FACTS_ALL

[top of page]

OZF.OZF_ACT_METRIC_FACTS_ALL does not reference any database object

OZF.OZF_ACT_METRIC_FACTS_ALL is referenced by following:

OZF
VIEW - OZF_ACT_METRIC_FACTS_ALL#

[top of page]

Table: OZF_ACT_METRIC_FORMULAS

Description: Stores the formulas to be executed at each hierarchy level for a metric.
Primary Key: OZF_ACT_METRIC_FORMULAS_PK
  1. FORMULA_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_ACT_METRIC_FORMULAS.ACTIVITY_METRIC_ID OZF_ACT_METRICS_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
OZF_ACT_METRIC_FORM_ENT.FORMULA_ID OZF_ACT_METRIC_FORMULAS

[top of page]

OZF.OZF_ACT_METRIC_FORMULAS does not reference any database object

OZF.OZF_ACT_METRIC_FORMULAS is referenced by following:

OZF
VIEW - OZF_ACT_METRIC_FORMULAS#

[top of page]

Table: OZF_ACT_METRIC_FORM_ENT

Description: Stores the set of entries to be executed for a formula.
Primary Key: OZF_ACT_METRIC_FORM_ENT_PK1
  1. FORMULA_ENTRY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_ACT_METRIC_FORM_ENT.FORMULA_ID OZF_ACT_METRIC_FORMULAS

[top of page]

OZF.OZF_ACT_METRIC_FORM_ENT does not reference any database object

OZF.OZF_ACT_METRIC_FORM_ENT is referenced by following:

OZF
VIEW - OZF_ACT_METRIC_FORM_ENT#

[top of page]

Table: OZF_ACT_OFFERS

Description: Holds the high level details of promotional offers related to a campaign
Primary Key: OZF_ACT_OFFERS_PK
  1. ACTIVITY_OFFER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_ACT_OFFERS.ACT_OFFER_USED_BY_ID AMS_CAMPAIGNS_ALL_B
OZF_ACT_OFFERS.QP_LIST_HEADER_ID OZF_OFFERS

[top of page]

OZF.OZF_ACT_OFFERS does not reference any database object

OZF.OZF_ACT_OFFERS is referenced by following:

OZF
VIEW - OZF_ACT_OFFERS#

[top of page]

Table: OZF_ADJ_TEMP_ELIGIBILITY

Description:

[top of page]

OZF.OZF_ADJ_TEMP_ELIGIBILITY does not reference any database object

OZF.OZF_ADJ_TEMP_ELIGIBILITY is referenced by following:

APPS
SYNONYM - OZF_ADJ_TEMP_ELIGIBILITY

[top of page]

Table: OZF_AE_HEADERS_ALL

Description: This table stores all the account headers for every accounting event
Primary Key: OZF_AE_HEADERS_ALL_PK
  1. AE_HEADER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_AE_HEADERS_ALL.ACCOUNTING_EVENT_ID OZF_ACCTNG_EVENTS_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
OZF_AE_LINES_ALL.AE_HEADER_ID OZF_AE_HEADERS_ALL

[top of page]

OZF.OZF_AE_HEADERS_ALL does not reference any database object

OZF.OZF_AE_HEADERS_ALL is referenced by following:

OZF
VIEW - OZF_AE_HEADERS_ALL#
- OZF_AE_HEADERS_ALL#

[top of page]

Table: OZF_AE_LINES_ALL

Description: This table stores Accounting lines for a account header
Primary Key: OZF_AE_LINES_ALL_PK
  1. AE_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_AE_LINES_ALL.AE_HEADER_ID OZF_AE_HEADERS_ALL

[top of page]

OZF.OZF_AE_LINES_ALL does not reference any database object

OZF.OZF_AE_LINES_ALL is referenced by following:

OZF
VIEW - OZF_AE_LINES_ALL#
- OZF_AE_LINES_ALL#

[top of page]

Table: OZF_AGING_BUCKET_DATES

Description: This table stores the dates for aging bucket days range based on system date.

[top of page]

OZF.OZF_AGING_BUCKET_DATES does not reference any database object

OZF.OZF_AGING_BUCKET_DATES is referenced by following:

OZF
VIEW - OZF_AGING_BUCKET_DATES#

[top of page]

Table: OZF_AGING_SUMMARY_ALL

Description: This table stores the aging summary of claims by customer for an aging bucket

[top of page]

OZF.OZF_AGING_SUMMARY_ALL does not reference any database object

OZF.OZF_AGING_SUMMARY_ALL is referenced by following:

OZF
VIEW - OZF_AGING_SUMMARY_ALL#

[top of page]

Table: OZF_APPROVAL_ACCESS

Description: This table stores approval information for ozf
Primary Key: OZF_APPROVAL_ACCESS_PK
  1. APPROVAL_ACCESS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_APPROVAL_ACCESS.OBJECT_ID OZF_REQUEST_HEADERS_ALL_B

[top of page]

OZF.OZF_APPROVAL_ACCESS does not reference any database object

OZF.OZF_APPROVAL_ACCESS is referenced by following:

OZF
VIEW - OZF_APPROVAL_ACCESS#

[top of page]

Table: OZF_BASELINE_SALES_FACTS

Description: This table stores validated baseline sales for Market, Product and Time dimension
Primary Key: OZF_BASELINE_SALES_FACTS_PK
  1. BASELINE_SALES_FACTS_ID

[top of page]

OZF.OZF_BASELINE_SALES_FACTS does not reference any database object

OZF.OZF_BASELINE_SALES_FACTS is referenced by following:

OZF
VIEW - OZF_BASELINE_SALES_FACTS#

[top of page]

Table: OZF_BASELINE_SALES_HISTORY

Description: This table stores historical baseline sales as of history_snapshot_date
Primary Key: OZF_BASELINE_SALES_HISTORY_PK
  1. BASELINE_SALES_HISTORY_ID

[top of page]

OZF.OZF_BASELINE_SALES_HISTORY does not reference any database object

OZF.OZF_BASELINE_SALES_HISTORY is referenced by following:

OZF
VIEW - OZF_BASELINE_SALES_HISTORY#

[top of page]

Table: OZF_BASELINE_SALES_INTERFACE

Description: This Interface table stores baseline sales across Market, Product and Time dimensions as uploaded by user
Primary Key: OZF_BASELINE_SALES_INT_PK
  1. BASELINE_SALES_INTERFACE_ID

[top of page]

OZF.OZF_BASELINE_SALES_INTERFACE does not reference any database object

OZF.OZF_BASELINE_SALES_INTERFACE is referenced by following:

OZF
VIEW - OZF_BASELINE_SALES_INTERFACE#

[top of page]

Table: OZF_BASELINE_SALES_MV

Description: Summary Table for Baseline Sales

[top of page]

OZF.OZF_BASELINE_SALES_MV does not reference any database object

OZF.OZF_BASELINE_SALES_MV is referenced by following:

OZF
VIEW - OZF_BASELINE_SALES_MV#

[top of page]

Table: OZF_BASELINE_SALES_MV_TEMP

Description: Temporary Summary table for storing Baseline Sales Data

[top of page]

OZF.OZF_BASELINE_SALES_MV_TEMP does not reference any database object

OZF.OZF_BASELINE_SALES_MV_TEMP is referenced by following:

OZF
VIEW - OZF_BASELINE_SALES_MV_TEMP#

[top of page]

Table: OZF_BATCHES_ALL

Description: This table stores the batches for claims
Primary Key: OZF_BATCHES_ALL_PK
  1. BATCH_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
OZF_CHARGEBACK_INT_ALL.BATCH_ID OZF_BATCHES_ALL
OZF_CLAIMS_ALL.BATCH_ID OZF_BATCHES_ALL

[top of page]

OZF.OZF_BATCHES_ALL does not reference any database object

OZF.OZF_BATCHES_ALL is referenced by following:

OZF
VIEW - OZF_BATCHES_ALL#

[top of page]

Table: OZF_CHARGEBACK_INT_ALL

Description: chargeback interface table.
Primary Key: CHARGEBACK_INT_ID_PK
  1. CHARGEBACK_INT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_CHARGEBACK_INT_ALL.BILL_TO_CUST_ACCOUNT_ID HZ_CUST_ACCOUNTS
OZF_CHARGEBACK_INT_ALL.BILL_TO_SITE_USE_ID HZ_CUST_SITE_USES_ALL
OZF_CHARGEBACK_INT_ALL.SHIP_TO_CUST_ACCOUNT_ID HZ_CUST_ACCOUNTS
OZF_CHARGEBACK_INT_ALL.SHIP_TO_SITE_USE_ID HZ_CUST_SITE_USES_ALL
OZF_CHARGEBACK_INT_ALL.BATCH_ID OZF_BATCHES_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
OZF_CHARGEBACK_INT_LOG.CHARGEBACK_INT_ID OZF_CHARGEBACK_INT_ALL
OZF_CHARGEBACK_PRICE_ADJ_ALL.CHARGEBACK_LINE_ID OZF_CHARGEBACK_INT_ALL

[top of page]

OZF.OZF_CHARGEBACK_INT_ALL does not reference any database object

OZF.OZF_CHARGEBACK_INT_ALL is referenced by following:

OZF
VIEW - OZF_CHARGEBACK_INT_ALL#

[top of page]

Table: OZF_CHARGEBACK_INT_LOG

Description: Log table for charge back interface table.
Primary Key: CHARGEBACK_INT_LOG_ID_PK
  1. CHARGEBACK_INT_LOG_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_CHARGEBACK_INT_LOG.CHARGEBACK_INT_ID OZF_CHARGEBACK_INT_ALL

[top of page]

OZF.OZF_CHARGEBACK_INT_LOG does not reference any database object

OZF.OZF_CHARGEBACK_INT_LOG is referenced by following:

OZF
VIEW - OZF_CHARGEBACK_INT_LOG#

[top of page]

Table: OZF_CHARGEBACK_PRICE_ADJ_ALL

Description: charge back price adjustments
Primary Key: OZF_CHARGEBACK_PRICE_ADJ_ALL_P
  1. CHARGEBACK_PRICE_ADJ_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_CHARGEBACK_PRICE_ADJ_ALL.CHARGEBACK_LINE_ID OZF_CHARGEBACK_INT_ALL

[top of page]

OZF.OZF_CHARGEBACK_PRICE_ADJ_ALL does not reference any database object

OZF.OZF_CHARGEBACK_PRICE_ADJ_ALL is referenced by following:

OZF
VIEW - OZF_CHARGEBACK_PRICE_ADJ_ALL#

[top of page]

Table: OZF_CLAIMS_ALL

Description: This table stores the Claim headers
Primary Key: OZF_CLAIMS_ALL_PK
  1. CLAIM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_CLAIMS_ALL.BATCH_ID OZF_BATCHES_ALL
OZF_CLAIMS_ALL.CUST_ACCOUNT_ID HZ_CUST_ACCOUNTS
OZF_CLAIMS_ALL.CONTACT_ID HZ_PARTIES
OZF_CLAIMS_ALL.CUST_BILLTO_ACCT_SITE_ID HZ_CUST_SITE_USES_ALL
OZF_CLAIMS_ALL.CUST_SHIPTO_ACCT_SITE_ID HZ_CUST_SITE_USES_ALL
OZF_CLAIMS_ALL.LOCATION_ID HZ_LOCATIONS
OZF_CLAIMS_ALL.RELATED_SITE_USE_ID HZ_CUST_SITE_USES_ALL
OZF_CLAIMS_ALL.RELATED_CUST_ACCOUNT_ID HZ_CUST_ACCOUNTS
OZF_CLAIMS_ALL.PAYMENT_REFERENCE_ID OE_ORDER_HEADERS_ALL
OZF_CLAIMS_ALL.SET_OF_BOOKS_ID OZF_SYS_PARAMETERS_ALL
OZF_CLAIMS_ALL.SOURCE_OBJECT_ID OZF_REQUEST_HEADERS_ALL_B
OZF_CLAIMS_ALL.SPLIT_FROM_CLAIM_ID OZF_CLAIMS_ALL
OZF_CLAIMS_ALL.CLAIM_TYPE_ID OZF_CLAIM_TYPES_ALL_B
OZF_CLAIMS_ALL.REASON_CODE_ID OZF_REASON_CODES_ALL_B
OZF_CLAIMS_ALL.TASK_TEMPLATE_GROUP_ID JTF_TASK_TEMP_GROUPS_B
OZF_CLAIMS_ALL.VENDOR_ID PO_VENDORS
OZF_CLAIMS_ALL.VENDOR_SITE_ID PO_VENDOR_SITES_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
OZF_ACCTNG_EVENTS_ALL.SOURCE_ID OZF_CLAIMS_ALL
OZF_CLAIMS_ALL.SPLIT_FROM_CLAIM_ID OZF_CLAIMS_ALL
OZF_CLAIMS_HISTORY_ALL.CLAIM_ID OZF_CLAIMS_ALL
OZF_CLAIM_ADJUSTMENTS_ALL.CLAIM_ID OZF_CLAIMS_ALL
OZF_CLAIM_LINES_ALL.CLAIM_ID OZF_CLAIMS_ALL
OZF_CLAIM_OFFER_PERF_ALL.CLAIM_ID OZF_CLAIMS_ALL
OZF_FUNDS_PAID_ALL.CLAIM_ID OZF_CLAIMS_ALL
OZF_MC_TRANSACTIONS_ALL.SOURCE_OBJECT_ID OZF_CLAIMS_ALL

[top of page]

OZF.OZF_CLAIMS_ALL does not reference any database object

OZF.OZF_CLAIMS_ALL is referenced by following:

APPS
MATERIALIZED VIEW - OZF_CUST_FUND_SUMMARY_MV
OZF
VIEW - OZF_CLAIMS_ALL#

[top of page]

Table: OZF_CLAIMS_HISTORY_ALL

Description: This table is to store claim header history
Primary Key: OZF_CLAIMS_HISTORY_ALL_PK
  1. CLAIM_HISTORY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_CLAIMS_HISTORY_ALL.CLAIM_ID OZF_CLAIMS_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
OZF_CLAIM_LINES_HIST_ALL.CLAIM_HISTORY_ID OZF_CLAIMS_HISTORY_ALL

[top of page]

OZF.OZF_CLAIMS_HISTORY_ALL does not reference any database object

OZF.OZF_CLAIMS_HISTORY_ALL is referenced by following:

OZF
VIEW - OZF_CLAIMS_HISTORY_ALL#

[top of page]

Table: OZF_CLAIMS_INT_ALL

Description: This table is to store Claim Inteface headers
Primary Key: OZF_CLAIMS_INT_ALL_PK
  1. INTERFACE_CLAIM_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
OZF_CLAIM_LINES_INT_ALL.INTERFACE_CLAIM_ID OZF_CLAIMS_INT_ALL

[top of page]

OZF.OZF_CLAIMS_INT_ALL does not reference any database object

OZF.OZF_CLAIMS_INT_ALL is referenced by following:

OZF
VIEW - OZF_CLAIMS_INT_ALL#

[top of page]

Table: OZF_CLAIM_ADJUSTMENTS_ALL

Description: This table stores the adjustments that have been dont to a claim amount
Primary Key: OZF_CLAIM_ADJUSTMENTS_ALL_PK
  1. ADJUSTMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_CLAIM_ADJUSTMENTS_ALL.CLAIM_ID OZF_CLAIMS_ALL

[top of page]

OZF.OZF_CLAIM_ADJUSTMENTS_ALL does not reference any database object

OZF.OZF_CLAIM_ADJUSTMENTS_ALL is referenced by following:

OZF
VIEW - OZF_CLAIM_ADJUSTMENTS_ALL#

[top of page]

Table: OZF_CLAIM_DEF_RULES_ALL

Description: This table stores the default claim type, reason and custom setup a claim source
Primary Key: OZF_CLAIM_DEF_RULES_ALL_PK
  1. ORG_ID
  2. DEFAULTING_RULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_CLAIM_DEF_RULES_ALL.CLAIM_TYPE_ID OZF_CLAIM_TYPES_ALL_B

[top of page]

OZF.OZF_CLAIM_DEF_RULES_ALL does not reference any database object

OZF.OZF_CLAIM_DEF_RULES_ALL is referenced by following:

OZF
VIEW - OZF_CLAIM_DEF_RULES_ALL#

[top of page]

Table: OZF_CLAIM_LINES_ALL

Description: This table is used to store Claim Lines
Primary Key: OZF_CLAIM_LINES_ALL_PK
  1. CLAIM_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_CLAIM_LINES_ALL.CLAIM_ID OZF_CLAIMS_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
OZF_CLAIM_LINES_UTIL_ALL.CLAIM_LINE_ID OZF_CLAIM_LINES_ALL

[top of page]

OZF.OZF_CLAIM_LINES_ALL does not reference any database object

OZF.OZF_CLAIM_LINES_ALL is referenced by following:

APPS
MATERIALIZED VIEW - OZF_CUST_FUND_SUMMARY_MV
OZF
VIEW - OZF_CLAIM_LINES_ALL#

[top of page]

Table: OZF_CLAIM_LINES_HIST_ALL

Description: This table is used to store Claim Lines History
Primary Key: OZF_CLAIM_LINES_HIST_ALL_PK
  1. CLAIM_LINE_HISTORY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_CLAIM_LINES_HIST_ALL.CLAIM_HISTORY_ID OZF_CLAIMS_HISTORY_ALL

[top of page]

OZF.OZF_CLAIM_LINES_HIST_ALL does not reference any database object

OZF.OZF_CLAIM_LINES_HIST_ALL is referenced by following:

OZF
VIEW - OZF_CLAIM_LINES_HIST_ALL#

[top of page]

Table: OZF_CLAIM_LINES_INT_ALL

Description: This table is used to store Claim Lines Interface
Primary Key: OZF_CLAIM_LINES_INT_ALL_PK
  1. INTERFACE_CLAIM_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_CLAIM_LINES_INT_ALL.INTERFACE_CLAIM_ID OZF_CLAIMS_INT_ALL

[top of page]

OZF.OZF_CLAIM_LINES_INT_ALL does not reference any database object

OZF.OZF_CLAIM_LINES_INT_ALL is referenced by following:

OZF
VIEW - OZF_CLAIM_LINES_INT_ALL#

[top of page]

Table: OZF_CLAIM_LINES_UTIL_ALL

Description: This table stores eranings associated to claim lines
Primary Key: OZF_CLAIM_LINES_UTIL_ALL_PK
  1. CLAIM_LINE_UTIL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_CLAIM_LINES_UTIL_ALL.CLAIM_LINE_ID OZF_CLAIM_LINES_ALL
OZF_CLAIM_LINES_UTIL_ALL.UTILIZATION_ID OZF_FUNDS_UTILIZED_ALL_B

[top of page]

OZF.OZF_CLAIM_LINES_UTIL_ALL does not reference any database object

OZF.OZF_CLAIM_LINES_UTIL_ALL is referenced by following:

APPS
MATERIALIZED VIEW - OZF_CUST_FUND_SUMMARY_MV
OZF
VIEW - OZF_CLAIM_LINES_UTIL_ALL#

[top of page]

Table: OZF_CLAIM_OFFER_PERF_ALL

Description: This table stores the offer performances that have been performanced on submission for submission of that claim
Primary Key: CLAIM_OFFER_PERF_ALL_PK
  1. CLAIM_OFFER_PERF_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_CLAIM_OFFER_PERF_ALL.CLAIM_ID OZF_CLAIMS_ALL

[top of page]

OZF.OZF_CLAIM_OFFER_PERF_ALL does not reference any database object

OZF.OZF_CLAIM_OFFER_PERF_ALL is referenced by following:

OZF
VIEW - OZF_CLAIM_OFFER_PERF_ALL#

[top of page]

Table: OZF_CLAIM_STTLMNT_METHODS_ALL

Description: This table stores the available settlement methods for a given claim source
Primary Key: OZF_CLAIM_STTLMNT_METHODS_PK
  1. ORG_ID
  2. CLAIM_STTLMNT_METHOD_ID

[top of page]

OZF.OZF_CLAIM_STTLMNT_METHODS_ALL does not reference any database object

OZF.OZF_CLAIM_STTLMNT_METHODS_ALL is referenced by following:

OZF
VIEW - OZF_CLAIM_STTLMNT_METHODS_ALL#

[top of page]

Table: OZF_CLAIM_THRESHOLD_ALL

Description: This table stores the Claim Thresholds
Primary Key: OZF_CLAIM_THRESHOLD_ALL_PK
  1. THRESHOLD_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_CLAIM_THRESHOLD_ALL.PARTY_ID HZ_PARTIES
OZF_CLAIM_THRESHOLD_ALL.SITE_USE_ID HZ_CUST_SITE_USES_ALL

[top of page]

OZF.OZF_CLAIM_THRESHOLD_ALL does not reference any database object

OZF.OZF_CLAIM_THRESHOLD_ALL is referenced by following:

OZF
VIEW - OZF_CLAIM_THRESHOLD_ALL#
- OZF_CLAIM_THRESHOLD_ALL#

[top of page]

Table: OZF_CLAIM_TYPES_ALL_B

Description: This table is used to store Claim Types (Base Table)
Primary Key: OZF_CLAIM_TYPES_ALL_B_PK
  1. CLAIM_TYPE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
OZF_CLAIMS_ALL.CLAIM_TYPE_ID OZF_CLAIM_TYPES_ALL_B
OZF_CLAIM_DEF_RULES_ALL.CLAIM_TYPE_ID OZF_CLAIM_TYPES_ALL_B
OZF_CLAIM_TYPES_ALL_TL.CLAIM_TYPE_ID OZF_CLAIM_TYPES_ALL_B
OZF_SYS_PARAMETERS_ALL.CLAIM_TYPE_ID OZF_CLAIM_TYPES_ALL_B
OZF_SYS_PARAMETERS_ALL.AUTOPAY_CLAIM_TYPE_ID OZF_CLAIM_TYPES_ALL_B

[top of page]

OZF.OZF_CLAIM_TYPES_ALL_B does not reference any database object

OZF.OZF_CLAIM_TYPES_ALL_B is referenced by following:

APPS
MATERIALIZED VIEW - OZF_CUST_FUND_SUMMARY_MV
OZF
VIEW - OZF_CLAIM_TYPES_ALL_B#
- OZF_CLAIM_TYPES_ALL_B#

[top of page]

Table: OZF_CLAIM_TYPES_ALL_TL

Description: This table is used to store Claim Types (Translation Table)
Primary Key: OZF_CLAIM_TYPES_ALL_TL_PK
  1. CLAIM_TYPE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_CLAIM_TYPES_ALL_TL.CLAIM_TYPE_ID OZF_CLAIM_TYPES_ALL_B

[top of page]

OZF.OZF_CLAIM_TYPES_ALL_TL does not reference any database object

OZF.OZF_CLAIM_TYPES_ALL_TL is referenced by following:

APPS
MATERIALIZED VIEW - OZF_CUST_FUND_SUMMARY_MV
OZF
VIEW - OZF_CLAIM_TYPES_ALL_TL#

[top of page]

Table: OZF_CODE_CONVERSIONS_ALL

Description: This table stores the convensions from external values to internal identified for claim reasons, products, price lists and unit of measures at party, account or site levels
Primary Key: OZF_CODE_CONVERSIONS_ALL_PK
  1. CODE_CONVERSION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_CODE_CONVERSIONS_ALL.CUST_ACCOUNT_ID HZ_CUST_ACCOUNTS
OZF_CODE_CONVERSIONS_ALL.PARTY_ID HZ_PARTIES

[top of page]

OZF.OZF_CODE_CONVERSIONS_ALL does not reference any database object

OZF.OZF_CODE_CONVERSIONS_ALL is referenced by following:

OZF
VIEW - OZF_CODE_CONVERSIONS_ALL#

[top of page]

Table: OZF_COMPETITOR_PRICE_POINTS

Description: Table to store the competitor pricing information
Primary Key: OZF_COMPETITOR_PRICE_POINTS_PK
  1. COMP_PRICE_POINT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_COMPETITOR_PRICE_POINTS.RETAIL_PRICE_POINT_ID OZF_RETAIL_PRICE_POINTS

[top of page]

OZF.OZF_COMPETITOR_PRICE_POINTS does not reference any database object

OZF.OZF_COMPETITOR_PRICE_POINTS is referenced by following:

OZF
VIEW - OZF_COMPETITOR_PRICE_POINTS#

[top of page]

Table: OZF_CUST_DAILY_FACTS

Description: Table to store the Account Manager Dashboard Data
Primary Key: OZF_CUST_DAILY_FACTS_PK
  1. CUST_DAILY_FACT_ID

[top of page]

OZF.OZF_CUST_DAILY_FACTS does not reference any database object

OZF.OZF_CUST_DAILY_FACTS is referenced by following:

OZF
VIEW - OZF_CUST_DAILY_FACTS#

[top of page]

Table: OZF_CUST_PROD_CONT_ALL

Description: Table for the Customer - Product contact Information
Primary Key: OZF_CUST_PROD_CONT_ALL_PK
  1. CUST_PROD_CONTACT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_CUST_PROD_CONT_ALL.CUST_ACCT_SITE_ID HZ_CUST_ACCT_SITES_ALL
OZF_CUST_PROD_CONT_ALL.CUST_ACCOUNT_ID HZ_CUST_ACCOUNTS

[top of page]

OZF.OZF_CUST_PROD_CONT_ALL does not reference any database object

OZF.OZF_CUST_PROD_CONT_ALL is referenced by following:

OZF
VIEW - OZF_CUST_PROD_CONT_ALL#

[top of page]

Table: OZF_CUST_TRD_PRFLS_ALL

Description: Table for Storing Trade Customer Profiles
Primary Key: OZF_CUST_TRD_PRFLS_ALL_PK
  1. TRADE_PROFILE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_CUST_TRD_PRFLS_ALL.CUST_ACCOUNT_ID HZ_CUST_ACCOUNTS
OZF_CUST_TRD_PRFLS_ALL.VENDOR_ID PO_VENDORS
OZF_CUST_TRD_PRFLS_ALL.VENDOR_SITE_ID PO_VENDOR_SITES_ALL
OZF_CUST_TRD_PRFLS_ALL.PARTY_ID HZ_PARTIES
OZF_CUST_TRD_PRFLS_ALL.CUST_ACCT_SITE_ID HZ_CUST_ACCT_SITES_ALL
OZF_CUST_TRD_PRFLS_ALL.SITE_USE_ID HZ_CUST_SITE_USES_ALL

[top of page]

OZF.OZF_CUST_TRD_PRFLS_ALL does not reference any database object

OZF.OZF_CUST_TRD_PRFLS_ALL is referenced by following:

OZF
VIEW - OZF_CUST_TRD_PRFLS_ALL#

[top of page]

Table: OZF_DASHB_DAILY_KPI

Description: Table to store the Account Manager Dashboard KPI
Primary Key: DASHB_DAILY_KPI_ID_PK
  1. DASHB_DAILY_KPI_ID

[top of page]

OZF.OZF_DASHB_DAILY_KPI does not reference any database object

OZF.OZF_DASHB_DAILY_KPI is referenced by following:

OZF
VIEW - OZF_DASHB_DAILY_KPI#

[top of page]

Table: OZF_DENORM_QUERIES

Description: This table stores the SQL Queries for the Market and Product Eligibilities. The Queries for Market eligibilites shalll select the party_id and the Queries for Product Eligibilites shall select the inventory_item_id. Quries are seeded ou
Primary Key: OZF_DENORM_QUERIES_PK
  1. DENORM_QUERY_ID
Primary Key: OZF_DENORM_QUERIES_UK1
  1. QUERY_FOR
  2. CONTEXT
  3. ATTRIBUTE

[top of page]

OZF.OZF_DENORM_QUERIES does not reference any database object

OZF.OZF_DENORM_QUERIES is referenced by following:

OZF
VIEW - OZF_DENORM_QUERIES#

[top of page]

Table: OZF_DISCOUNT_PRODUCT_RELN

Description: Table to store the Discount line relationships
Primary Key: OZF_DISCOUNT_PRODUCT_RELN_PK
  1. DISCOUNT_PRODUCT_RELN_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_DISCOUNT_PRODUCT_RELN.OFFER_DISCOUNT_LINE_ID OZF_OFFER_DISCOUNT_LINES
OZF_DISCOUNT_PRODUCT_RELN.OFF_DISCOUNT_PRODUCT_ID OZF_OFFER_DISCOUNT_PRODUCTS

[top of page]

OZF.OZF_DISCOUNT_PRODUCT_RELN does not reference any database object

OZF.OZF_DISCOUNT_PRODUCT_RELN is referenced by following:

OZF
VIEW - OZF_DISCOUNT_PRODUCT_RELN#

[top of page]

Table: OZF_EARNING_SUMMARY_MV

Description:

[top of page]

APPS.OZF_EARNING_SUMMARY_MV does not reference any database object

APPS.OZF_EARNING_SUMMARY_MV is referenced by following:

APPS
MATERIALIZED VIEW - OZF_EARNING_SUMMARY_MV

[top of page]

Table: OZF_FORECAST_CUSTOMERS

Description: Stores all the customers eligible for an version of Forecast
Primary Key: OZF_FORECAST_CUSTOMERS_PK
  1. FORECAST_CUSTOMER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_FORECAST_CUSTOMERS.OBJ_ID OZF_OFFERS
OZF_FORECAST_CUSTOMERS.OBJ_ID OZF_WORKSHEET_HEADERS_B

[top of page]

OZF.OZF_FORECAST_CUSTOMERS does not reference any database object

OZF.OZF_FORECAST_CUSTOMERS is referenced by following:

OZF
VIEW - OZF_FORECAST_CUSTOMERS#

[top of page]

Table: OZF_FORECAST_DIMENTIONS

Description: Stores all the dimentions defined for an object.
Primary Key: OZF_FORECAST_DIMENTIONS_PK
  1. FORECAST_DIMENTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_FORECAST_DIMENTIONS.OBJ_ID OZF_OFFERS
OZF_FORECAST_DIMENTIONS.OBJ_ID OZF_WORKSHEET_HEADERS_B

[top of page]

OZF.OZF_FORECAST_DIMENTIONS does not reference any database object

OZF.OZF_FORECAST_DIMENTIONS is referenced by following:

OZF
VIEW - OZF_FORECAST_DIMENTIONS#

[top of page]

Table: OZF_FORECAST_PERIODS

Description: Stores the different periods the forecast is spread
Primary Key: OZF_FORECAST_PERIODS_PK
  1. FORECAST_PERIOD_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_FORECAST_PERIODS.OBJ_ID OZF_OFFERS
OZF_FORECAST_PERIODS.OBJ_ID OZF_WORKSHEET_HEADERS_B

[top of page]

OZF.OZF_FORECAST_PERIODS does not reference any database object

OZF.OZF_FORECAST_PERIODS is referenced by following:

OZF
VIEW - OZF_FORECAST_PERIODS#

[top of page]

Table: OZF_FORECAST_PRODUCTS

Description: Stores all the products eligible for a version of forecast
Primary Key: OZF_FORECAST_PRODUCTS_PK
  1. FORECAST_PRODUCT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_FORECAST_PRODUCTS.OBJ_ID OZF_OFFERS
OZF_FORECAST_PRODUCTS.OBJ_ID OZF_WORKSHEET_HEADERS_B

[top of page]

OZF.OZF_FORECAST_PRODUCTS does not reference any database object

OZF.OZF_FORECAST_PRODUCTS is referenced by following:

OZF
VIEW - OZF_FORECAST_PRODUCTS#

[top of page]

Table: OZF_FORECAST_PROD_EXCLUSIONS

Description: Stores the product exclusions derived for and object
Primary Key: OZF_FORECAST_PROD_EXCLUSION_PK
  1. FORECAST_PROD_EXCLUSION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_FORECAST_PROD_EXCLUSIONS.OBJ_ID OZF_OFFERS

[top of page]

OZF.OZF_FORECAST_PROD_EXCLUSIONS does not reference any database object

OZF.OZF_FORECAST_PROD_EXCLUSIONS is referenced by following:

OZF
VIEW - OZF_FORECAST_PROD_EXCLUSIONS#

[top of page]

Table: OZF_FUNDS_ALL_B

Description: Fund definition master base table.
Primary Key: OZF_FUNDS_ALL_B_PK
  1. FUND_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_FUNDS_ALL_B.THRESHOLD_ID OZF_THRESHOLDS_ALL_B
OZF_FUNDS_ALL_B.PARENT_FUND_ID OZF_FUNDS_ALL_B
OZF_FUNDS_ALL_B.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I
OZF_FUNDS_ALL_B.THRESHOLD_ID OZF_THRESHOLDS_ALL_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
AMS_CAMPAIGNS_ALL_B.FUND_SOURCE_ID OZF_FUNDS_ALL_B
AMS_EVENT_HEADERS_ALL_B.FUND_SOURCE_ID OZF_FUNDS_ALL_B
AMS_EVENT_OFFERS_ALL_B.FUND_SOURCE_ID OZF_FUNDS_ALL_B
OZF_ACCOUNT_ALLOCATIONS.ALLOCATION_FOR_ID OZF_FUNDS_ALL_B
OZF_ACCTNG_EVENTS_ALL.SOURCE_ID OZF_FUNDS_ALL_B
OZF_ACT_BUDGETS.ACT_BUDGET_USED_BY_ID OZF_FUNDS_ALL_B
OZF_ACT_METRICS_ALL.ACT_METRIC_USED_BY_ID OZF_FUNDS_ALL_B
OZF_FUNDS_ALL_B.PARENT_FUND_ID OZF_FUNDS_ALL_B
OZF_FUNDS_ALL_TL.FUND_ID OZF_FUNDS_ALL_B
OZF_FUND_REQUESTS.TRANSFER_TO_ID OZF_FUNDS_ALL_B
OZF_FUND_REQUESTS.TRANSFER_FM_ID OZF_FUNDS_ALL_B
OZF_MC_TRANSACTIONS_ALL.SOURCE_OBJECT_ID OZF_FUNDS_ALL_B
OZF_NA_CONC_EXCEPTIONS.BUDGET_SOURCE_ID OZF_FUNDS_ALL_B
OZF_OBJECT_FUND_SUMMARY.FUND_ID OZF_FUNDS_ALL_B
OZF_OFFERS.BUDGET_SOURCE_ID OZF_FUNDS_ALL_B
OZF_PRODUCT_ALLOCATIONS.FUND_ID OZF_FUNDS_ALL_B
OZF_PRODUCT_ALLOCATIONS.ALLOCATION_FOR_ID OZF_FUNDS_ALL_B

[top of page]

OZF.OZF_FUNDS_ALL_B does not reference any database object

OZF.OZF_FUNDS_ALL_B is referenced by following:

APPS
MATERIALIZED VIEW - OZF_CUST_FUND_SUMMARY_MV
OZF
VIEW - OZF_FUNDS_ALL_B#

[top of page]

Table: OZF_FUNDS_ALL_B_INT

Description: Interface table to store data of ozf_funds_all_b table when Chargeback Batch upload or Third Party Accrual programs are run in parallel.

[top of page]

OZF.OZF_FUNDS_ALL_B_INT does not reference any database object

OZF.OZF_FUNDS_ALL_B_INT is referenced by following:

OZF
VIEW - OZF_FUNDS_ALL_B_INT#

[top of page]

Table: OZF_FUNDS_ALL_TL

Description: Fund setup master translation table.
Primary Key: OZF_FUNDS_ALL_TL_PK
  1. FUND_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_FUNDS_ALL_TL.FUND_ID OZF_FUNDS_ALL_B

[top of page]

OZF.OZF_FUNDS_ALL_TL does not reference any database object

OZF.OZF_FUNDS_ALL_TL is referenced by following:

OZF
VIEW - OZF_FUNDS_ALL_TL#

[top of page]

Table: OZF_FUNDS_PAID_ALL

Description: Funds paid details
Primary Key: FUNDPD_PK
  1. PAID_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_FUNDS_PAID_ALL.UTILIZATION_ID OZF_FUNDS_UTILIZED_ALL_B
OZF_FUNDS_PAID_ALL.UTILIZATION_ID OZF_FUNDS_UTILIZED_ALL_B
OZF_FUNDS_PAID_ALL.CLAIM_ID OZF_CLAIMS_ALL

[top of page]

OZF.OZF_FUNDS_PAID_ALL does not reference any database object

OZF.OZF_FUNDS_PAID_ALL is referenced by following:

OZF
VIEW - OZF_FUNDS_PAID_ALL#

[top of page]

Table: OZF_FUNDS_UTILIZED_ALL_B

Description: Fund utilization details
Primary Key: OZF_FUNDS_UTILIZED_ALL_B_PK
  1. UTILIZATION_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
OZF_FUNDS_PAID_ALL.UTILIZATION_ID OZF_FUNDS_UTILIZED_ALL_B
OZF_CLAIM_LINES_UTIL_ALL.UTILIZATION_ID OZF_FUNDS_UTILIZED_ALL_B
OZF_FUNDS_PAID_ALL.UTILIZATION_ID OZF_FUNDS_UTILIZED_ALL_B
OZF_FUNDS_UTILIZED_ALL_TL.UTILIZATION_ID OZF_FUNDS_UTILIZED_ALL_B

[top of page]

OZF.OZF_FUNDS_UTILIZED_ALL_B does not reference any database object

OZF.OZF_FUNDS_UTILIZED_ALL_B is referenced by following:

APPS
MATERIALIZED VIEW - OZF_CUST_FUND_SUMMARY_MV
MATERIALIZED VIEW - OZF_EARNING_SUMMARY_MV
OZF
VIEW - OZF_FUNDS_UTILIZED_ALL_B#

[top of page]

Table: OZF_FUNDS_UTILIZED_ALL_TL

Description: This table is used to store Fund utilization details (Translation Table)
Primary Key: OZF_FUNDS_UTILIZED_ALL_TL_PK
  1. UTILIZATION_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_FUNDS_UTILIZED_ALL_TL.UTILIZATION_ID OZF_FUNDS_UTILIZED_ALL_B

[top of page]

OZF.OZF_FUNDS_UTILIZED_ALL_TL does not reference any database object

OZF.OZF_FUNDS_UTILIZED_ALL_TL is referenced by following:

OZF
VIEW - OZF_FUNDS_UTILIZED_ALL_TL#

[top of page]

Table: OZF_FUND_REQUESTS

Description: Fund request tracking table.
Primary Key: OZF_FUND_REQUESTS_PK
  1. FUND_REQUEST_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_FUND_REQUESTS.TRANSFER_TO_ID OZF_FUNDS_ALL_B
OZF_FUND_REQUESTS.TRANSFER_FM_ID OZF_FUNDS_ALL_B

[top of page]

OZF.OZF_FUND_REQUESTS does not reference any database object

OZF.OZF_FUND_REQUESTS is referenced by following:

OZF
VIEW - OZF_FUND_REQUESTS#

[top of page]

Table: OZF_INTERFACE_ERRORS

Description: This table stores details of validation errors while loading data in interface tables.

[top of page]

OZF.OZF_INTERFACE_ERRORS does not reference any database object

OZF.OZF_INTERFACE_ERRORS is referenced by following:

OZF
VIEW - OZF_INTERFACE_ERRORS#

[top of page]

Table: OZF_INVENTORY_SUMMARY_MV

Description: Summary table for Inventory

[top of page]

OZF.OZF_INVENTORY_SUMMARY_MV does not reference any database object

OZF.OZF_INVENTORY_SUMMARY_MV is referenced by following:

OZF
VIEW - OZF_INVENTORY_SUMMARY_MV#

[top of page]

Table: OZF_INVENTORY_SUMMARY_MV_TEMP

Description: Temporary Summary Table for inventory

[top of page]

OZF.OZF_INVENTORY_SUMMARY_MV_TEMP does not reference any database object

OZF.OZF_INVENTORY_SUMMARY_MV_TEMP is referenced by following:

OZF
VIEW - OZF_INVENTORY_SUMMARY_MV_TEMP#

[top of page]

Table: OZF_INVENTORY_TMP_T

Description:

[top of page]

OZF.OZF_INVENTORY_TMP_T does not reference any database object

OZF.OZF_INVENTORY_TMP_T is referenced by following:

APPS
SYNONYM - OZF_INVENTORY_TMP_T

[top of page]

Table: OZF_LIFT_FACTORS_FACTS

Description: This table stores validated lift factors for Market, Product and Time dimension
Primary Key: OZF_LIFT_FACTORS_FACTS_PK
  1. LIFT_FACTORS_FACTS_ID

[top of page]

OZF.OZF_LIFT_FACTORS_FACTS does not reference any database object

OZF.OZF_LIFT_FACTORS_FACTS is referenced by following:

OZF
VIEW - OZF_LIFT_FACTORS_FACTS#

[top of page]

Table: OZF_LIFT_FACTORS_HISTORY

Description: This table stores historical lift factors as of history_snapshot_date
Primary Key: OZF_LIFT_FACTORS_HISTORY_PK
  1. LIFT_FACTORS_HISTORY_ID

[top of page]

OZF.OZF_LIFT_FACTORS_HISTORY does not reference any database object

OZF.OZF_LIFT_FACTORS_HISTORY is referenced by following:

OZF
VIEW - OZF_LIFT_FACTORS_HISTORY#

[top of page]

Table: OZF_LIFT_FACTORS_INTERFACE

Description: This Interface table stores lift factors across Market, Product and Time dimensions as uploaded by user
Primary Key: OZF_LIFT_FACTORS_INTERFACE_PK
  1. LIFT_FACTORS_INTERFACE_ID

[top of page]

OZF.OZF_LIFT_FACTORS_INTERFACE does not reference any database object

OZF.OZF_LIFT_FACTORS_INTERFACE is referenced by following:

OZF
VIEW - OZF_LIFT_FACTORS_INTERFACE#

[top of page]

Table: OZF_MARKET_PRESET_TIERS

Description: This table stores preset discount tier of discount Price Break Header (PBH).
Primary Key: OZF_MARKET_PK
  1. MARKET_PRESET_TIER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_MARKET_PRESET_TIERS.OFFER_MARKET_OPTION_ID OZF_OFFR_MARKET_OPTIONS

[top of page]

OZF.OZF_MARKET_PRESET_TIERS does not reference any database object

OZF.OZF_MARKET_PRESET_TIERS is referenced by following:

OZF
VIEW - OZF_MARKET_PRESET_TIERS#

[top of page]

Table: OZF_MC_TRANSACTIONS_ALL

Description: Multi-currency transaction table.
Primary Key: MC_PK
  1. MC_RECORD_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_MC_TRANSACTIONS_ALL.SOURCE_OBJECT_ID OZF_CLAIMS_ALL
OZF_MC_TRANSACTIONS_ALL.SOURCE_OBJECT_ID OZF_FUNDS_ALL_B

[top of page]

OZF.OZF_MC_TRANSACTIONS_ALL does not reference any database object

OZF.OZF_MC_TRANSACTIONS_ALL is referenced by following:

OZF
VIEW - OZF_MC_TRANSACTIONS_ALL#

[top of page]

Table: OZF_MULTI_CURR_UTIL_BCK

Description: OZF Fund Utilizations BACKUP for MULTI CURRENCY ER

[top of page]

OZF.OZF_MULTI_CURR_UTIL_BCK does not reference any database object

OZF.OZF_MULTI_CURR_UTIL_BCK is referenced by following:

OZF
VIEW - OZF_MULTI_CURR_UTIL_BCK#

[top of page]

Table: OZF_NAE_COMPLETION_TIME

Description: This table stores last completion time of net accrual engine for each org seperately
Primary Key: OZF_NAE_COMPLETION_TIME_PK
  1. NAE_COMPLETION_TIME_ID

[top of page]

OZF.OZF_NAE_COMPLETION_TIME does not reference any database object

OZF.OZF_NAE_COMPLETION_TIME is referenced by following:

OZF
VIEW - OZF_NAE_COMPLETION_TIME#

[top of page]

Table: OZF_NA_CONC_EXCEPTIONS

Description: Table to store the errored rows by Net Accrual Engine
Primary Key: OZF_NA_CONC_EXCEPTIONS_PK
  1. NA_CONC_EXCEPTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_NA_CONC_EXCEPTIONS.BUDGET_SOURCE_ID OZF_FUNDS_ALL_B

[top of page]

OZF.OZF_NA_CONC_EXCEPTIONS does not reference any database object

OZF.OZF_NA_CONC_EXCEPTIONS is referenced by following:

OZF
VIEW - OZF_NA_CONC_EXCEPTIONS#

[top of page]

Table: OZF_NA_CUSTOMERS_TEMP

Description: Table to store the customer eligibile for a Net Accrual Offer

[top of page]

OZF.OZF_NA_CUSTOMERS_TEMP does not reference any database object

OZF.OZF_NA_CUSTOMERS_TEMP is referenced by following:

OZF
VIEW - OZF_NA_CUSTOMERS_TEMP#

[top of page]

Table: OZF_NA_DEDUCTION_RULES_B

Description: Table to store the Net Accrual Deductions Rules
Primary Key: OZF_NA_DEDUCTION_RULES_B_PK
  1. NA_DEDUCTION_RULE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
OZF_NA_DEDUCTION_RULES_TL.NA_DEDUCTION_RULE_ID OZF_NA_DEDUCTION_RULES_B
OZF_NA_RULE_LINES.NA_DEDUCTION_RULE_ID OZF_NA_DEDUCTION_RULES_B

[top of page]

OZF.OZF_NA_DEDUCTION_RULES_B does not reference any database object

OZF.OZF_NA_DEDUCTION_RULES_B is referenced by following:

OZF
VIEW - OZF_NA_DEDUCTION_RULES_B#

[top of page]

Table: OZF_NA_DEDUCTION_RULES_TL

Description: Table to store the Translated Values for Deduction Rules
Primary Key: OZF_NA_DEDUCTION_RULES_TL_PK
  1. NA_DEDUCTION_RULE_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_NA_DEDUCTION_RULES_TL.NA_DEDUCTION_RULE_ID OZF_NA_DEDUCTION_RULES_B

[top of page]

OZF.OZF_NA_DEDUCTION_RULES_TL does not reference any database object

OZF.OZF_NA_DEDUCTION_RULES_TL is referenced by following:

OZF
VIEW - OZF_NA_DEDUCTION_RULES_TL#

[top of page]

Table: OZF_NA_PRODUCTS_TEMP

Description: Table to store the products eligible for a Net Accrual Offer

[top of page]

OZF.OZF_NA_PRODUCTS_TEMP does not reference any database object

OZF.OZF_NA_PRODUCTS_TEMP is referenced by following:

OZF
VIEW - OZF_NA_PRODUCTS_TEMP#

[top of page]

Table: OZF_NA_RULE_HEADERS_B

Description: Table To store the Net Accrual Rule sets
Primary Key: OZF_NA_RULE_HEADERS_B_PK
  1. NA_RULE_HEADER_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
OZF_NA_RULE_HEADERS_TL.NA_RULE_HEADER_ID OZF_NA_RULE_HEADERS_B
OZF_NA_RULE_LINES.NA_RULE_HEADER_ID OZF_NA_RULE_HEADERS_B
OZF_OFFERS.NA_RULE_HEADER_ID OZF_NA_RULE_HEADERS_B

[top of page]

OZF.OZF_NA_RULE_HEADERS_B does not reference any database object

OZF.OZF_NA_RULE_HEADERS_B is referenced by following:

OZF
VIEW - OZF_NA_RULE_HEADERS_B#

[top of page]

Table: OZF_NA_RULE_HEADERS_TL

Description: Table To store the translated Net Accrual Rule Sets
Primary Key: OZF_NA_RULE_HEADERS_TL_PK
  1. NA_RULE_HEADER_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_NA_RULE_HEADERS_TL.NA_RULE_HEADER_ID OZF_NA_RULE_HEADERS_B

[top of page]

OZF.OZF_NA_RULE_HEADERS_TL does not reference any database object

OZF.OZF_NA_RULE_HEADERS_TL is referenced by following:

OZF
VIEW - OZF_NA_RULE_HEADERS_TL#

[top of page]

Table: OZF_NA_RULE_LINES

Description: Table to store the Deduction rules for a Net accrual Rule Set
Primary Key: OZF_NA_RULE_LINES_PK
  1. NA_RULE_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_NA_RULE_LINES.NA_RULE_HEADER_ID OZF_NA_RULE_HEADERS_B
OZF_NA_RULE_LINES.NA_DEDUCTION_RULE_ID OZF_NA_DEDUCTION_RULES_B

[top of page]

OZF.OZF_NA_RULE_LINES does not reference any database object

OZF.OZF_NA_RULE_LINES is referenced by following:

OZF
VIEW - OZF_NA_RULE_LINES#

[top of page]

Table: OZF_NA_UNIQUE_PRODUCTS_TEMP

Description: Table to store the unique products eligible for Net Accrual Offer.

[top of page]

OZF.OZF_NA_UNIQUE_PRODUCTS_TEMP does not reference any database object

OZF.OZF_NA_UNIQUE_PRODUCTS_TEMP is referenced by following:

OZF
VIEW - OZF_NA_UNIQUE_PRODUCTS_TEMP#

[top of page]

Table: OZF_OBJECT_FUND_SUMMARY

Description: Object Fund Summary Definition
Primary Key: OZF_OBJECT_FUND_SUMMARY_PK
  1. OBJFUNDSUM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_OBJECT_FUND_SUMMARY.FUND_ID OZF_FUNDS_ALL_B
OZF_OBJECT_FUND_SUMMARY.OBJECT_ID AMS_CAMPAIGNS_ALL_B
OZF_OBJECT_FUND_SUMMARY.OBJECT_ID AMS_EVENT_HEADERS_ALL_B

[top of page]

OZF.OZF_OBJECT_FUND_SUMMARY does not reference any database object

OZF.OZF_OBJECT_FUND_SUMMARY is referenced by following:

OZF
VIEW - OZF_OBJECT_FUND_SUMMARY#

[top of page]

Table: OZF_OFFERS

Description: This is a surrogate table to QP_LIST_HEADERS_B for Offers related information. QP_LIST_HEADER_ID is the foreign key to QP_LIST_HEADERS_B. This table will capture status, peformance dates and lumpsum related offer types.
Primary Key: OZF_OFFERS_PK
  1. OFFER_ID
Primary Key: OZF_OFFERS_UK1
  1. OFFER_CODE
Primary Key: OZF_OFFERS_UK2
  1. QP_LIST_HEADER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_OFFERS.USER_STATUS_ID AMS_USER_STATUSES_B
OZF_OFFERS.CUSTOM_SETUP_ID AMS_CUSTOM_SETUPS_B
OZF_OFFERS.ACTIVITY_MEDIA_ID AMS_MEDIA_B
OZF_OFFERS.OWNER_ID JTF_RS_RESOURCE_EXTNS
OZF_OFFERS.BUYING_GROUP_CONTACT_ID HZ_PARTIES
OZF_OFFERS.QP_LIST_HEADER_ID QP_LIST_HEADERS_B
OZF_OFFERS.BUDGET_SOURCE_ID OZF_FUNDS_ALL_B
OZF_OFFERS.NA_RULE_HEADER_ID OZF_NA_RULE_HEADERS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
OZF_ACTIVITY_CUSTOMERS.OBJECT_ID OZF_OFFERS
OZF_ACTIVITY_PRODUCTS.OBJECT_ID OZF_OFFERS
OZF_ACT_FORECASTS_ALL.ACT_FCAST_USED_BY_ID OZF_OFFERS
OZF_ACT_OFFERS.QP_LIST_HEADER_ID OZF_OFFERS
OZF_FORECAST_CUSTOMERS.OBJ_ID OZF_OFFERS
OZF_FORECAST_DIMENTIONS.OBJ_ID OZF_OFFERS
OZF_FORECAST_PERIODS.OBJ_ID OZF_OFFERS
OZF_FORECAST_PRODUCTS.OBJ_ID OZF_OFFERS
OZF_FORECAST_PROD_EXCLUSIONS.OBJ_ID OZF_OFFERS
OZF_OFFER_ADJUSTMENTS_B.LIST_HEADER_ID OZF_OFFERS
OZF_OFFER_DISCOUNT_LINES.OFFER_ID OZF_OFFERS
OZF_OFFER_DISCOUNT_PRODUCTS.OFFER_ID OZF_OFFERS
OZF_OFFER_PERFORMANCES.USED_BY_ID OZF_OFFERS
OZF_OFFER_QUALIFIERS.OFFER_ID OZF_OFFERS
OZF_PRICE_LIST_ATTRIBUTES.QP_LIST_HEADER_ID OZF_OFFERS
OZF_RELATED_DEAL_LINES.QP_LIST_HEADER_ID OZF_OFFERS
OZF_REQUEST_HEADERS_ALL_B.OFFER_ID OZF_OFFERS
OZF_VOLUME_OFFER_TIERS.QP_LIST_HEADER_ID OZF_OFFERS
PV_PG_INVITE_HEADERS_B.QP_LIST_HEADER_ID OZF_OFFERS

[top of page]

OZF.OZF_OFFERS does not reference any database object

OZF.OZF_OFFERS is referenced by following:

APPS
MATERIALIZED VIEW - OZF_EARNING_SUMMARY_MV
OZF
VIEW - OZF_OFFERS#

[top of page]

Table: OZF_OFFER_ADJUSTMENTS_B

Description: Stores all the adjustments made for an offer
Primary Key: OZF_OFFER_ADJUSTMENTS_B_PK
  1. OFFER_ADJUSTMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_OFFER_ADJUSTMENTS_B.LIST_HEADER_ID OZF_OFFERS
Foreign Keys to this table:
Foreign Key Column Foreign Table
OZF_OFFER_ADJUSTMENTS_TL.OFFER_ADJUSTMENT_ID OZF_OFFER_ADJUSTMENTS_B
OZF_OFFER_ADJUSTMENT_LINES.OFFER_ADJUSTMENT_ID OZF_OFFER_ADJUSTMENTS_B
OZF_OFFER_ADJUSTMENT_TIERS.OFFER_ADJUSTMENT_ID OZF_OFFER_ADJUSTMENTS_B

[top of page]

OZF.OZF_OFFER_ADJUSTMENTS_B does not reference any database object

OZF.OZF_OFFER_ADJUSTMENTS_B is referenced by following:

OZF
VIEW - OZF_OFFER_ADJUSTMENTS_B#

[top of page]

Table: OZF_OFFER_ADJUSTMENTS_TL

Description: stores all translatable columns for offer adjustments
Primary Key: OZF_OFFER_ADJUSTMENTS_TL_PK
  1. OFFER_ADJUSTMENT_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_OFFER_ADJUSTMENTS_TL.OFFER_ADJUSTMENT_ID OZF_OFFER_ADJUSTMENTS_B

[top of page]

OZF.OZF_OFFER_ADJUSTMENTS_TL does not reference any database object

OZF.OZF_OFFER_ADJUSTMENTS_TL is referenced by following:

OZF
VIEW - OZF_OFFER_ADJUSTMENTS_TL#

[top of page]

Table: OZF_OFFER_ADJUSTMENT_LINES

Description: Stores the discount information for an offer adjustment
Primary Key: OZF_OFFER_ADJUSTMENT_LINES_PK
  1. OFFER_ADJUSTMENT_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_OFFER_ADJUSTMENT_LINES.OFFER_ADJUSTMENT_ID OZF_OFFER_ADJUSTMENTS_B

[top of page]

OZF.OZF_OFFER_ADJUSTMENT_LINES does not reference any database object

OZF.OZF_OFFER_ADJUSTMENT_LINES is referenced by following:

OZF
VIEW - OZF_OFFER_ADJUSTMENT_LINES#

[top of page]

Table: OZF_OFFER_ADJUSTMENT_PRODUCTS

Description: Stores the product information for an offer adjustment.
Primary Key: OZF_OFFER_ADJUSTMENT_PROD_PK
  1. OFFER_ADJUSTMENT_PRODUCT_ID

[top of page]

OZF.OZF_OFFER_ADJUSTMENT_PRODUCTS does not reference any database object

OZF.OZF_OFFER_ADJUSTMENT_PRODUCTS is referenced by following:

OZF
VIEW - OZF_OFFER_ADJUSTMENT_PRODUCTS#

[top of page]

Table: OZF_OFFER_ADJUSTMENT_TIERS

Description: This table stores tier infomation for offer adjustments
Primary Key: OZF_OFFER_ADJUSTMENT_TIERS_PK
  1. OFFER_ADJST_TIER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_OFFER_ADJUSTMENT_TIERS.OFFER_ADJUSTMENT_ID OZF_OFFER_ADJUSTMENTS_B

[top of page]

OZF.OZF_OFFER_ADJUSTMENT_TIERS does not reference any database object

OZF.OZF_OFFER_ADJUSTMENT_TIERS is referenced by following:

OZF
VIEW - OZF_OFFER_ADJUSTMENT_TIERS#

[top of page]

Table: OZF_OFFER_ADJ_NEW_LINES

Description: Stores the discount information for new product adjustment
Primary Key: OZF_OFFER_ADJ_NEW_LINES_PK
  1. OFFER_ADJ_NEW_LINE_ID

[top of page]

OZF.OZF_OFFER_ADJ_NEW_LINES does not reference any database object

OZF.OZF_OFFER_ADJ_NEW_LINES is referenced by following:

OZF
VIEW - OZF_OFFER_ADJ_NEW_LINES#

[top of page]

Table: OZF_OFFER_ADJ_NEW_PRODUCTS

Description: Stores the product information for new product adjustment.
Primary Key: OZF_OFFER_ADJ_NEW_PRODUCTS_PK
  1. OFFER_ADJ_NEW_PRODUCT_ID

[top of page]

OZF.OZF_OFFER_ADJ_NEW_PRODUCTS does not reference any database object

OZF.OZF_OFFER_ADJ_NEW_PRODUCTS is referenced by following:

OZF
VIEW - OZF_OFFER_ADJ_NEW_PRODUCTS#

[top of page]

Table: OZF_OFFER_ADJ_RLTD_LINES

Description: This table is used for Trade Deal offer adjustment. Trade Deal Offers can have two modifiers in one deal line. This table captures the relation between two lines. From_list_line_id and to_list_line_id are foreign keys to list_line_id in QP_
Primary Key: OZF_OFFER_ADJ_RLTD_LINES_PK
  1. OFFER_ADJ_RLTD_LINE_ID

[top of page]

OZF.OZF_OFFER_ADJ_RLTD_LINES does not reference any database object

OZF.OZF_OFFER_ADJ_RLTD_LINES is referenced by following:

OZF
VIEW - OZF_OFFER_ADJ_RLTD_LINES#

[top of page]

Table: OZF_OFFER_DISCOUNT_LINES

Description: Table to store the Discount Lines of a Net Accrual Offer
Primary Key: OZF_OFFER_DISCOUNT_LINES
  1. OFFER_DISCOUNT_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_OFFER_DISCOUNT_LINES.OFFER_ID OZF_OFFERS
Foreign Keys to this table:
Foreign Key Column Foreign Table
OZF_DISCOUNT_PRODUCT_RELN.OFFER_DISCOUNT_LINE_ID OZF_OFFER_DISCOUNT_LINES
OZF_OFFER_DISCOUNT_PRODUCTS.OFFER_DISCOUNT_LINE_ID OZF_OFFER_DISCOUNT_LINES

[top of page]

OZF.OZF_OFFER_DISCOUNT_LINES does not reference any database object

OZF.OZF_OFFER_DISCOUNT_LINES is referenced by following:

OZF
VIEW - OZF_OFFER_DISCOUNT_LINES#

[top of page]

Table: OZF_OFFER_DISCOUNT_PRODUCTS

Description: Table to store the products for an Offer
Primary Key: OZF_OFFER_DISCOUNT_PRODUCTS_PK
  1. OFF_DISCOUNT_PRODUCT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_OFFER_DISCOUNT_PRODUCTS.OFFER_ID OZF_OFFERS
OZF_OFFER_DISCOUNT_PRODUCTS.OFFER_DISCOUNT_LINE_ID OZF_OFFER_DISCOUNT_LINES
Foreign Keys to this table:
Foreign Key Column Foreign Table
OZF_DISCOUNT_PRODUCT_RELN.OFF_DISCOUNT_PRODUCT_ID OZF_OFFER_DISCOUNT_PRODUCTS

[top of page]

OZF.OZF_OFFER_DISCOUNT_PRODUCTS does not reference any database object

OZF.OZF_OFFER_DISCOUNT_PRODUCTS is referenced by following:

OZF
VIEW - OZF_OFFER_DISCOUNT_PRODUCTS#

[top of page]

Table: OZF_OFFER_PARTIES

Description: This table stores all the parties eligible for the request only active offers created through Oracle Trade Management.
Primary Key: OZF_OFFER_PARTIES_PK
  1. OFFER_PARTY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_OFFER_PARTIES.QP_LIST_HEADER_ID QP_LIST_HEADERS_B
OZF_OFFER_PARTIES.PARTY_ID HZ_PARTIES

[top of page]

OZF.OZF_OFFER_PARTIES does not reference any database object

OZF.OZF_OFFER_PARTIES is referenced by following:

OZF
VIEW - OZF_OFFER_PARTIES#

[top of page]

Table: OZF_OFFER_PARTIES_TEMP

Description: This table stores all the parties eligible for the request only active offers created through Oracle Trade Management temporarily when full refresh is performed through the concurrent program.
Primary Key: OZF_OFFER_PARTIES_TEMP_PK
  1. OFFER_PARTY_ID

[top of page]

OZF.OZF_OFFER_PARTIES_TEMP does not reference any database object

OZF.OZF_OFFER_PARTIES_TEMP is referenced by following:

OZF
VIEW - OZF_OFFER_PARTIES_TEMP#

[top of page]

Table: OZF_OFFER_PERFORMANCES

Description: The performance rules defined for an offer are stored in this table.
Primary Key: OZF_OFFER_PERFORMANCES_PK
  1. OFFER_PERFORMANCE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_OFFER_PERFORMANCES.USED_BY_ID OZF_OFFERS
OZF_OFFER_PERFORMANCES.USED_BY_ID OZF_WORKSHEET_HEADERS_B

[top of page]

OZF.OZF_OFFER_PERFORMANCES does not reference any database object

OZF.OZF_OFFER_PERFORMANCES is referenced by following:

OZF
VIEW - OZF_OFFER_PERFORMANCES#

[top of page]

Table: OZF_OFFER_PRODUCTS

Description: This table stores all the products defined for the request only active offers created through Oracle Trade Management.
Primary Key: OZF_OFFER_PRODUCTS_PK
  1. OFFER_PRODUCT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_OFFER_PRODUCTS.QP_LIST_HEADER_ID QP_LIST_HEADERS_B

[top of page]

OZF.OZF_OFFER_PRODUCTS does not reference any database object

OZF.OZF_OFFER_PRODUCTS is referenced by following:

OZF
VIEW - OZF_OFFER_PRODUCTS#

[top of page]

Table: OZF_OFFER_PRODUCTS_TEMP

Description: This table stores all the products defined for the request only active offers created through Oracle Trade Management temporarily when full refresh is performed through the concurrent program.
Primary Key: OZF_OFFER_PRODUCTS_TEMP_PK
  1. OFFER_PRODUCT_ID

[top of page]

OZF.OZF_OFFER_PRODUCTS_TEMP does not reference any database object

OZF.OZF_OFFER_PRODUCTS_TEMP is referenced by following:

OZF
VIEW - OZF_OFFER_PRODUCTS_TEMP#

[top of page]

Table: OZF_OFFER_QUALIFIERS

Description: This table stores the market eligibility for Trade Management Offers
Primary Key: OZF_OFFER_QUALIFIERS_PK
  1. QUALIFIER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_OFFER_QUALIFIERS.OFFER_ID OZF_OFFERS

[top of page]

OZF.OZF_OFFER_QUALIFIERS does not reference any database object

OZF.OZF_OFFER_QUALIFIERS is referenced by following:

OZF
VIEW - OZF_OFFER_QUALIFIERS#

[top of page]

Table: OZF_OFFR_DISC_STRUCT_NAME_B

Description: This table stores name of discount table structure in volume offer.
Primary Key: OZF_OFFR_DISC_STRUCT_NAME_B_PK
  1. OFFR_DISC_STRUCT_NAME_ID

[top of page]

OZF.OZF_OFFR_DISC_STRUCT_NAME_B does not reference any database object

OZF.OZF_OFFR_DISC_STRUCT_NAME_B is referenced by following:

OZF
VIEW - OZF_OFFR_DISC_STRUCT_NAME_B#

[top of page]

Table: OZF_OFFR_DISC_STRUCT_NAME_TL

Description: This table stores translated value of discount structure name.
Primary Key: OZF_OFFR_DISC_STRUCT_NAME_T_PK
  1. OFFR_DISC_STRUCT_NAME_ID
  2. LANGUAGE

[top of page]

OZF.OZF_OFFR_DISC_STRUCT_NAME_TL does not reference any database object

OZF.OZF_OFFR_DISC_STRUCT_NAME_TL is referenced by following:

OZF
VIEW - OZF_OFFR_DISC_STRUCT_NAME_TL#

[top of page]

Table: OZF_OFFR_MARKET_OPTIONS

Description: This table stores market option for market eligibility group in volume offer.
Primary Key: OZF_OFFR_MARKET_OPTIONS
  1. OFFER_MARKET_OPTION_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
OZF_MARKET_PRESET_TIERS.OFFER_MARKET_OPTION_ID OZF_OFFR_MARKET_OPTIONS

[top of page]

OZF.OZF_OFFR_MARKET_OPTIONS does not reference any database object

OZF.OZF_OFFR_MARKET_OPTIONS is referenced by following:

OZF
VIEW - OZF_OFFR_MARKET_OPTIONS#

[top of page]

Table: OZF_ORDER_GROUP_PROD

Description: This table stores order line info with qualifying product and market qualifiers
Primary Key: OZF_ORDER_GROUP_PROD_PK
  1. ORDER_GROUP_PROD_ID

[top of page]

OZF.OZF_ORDER_GROUP_PROD does not reference any database object

OZF.OZF_ORDER_GROUP_PROD is referenced by following:

OZF
VIEW - OZF_ORDER_GROUP_PROD#

[top of page]

Table: OZF_ORDER_MESSAGE_COUNTER

Description: Table to store number of messages in Order Capture's Advanced Quque
Primary Key: OZF_ORDER_MESSAGE_COUNTER_PK
  1. ORDER_MESSAGE_COUNTER_ID

[top of page]

OZF.OZF_ORDER_MESSAGE_COUNTER does not reference any database object

OZF.OZF_ORDER_MESSAGE_COUNTER is referenced by following:

OZF
VIEW - OZF_ORDER_MESSAGE_COUNTER#

[top of page]

Table: OZF_ORDER_SALES_SUMRY_MV

Description: Summary Table for storing Order Sales data

[top of page]

OZF.OZF_ORDER_SALES_SUMRY_MV does not reference any database object

OZF.OZF_ORDER_SALES_SUMRY_MV is referenced by following:

OZF
VIEW - OZF_ORDER_SALES_SUMRY_MV#

[top of page]

Table: OZF_ORDER_SALES_SUMRY_MV_TEMP

Description: Summary Table for storing Order Sales

[top of page]

OZF.OZF_ORDER_SALES_SUMRY_MV_TEMP does not reference any database object

OZF.OZF_ORDER_SALES_SUMRY_MV_TEMP is referenced by following:

OZF
VIEW - OZF_ORDER_SALES_SUMRY_MV_TEMP#

[top of page]

Table: OZF_PARTY_MARKET_SEGMENTS_T

Description:

[top of page]

APPS.OZF_PARTY_MARKET_SEGMENTS_T does not reference any database object

APPS.OZF_PARTY_MARKET_SEGMENTS_T is referenced by following:

APPS
PACKAGE BODY - OZF_ALLOCATION_ENGINE_PVT
PACKAGE BODY - OZF_PARTY_MKT_SEG_LOADER_PVT

[top of page]

Table: OZF_PRICE_LIST_ATTRIBUTES

Description: This is a surrogate table to QP_LIST_HEADERS_B for Price List related information. QP_LIST_HEADER_ID is the foreign key to QP_LIST_HEADERS_B. This table will capture status, owner and other attributes specifice to Trade Management Requir
Primary Key: OZF_PRICE_LIST_ATTRIBUTES_PK
  1. PRICE_LIST_ATTRIBUTE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_PRICE_LIST_ATTRIBUTES.OWNER_ID JTF_RS_RESOURCE_EXTNS
OZF_PRICE_LIST_ATTRIBUTES.QP_LIST_HEADER_ID OZF_OFFERS
OZF_PRICE_LIST_ATTRIBUTES.CUSTOM_SETUP_ID AMS_CUSTOM_SETUPS_B
OZF_PRICE_LIST_ATTRIBUTES.USER_STATUS_ID AMS_USER_STATUSES_B

[top of page]

OZF.OZF_PRICE_LIST_ATTRIBUTES does not reference any database object

OZF.OZF_PRICE_LIST_ATTRIBUTES is referenced by following:

OZF
VIEW - OZF_PRICE_LIST_ATTRIBUTES#

[top of page]

Table: OZF_PROCESS_SETUP_ALL

Description: OZF_PROCESS_SETUP_ALL stores the Price Protection Execution process setup details (whether processes are enabled/disable or they are automatic/manual)

[top of page]

OZF.OZF_PROCESS_SETUP_ALL does not reference any database object

OZF.OZF_PROCESS_SETUP_ALL is referenced by following:

OZF
VIEW - OZF_PROCESS_SETUP_ALL#

[top of page]

Table: OZF_PRODUCT_ALLOCATIONS

Description: Table to store the Prooduct allocations
Primary Key: OZF_PRODUCT_ALLOCATIONS_PK
  1. PRODUCT_ALLOCATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_PRODUCT_ALLOCATIONS.FUND_ID OZF_FUNDS_ALL_B
OZF_PRODUCT_ALLOCATIONS.ALLOCATION_FOR_ID OZF_ACCOUNT_ALLOCATIONS
OZF_PRODUCT_ALLOCATIONS.ALLOCATION_FOR_ID OZF_ACT_METRIC_FACTS_ALL
OZF_PRODUCT_ALLOCATIONS.ALLOCATION_FOR_ID OZF_FUNDS_ALL_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
OZF_TIME_ALLOCATIONS.ALLOCATION_FOR_ID OZF_PRODUCT_ALLOCATIONS

[top of page]

OZF.OZF_PRODUCT_ALLOCATIONS does not reference any database object

OZF.OZF_PRODUCT_ALLOCATIONS is referenced by following:

OZF
VIEW - OZF_PRODUCT_ALLOCATIONS#

[top of page]

Table: OZF_QP_DISCOUNTS

Description: This table stores mapping between offer discount line and QP list line.
Primary Key: OZF_QP_DISCOUNT_ID
  1. OZF_QP_DISCOUNT_ID

[top of page]

OZF.OZF_QP_DISCOUNTS does not reference any database object

OZF.OZF_QP_DISCOUNTS is referenced by following:

OZF
VIEW - OZF_QP_DISCOUNTS#

[top of page]

Table: OZF_QP_PRODUCTS

Description: This table stores mapping between offer discount product and QP pricing attribute.
Primary Key: QP_PRODUCT_ID
  1. QP_PRODUCT_ID

[top of page]

OZF.OZF_QP_PRODUCTS does not reference any database object

OZF.OZF_QP_PRODUCTS is referenced by following:

OZF
VIEW - OZF_QP_PRODUCTS#

[top of page]

Table: OZF_QUALIFIER_MARKET_OPTION

Description: This table stores relationship between offer market option and QP qualifier.
Primary Key: OQN_PK
  1. QUALIFIER_MARKET_OPTION_ID

[top of page]

OZF.OZF_QUALIFIER_MARKET_OPTION does not reference any database object

OZF.OZF_QUALIFIER_MARKET_OPTION is referenced by following:

OZF
VIEW - OZF_QUALIFIER_MARKET_OPTION#

[top of page]

Table: OZF_QUOTA_ALERTS

Description: Table to store the Quota Alerts
Primary Key: OZF_QUOTA_ALERTS_PK
  1. QUOTA_ALERT_ID

[top of page]

OZF.OZF_QUOTA_ALERTS does not reference any database object

OZF.OZF_QUOTA_ALERTS is referenced by following:

OZF
VIEW - OZF_QUOTA_ALERTS#

[top of page]

Table: OZF_REASONS

Description: This Table is used to store Reason Codes
Primary Key: OZF_REASON_TYPES_PK
  1. REASON_TYPE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_REASONS.TASK_TEMPLATE_GROUP_ID JTF_TASK_TEMP_GROUPS_B
OZF_REASONS.REASON_CODE_ID OZF_REASON_CODES_ALL_B
OZF_REASONS.TASK_TEMPLATE_GROUP_ID JTF_TASK_TEMP_GROUPS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
OZF_REASON_CODES_ALL_B.REASON_TYPE_ID OZF_REASONS

[top of page]

OZF.OZF_REASONS does not reference any database object

OZF.OZF_REASONS is referenced by following:

OZF
VIEW - OZF_REASONS#

[top of page]

Table: OZF_REASON_CODES_ALL_B

Description: This table is used for storing the reasons for a claim
Primary Key: OZF_REASON_CODES_ALL_B_PK
  1. REASON_CODE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_REASON_CODES_ALL_B.REASON_TYPE_ID JTF_TASK_TEMP_GROUPS_B
OZF_REASON_CODES_ALL_B.REASON_TYPE_ID OZF_REASONS
Foreign Keys to this table:
Foreign Key Column Foreign Table
OZF_CLAIMS_ALL.REASON_CODE_ID OZF_REASON_CODES_ALL_B
OZF_REASONS.REASON_CODE_ID OZF_REASON_CODES_ALL_B
OZF_REASON_CODES_ALL_TL.REASON_CODE_ID OZF_REASON_CODES_ALL_B
OZF_SYS_PARAMETERS_ALL.AUTOPAY_REASON_CODE_ID OZF_REASON_CODES_ALL_B
OZF_SYS_PARAMETERS_ALL.REASON_CODE_ID OZF_REASON_CODES_ALL_B

[top of page]

OZF.OZF_REASON_CODES_ALL_B does not reference any database object

OZF.OZF_REASON_CODES_ALL_B is referenced by following:

OZF
VIEW - OZF_REASON_CODES_ALL_B#
- OZF_REASON_CODES_ALL_B#

[top of page]

Table: OZF_REASON_CODES_ALL_TL

Description: This Table is used to store Reason Codes (Translatable Codes)
Primary Key: OZF_REASON_CODES_ALL_TL_PK
  1. REASON_CODE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_REASON_CODES_ALL_TL.REASON_CODE_ID OZF_REASON_CODES_ALL_B

[top of page]

OZF.OZF_REASON_CODES_ALL_TL does not reference any database object

OZF.OZF_REASON_CODES_ALL_TL is referenced by following:

OZF
VIEW - OZF_REASON_CODES_ALL_TL#

[top of page]

Table: OZF_RELATED_DEAL_LINES

Description: This table is used for Trade Deal Offers. Trade Deal Offers can have two modifiers in one deal line. This table will capture the relation between two lines. Modifier_id and related_modifier_id are foreign keys to list_line_id in QP_LIS
Primary Key: OZF_RELATED_DEAL_LINES_PK
  1. RELATED_DEAL_LINES_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_RELATED_DEAL_LINES.MODIFIER_ID QP_LIST_LINES
OZF_RELATED_DEAL_LINES.RELATED_MODIFIER_ID QP_LIST_LINES
OZF_RELATED_DEAL_LINES.QP_LIST_HEADER_ID OZF_OFFERS

[top of page]

OZF.OZF_RELATED_DEAL_LINES does not reference any database object

OZF.OZF_RELATED_DEAL_LINES is referenced by following:

OZF
VIEW - OZF_RELATED_DEAL_LINES#

[top of page]

Table: OZF_REQUEST_HEADERS_ALL_B

Description: This table stores the request headers information for soft fund and special pricing
Primary Key: OZF_REQUEST_HEADERS_ALL_B_PK
  1. REQUEST_HEADER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_REQUEST_HEADERS_ALL_B.OFFER_ID OZF_OFFERS
OZF_REQUEST_HEADERS_ALL_B.LINKED_REQUEST_HEADER_ID OZF_REQUEST_HEADERS_ALL_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
OZF_APPROVAL_ACCESS.OBJECT_ID OZF_REQUEST_HEADERS_ALL_B
OZF_CLAIMS_ALL.SOURCE_OBJECT_ID OZF_REQUEST_HEADERS_ALL_B
OZF_REQUEST_HEADERS_ALL_B.LINKED_REQUEST_HEADER_ID OZF_REQUEST_HEADERS_ALL_B
OZF_REQUEST_HEADERS_ALL_TL.REQUEST_HEADER_ID OZF_REQUEST_HEADERS_ALL_B
OZF_REQUEST_LINES_ALL.REQUEST_HEADER_ID OZF_REQUEST_HEADERS_ALL_B

[top of page]

OZF.OZF_REQUEST_HEADERS_ALL_B does not reference any database object

OZF.OZF_REQUEST_HEADERS_ALL_B is referenced by following:

OZF
VIEW - OZF_REQUEST_HEADERS_ALL_B#

[top of page]

Table: OZF_REQUEST_HEADERS_ALL_TL

Description: This table stores the request headers information for soft fund and special pricing
Primary Key: OZF_REQUEST_HEADERS_ALL_TL_PK
  1. REQUEST_HEADER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_REQUEST_HEADERS_ALL_TL.REQUEST_HEADER_ID OZF_REQUEST_HEADERS_ALL_B

[top of page]

OZF.OZF_REQUEST_HEADERS_ALL_TL does not reference any database object

OZF.OZF_REQUEST_HEADERS_ALL_TL is referenced by following:

OZF
VIEW - OZF_REQUEST_HEADERS_ALL_TL#

[top of page]

Table: OZF_REQUEST_LINES_ALL

Description: This table stores the request lines information for soft fund and special pricing
Primary Key: OZF_REQUEST_LINES_ALL_PK
  1. REQUEST_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_REQUEST_LINES_ALL.REQUEST_HEADER_ID OZF_REQUEST_HEADERS_ALL_B

[top of page]

OZF.OZF_REQUEST_LINES_ALL does not reference any database object

OZF.OZF_REQUEST_LINES_ALL is referenced by following:

OZF
VIEW - OZF_REQUEST_LINES_ALL#

[top of page]

Table: OZF_RESALE_ADJUSTMENTS_ALL

Description: charge back price adjustments
Primary Key: OZF_RESALE_ADJUSTMENTS_ALL_PK
  1. RESALE_ADJUSTMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_RESALE_ADJUSTMENTS_ALL.RESALE_LINE_ID OZF_RESALE_LINES_ALL
OZF_RESALE_ADJUSTMENTS_ALL.RESALE_BATCH_ID OZF_RESALE_BATCHES_ALL

[top of page]

OZF.OZF_RESALE_ADJUSTMENTS_ALL does not reference any database object

OZF.OZF_RESALE_ADJUSTMENTS_ALL is referenced by following:

OZF
VIEW - OZF_RESALE_ADJUSTMENTS_ALL#

[top of page]

Table: OZF_RESALE_BATCHES_ALL

Description: This table stores the batches for Resale
Primary Key: OZF_RESALE_BATCHES_ALL_PK
  1. RESALE_BATCH_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
OZF_RESALE_ADJUSTMENTS_ALL.RESALE_BATCH_ID OZF_RESALE_BATCHES_ALL
OZF_RESALE_BATCH_LINE_MAPS_ALL.RESALE_BATCH_ID OZF_RESALE_BATCHES_ALL
OZF_RESALE_LINES_INT_ALL.RESALE_BATCH_ID OZF_RESALE_BATCHES_ALL

[top of page]

OZF.OZF_RESALE_BATCHES_ALL does not reference any database object

OZF.OZF_RESALE_BATCHES_ALL is referenced by following:

OZF
VIEW - OZF_RESALE_BATCHES_ALL#

[top of page]

Table: OZF_RESALE_BATCH_LINE_MAPS_ALL

Description: This table contains the mappings between the batch header and the resale order lines that were submitted along with that batch
Primary Key: OZF_RESALE_BATCH_LINE_MAPS_PK
  1. RESALE_BATCH_LINE_MAP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_RESALE_BATCH_LINE_MAPS_ALL.RESALE_BATCH_ID OZF_RESALE_BATCHES_ALL
OZF_RESALE_BATCH_LINE_MAPS_ALL.RESALE_LINE_ID OZF_RESALE_LINES_ALL

[top of page]

OZF.OZF_RESALE_BATCH_LINE_MAPS_ALL does not reference any database object

OZF.OZF_RESALE_BATCH_LINE_MAPS_ALL is referenced by following:

OZF
VIEW - OZF_RESALE_BATCH_LINE_MAPS_AL#

[top of page]

Table: OZF_RESALE_HEADERS_ALL

Description: Resale header information
Primary Key: OZF_RESALE_HEADERS_ALL_PK
  1. RESALE_HEADER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_RESALE_HEADERS_ALL.BILL_TO_CUST_ACCOUNT_ID HZ_CUST_ACCOUNTS
OZF_RESALE_HEADERS_ALL.BILL_TO_SITE_USE_ID HZ_CUST_SITE_USES_ALL
OZF_RESALE_HEADERS_ALL.SHIP_TO_CUST_ACCOUNT_ID HZ_CUST_ACCOUNTS
OZF_RESALE_HEADERS_ALL.SHIP_TO_SITE_USE_ID HZ_CUST_SITE_USES_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
OZF_RESALE_LINES_ALL.RESALE_HEADER_ID OZF_RESALE_HEADERS_ALL

[top of page]

OZF.OZF_RESALE_HEADERS_ALL does not reference any database object

OZF.OZF_RESALE_HEADERS_ALL is referenced by following:

OZF
VIEW - OZF_RESALE_HEADERS_ALL#

[top of page]

Table: OZF_RESALE_LINES_ALL

Description: Chargeback Lines information
Primary Key: OZF_RESALE_LINES_ALL_PK
  1. RESALE_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_RESALE_LINES_ALL.RESALE_HEADER_ID OZF_RESALE_HEADERS_ALL
OZF_RESALE_LINES_ALL.BILL_TO_CUST_ACCOUNT_ID HZ_CUST_ACCOUNTS
OZF_RESALE_LINES_ALL.BILL_TO_SITE_USE_ID HZ_CUST_SITE_USES_ALL
OZF_RESALE_LINES_ALL.SHIP_TO_CUST_ACCOUNT_ID HZ_CUST_ACCOUNTS
OZF_RESALE_LINES_ALL.SHIP_TO_SITE_USE_ID HZ_CUST_SITE_USES_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
OZF_RESALE_ADJUSTMENTS_ALL.RESALE_LINE_ID OZF_RESALE_LINES_ALL
OZF_RESALE_BATCH_LINE_MAPS_ALL.RESALE_LINE_ID OZF_RESALE_LINES_ALL

[top of page]

OZF.OZF_RESALE_LINES_ALL does not reference any database object

OZF.OZF_RESALE_LINES_ALL is referenced by following:

OZF
VIEW - OZF_RESALE_LINES_ALL#

[top of page]

Table: OZF_RESALE_LINES_INT_ALL

Description: Resale Lines Interface Table
Primary Key: OZF_RESALE_LINES_INT_ALL_PK
  1. RESALE_LINE_INT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_RESALE_LINES_INT_ALL.BILL_TO_CUST_ACCOUNT_ID HZ_CUST_ACCOUNTS
OZF_RESALE_LINES_INT_ALL.BILL_TO_SITE_USE_ID HZ_CUST_SITE_USES_ALL
OZF_RESALE_LINES_INT_ALL.SHIP_TO_CUST_ACCOUNT_ID HZ_CUST_ACCOUNTS
OZF_RESALE_LINES_INT_ALL.SHIP_TO_SITE_USE_ID HZ_CUST_SITE_USES_ALL
OZF_RESALE_LINES_INT_ALL.RESALE_BATCH_ID OZF_RESALE_BATCHES_ALL

[top of page]

OZF.OZF_RESALE_LINES_INT_ALL does not reference any database object

OZF.OZF_RESALE_LINES_INT_ALL is referenced by following:

OZF
VIEW - OZF_RESALE_LINES_INT_ALL#

[top of page]

Table: OZF_RESALE_LOGS_ALL

Description: Log table for resale interface table
Primary Key: OZF_RESALE_LOGS_ALL_PK
  1. RESALE_LOG_ID

[top of page]

OZF.OZF_RESALE_LOGS_ALL does not reference any database object

OZF.OZF_RESALE_LOGS_ALL is referenced by following:

OZF
VIEW - OZF_RESALE_LOGS_ALL#

[top of page]

Table: OZF_RES_CUST_PROD

Description: Table to store the Customer and Products for a user to show on Account Manager dashboard

[top of page]

OZF.OZF_RES_CUST_PROD does not reference any database object

OZF.OZF_RES_CUST_PROD is referenced by following:

OZF
VIEW - OZF_RES_CUST_PROD#

[top of page]

Table: OZF_RES_CUST_PROD_FACTS

Description: Table to store the information that needs to be displayed on Account Manager Dashboard for a user
Primary Key: OZF_RES_CUST_PROD_FACTS_PK
  1. RES_CUST_PROD_FACTS_ID

[top of page]

OZF.OZF_RES_CUST_PROD_FACTS does not reference any database object

OZF.OZF_RES_CUST_PROD_FACTS is referenced by following:

OZF
VIEW - OZF_RES_CUST_PROD_FACTS#

[top of page]

Table: OZF_RETAIL_PRICE_POINTS

Description: Table to store the retail price information
Primary Key: OZF_RETAIL_PRICE_POINTS_PK
  1. RETAIL_PRICE_POINT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_RETAIL_PRICE_POINTS.INVENTORY_ITEM_ID
OZF_RETAIL_PRICE_POINTS.ORGANIZATION_ID 		MTL_SYSTEM_ITEMS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
OZF_COMPETITOR_PRICE_POINTS.RETAIL_PRICE_POINT_ID OZF_RETAIL_PRICE_POINTS

[top of page]

OZF.OZF_RETAIL_PRICE_POINTS does not reference any database object

OZF.OZF_RETAIL_PRICE_POINTS is referenced by following:

OZF
VIEW - OZF_RETAIL_PRICE_POINTS#

[top of page]

Table: OZF_RULE_BASED_LOG

Description: This table stores the Rule Based Claim Data
Primary Key: OZF_RULE_BASED_LOG_PK
  1. LOG_ID

[top of page]

OZF.OZF_RULE_BASED_LOG does not reference any database object

OZF.OZF_RULE_BASED_LOG is referenced by following:

OZF
VIEW - OZF_RULE_BASED_LOG#

[top of page]

Table: OZF_SALES_TRANSACTIONS_ALL

Description: This table stores quantity, uom and rate in different units for all direct and resale orders
Primary Key: OZF_SALES_TRANSACTIONS_ALL_PK
  1. SALES_TRANSACTION_ID

[top of page]

OZF.OZF_SALES_TRANSACTIONS_ALL does not reference any database object

OZF.OZF_SALES_TRANSACTIONS_ALL is referenced by following:

OZF
VIEW - OZF_SALES_TRANSACTIONS_ALL#

[top of page]

Table: OZF_SD_BATCH_HEADERS_ALL

Description: OZF_SD_BATCH_HEADERS_ALL stores the header information of Supplier Ship and Debit Batch in Oracle Trade Management
Primary Key: OZF_SD_BATCH_HEADERS_ALL_PK
  1. BATCH_ID

[top of page]

OZF.OZF_SD_BATCH_HEADERS_ALL does not reference any database object

OZF.OZF_SD_BATCH_HEADERS_ALL is referenced by following:

OZF
VIEW - OZF_SD_BATCH_HEADERS_ALL#

[top of page]

Table: OZF_SD_BATCH_LINES_ALL

Description: OZF_SD_BATCH_LINES_ALL stores the line information of Supplier Ship and Debit Batch in Oracle Trade Management
Primary Key: OZF_SD_BATCH_LINES_ALL_PK
  1. BATCH_LINE_ID

[top of page]

OZF.OZF_SD_BATCH_LINES_ALL does not reference any database object

OZF.OZF_SD_BATCH_LINES_ALL is referenced by following:

OZF
VIEW - OZF_SD_BATCH_LINES_ALL#

[top of page]

Table: OZF_SD_BATCH_LINES_INT_ALL

Description: interface table to receive data from vendor authorization transmission of Supplier Ship and Debit Batch in Oracle Trade Management
Primary Key: OZF_SD_BATCH_LINES_INT_ALL_PK
  1. BATCH_LINE_INT_ID

[top of page]

OZF.OZF_SD_BATCH_LINES_INT_ALL does not reference any database object

OZF.OZF_SD_BATCH_LINES_INT_ALL is referenced by following:

OZF
VIEW - OZF_SD_BATCH_LINES_INT_ALL#

[top of page]

Table: OZF_SD_BATCH_LINE_DISPUTES

Description: store the line dispute information of Supplier Ship and Debit Batch in Oracle Trade Management
Primary Key: OZF_SD_BATCH_LINE_DISPUTES_PK
  1. BATCH_LINE_DISPUTE_ID

[top of page]

OZF.OZF_SD_BATCH_LINE_DISPUTES does not reference any database object

OZF.OZF_SD_BATCH_LINE_DISPUTES is referenced by following:

OZF
VIEW - OZF_SD_BATCH_LINE_DISPUTES#

[top of page]

Table: OZF_SD_CUSTOMER_DETAILS

Description: stores ship and debit customer information
Primary Key: OZF_SD_CUSTOMER_DETAILS_PK
  1. REQUEST_CUSTOMER_ID

[top of page]

OZF.OZF_SD_CUSTOMER_DETAILS does not reference any database object

OZF.OZF_SD_CUSTOMER_DETAILS is referenced by following:

OZF
VIEW - OZF_SD_CUSTOMER_DETAILS#

[top of page]

Table: OZF_SD_REQUEST_ACCESS

Description: OZF_SD_REQUEST_ACCESS stores the information of Approver/Owner for a Ship & Debit request.
Primary Key: OZF_SD_REQUEST_ACCESS_PK
  1. REQUEST_ACCESS_ID

[top of page]

OZF.OZF_SD_REQUEST_ACCESS does not reference any database object

OZF.OZF_SD_REQUEST_ACCESS is referenced by following:

OZF
VIEW - OZF_SD_REQUEST_ACCESS#

[top of page]

Table: OZF_SD_REQUEST_HEADERS_ALL_B

Description: stores the ship and debit request header information
Primary Key: OZF_SD_REQUEST_HDRS_ALL_B_PK
  1. REQUEST_HEADER_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
OZF_SD_REQUEST_HEADERS_ALL_TL.REQUEST_HEADER_ID OZF_SD_REQUEST_HEADERS_ALL_B

[top of page]

OZF.OZF_SD_REQUEST_HEADERS_ALL_B does not reference any database object

OZF.OZF_SD_REQUEST_HEADERS_ALL_B is referenced by following:

OZF
VIEW - OZF_SD_REQUEST_HEADERS_ALL_B#

[top of page]

Table: OZF_SD_REQUEST_HEADERS_ALL_TL

Description: Translations for ozf_sd_request_headers_all_b
Primary Key: OZF_SD_REQUEST_HDRS_ALL_TL_PK
  1. LANGUAGE
  2. REQUEST_HEADER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_SD_REQUEST_HEADERS_ALL_TL.REQUEST_HEADER_ID OZF_SD_REQUEST_HEADERS_ALL_B

[top of page]

OZF.OZF_SD_REQUEST_HEADERS_ALL_TL does not reference any database object

OZF.OZF_SD_REQUEST_HEADERS_ALL_TL is referenced by following:

OZF
VIEW - OZF_SD_REQUEST_HEADERS_ALL_TL#

[top of page]

Table: OZF_SD_REQUEST_LINES_ALL

Description: stores the ship and debit request line information
Primary Key: OZF_SD_REQUEST_LINES_ALL_PK
  1. REQUEST_LINE_ID

[top of page]

OZF.OZF_SD_REQUEST_LINES_ALL does not reference any database object

OZF.OZF_SD_REQUEST_LINES_ALL is referenced by following:

OZF
VIEW - OZF_SD_REQUEST_LINES_ALL#

[top of page]

Table: OZF_SD_RES_CUST_INTF

Description: To hold the customer details sent as part of response
Primary Key: OZF_SD_RES_CUST_INTF_PK
  1. RES_CUST_INTF_ID

[top of page]

OZF.OZF_SD_RES_CUST_INTF does not reference any database object

OZF.OZF_SD_RES_CUST_INTF is referenced by following:

OZF
VIEW - OZF_SD_RES_CUST_INTF#

[top of page]

Table: OZF_SD_RES_DIST_PRICES_INTF

Description: To hold the pricing information for each product
Primary Key: OZF_SD_RES_DIST_PRICES_INTF_PK
  1. RES_DIST_PRICES_INTF_ID

[top of page]

OZF.OZF_SD_RES_DIST_PRICES_INTF does not reference any database object

OZF.OZF_SD_RES_DIST_PRICES_INTF is referenced by following:

OZF
VIEW - OZF_SD_RES_DIST_PRICES_INTF#

[top of page]

Table: OZF_SD_RES_HEADER_INTF

Description: To hold Vendor and distributor details sent as part of response
Primary Key: OZF_SD_RES_HEADER_INTF_PK
  1. RES_HEADER_INTF_ID

[top of page]

OZF.OZF_SD_RES_HEADER_INTF does not reference any database object

OZF.OZF_SD_RES_HEADER_INTF is referenced by following:

OZF
VIEW - OZF_SD_RES_HEADER_INTF#

[top of page]

Table: OZF_SD_RES_PROD_INTF

Description: To hold the product line detail for a request
Primary Key: OZF_SD_RES_PROD_INTF_PK
  1. RES_PROD_INTF_ID

[top of page]

OZF.OZF_SD_RES_PROD_INTF does not reference any database object

OZF.OZF_SD_RES_PROD_INTF is referenced by following:

OZF
VIEW - OZF_SD_RES_PROD_INTF#

[top of page]

Table: OZF_SD_STATUS_TRANSITIONS

Description: OZF_SD_STATUS_TRANSITIONS stores the status transition information for a Ship & Debit request.

[top of page]

OZF.OZF_SD_STATUS_TRANSITIONS does not reference any database object

OZF.OZF_SD_STATUS_TRANSITIONS is referenced by following:

OZF
VIEW - OZF_SD_STATUS_TRANSITIONS#

[top of page]

Table: OZF_SETTLEMENT_DOCS_ALL

Description: This table stores the settlement details
Primary Key: OZF_SETTLEMENT_DOCS_PK
  1. SETTLEMENT_DOC_ID

[top of page]

OZF.OZF_SETTLEMENT_DOCS_ALL does not reference any database object

OZF.OZF_SETTLEMENT_DOCS_ALL is referenced by following:

OZF
VIEW - OZF_SETTLEMENT_DOCS_ALL#

[top of page]

Table: OZF_SUPP_CODE_CONVERSIONS_ALL

Description: OZF_SUPP_CODE_CONVERSIONS_ALL stores the code mapping between the supplier item code and internal item codes.

[top of page]

OZF.OZF_SUPP_CODE_CONVERSIONS_ALL does not reference any database object

OZF.OZF_SUPP_CODE_CONVERSIONS_ALL is referenced by following:

OZF
VIEW - OZF_SUPP_CODE_CONVERSIONS_ALL#

[top of page]

Table: OZF_SUPP_TRD_PRFLS_ALL

Description: OZF_SUPP_TRD_PRFLS_ALL stores the supplier trade profiles created from the Supplier trade profile UI.

[top of page]

OZF.OZF_SUPP_TRD_PRFLS_ALL does not reference any database object

OZF.OZF_SUPP_TRD_PRFLS_ALL is referenced by following:

OZF
VIEW - OZF_SUPP_TRD_PRFLS_ALL#

[top of page]

Table: OZF_SYS_PARAMETERS_ALL

Description: This table stores the system parameters for General Ledger interface
Primary Key: OZF_SYS_PARAMETERS_ALL_PK
  1. SET_OF_BOOKS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_SYS_PARAMETERS_ALL.CLAIM_TYPE_ID OZF_CLAIM_TYPES_ALL_B
OZF_SYS_PARAMETERS_ALL.AUTOPAY_CLAIM_TYPE_ID OZF_CLAIM_TYPES_ALL_B
OZF_SYS_PARAMETERS_ALL.AUTOPAY_REASON_CODE_ID OZF_REASON_CODES_ALL_B
OZF_SYS_PARAMETERS_ALL.REASON_CODE_ID OZF_REASON_CODES_ALL_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
OZF_CLAIMS_ALL.SET_OF_BOOKS_ID OZF_SYS_PARAMETERS_ALL

[top of page]

OZF.OZF_SYS_PARAMETERS_ALL does not reference any database object

OZF.OZF_SYS_PARAMETERS_ALL is referenced by following:

OZF
VIEW - OZF_SYS_PARAMETERS_ALL#
- OZF_SYS_PARAMETERS_ALL#

[top of page]

Table: OZF_TERR_LEVELS_ALL

Description: This table stores the levels that corrospond to territory types in JTF.
Primary Key: AMS_TERR_LEVELS_ALL_PK
  1. TERR_LEVEL_ID
Primary Key: OZF_TERR_LEVELS_ALL_PK
  1. TERR_LEVEL_ID

[top of page]

OZF.OZF_TERR_LEVELS_ALL does not reference any database object

OZF.OZF_TERR_LEVELS_ALL is referenced by following:

OZF
VIEW - OZF_TERR_LEVELS_ALL#

[top of page]

Table: OZF_THRESHOLDS_ALL_B

Description: Holds information on Funds Thresholds.
Primary Key: OZF_THRESHOLDS_ALL_B_PK
  1. THRESHOLD_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
OZF_FUNDS_ALL_B.THRESHOLD_ID OZF_THRESHOLDS_ALL_B
OZF_FUNDS_ALL_B.THRESHOLD_ID OZF_THRESHOLDS_ALL_B
OZF_THRESHOLDS_ALL_TL.THRESHOLD_ID OZF_THRESHOLDS_ALL_B
OZF_THRESHOLD_RULES_ALL.THRESHOLD_ID OZF_THRESHOLDS_ALL_B
OZF_THRESHOLD_RULES_ALL.THRESHOLD_ID OZF_THRESHOLDS_ALL_B

[top of page]

OZF.OZF_THRESHOLDS_ALL_B does not reference any database object

OZF.OZF_THRESHOLDS_ALL_B is referenced by following:

OZF
VIEW - OZF_THRESHOLDS_ALL_B#

[top of page]

Table: OZF_THRESHOLDS_ALL_TL

Description: Holds information on Funds Thresholds.(Translation table)
Primary Key: OZF_THRESHOLDS_ALL_TL_PK
  1. LANGUAGE
  2. THRESHOLD_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_THRESHOLDS_ALL_TL.THRESHOLD_ID OZF_THRESHOLDS_ALL_B

[top of page]

OZF.OZF_THRESHOLDS_ALL_TL does not reference any database object

OZF.OZF_THRESHOLDS_ALL_TL is referenced by following:

OZF
VIEW - OZF_THRESHOLDS_ALL_TL#

[top of page]

Table: OZF_THRESHOLD_RULES_ALL

Description: Holds Funds Threshold Rule Information.
Primary Key: OZF_THRESHOLD_RULES_ALL_PK
  1. THRESHOLD_RULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_THRESHOLD_RULES_ALL.THRESHOLD_ID OZF_THRESHOLDS_ALL_B
OZF_THRESHOLD_RULES_ALL.THRESHOLD_ID OZF_THRESHOLDS_ALL_B

[top of page]

OZF.OZF_THRESHOLD_RULES_ALL does not reference any database object

OZF.OZF_THRESHOLD_RULES_ALL is referenced by following:

OZF
VIEW - OZF_THRESHOLD_RULES_ALL#

[top of page]

Table: OZF_TIME_ALLOCATIONS

Description: Table to store the time level allocations
Primary Key: OZF_TIME_ALLOCATIONS_PK
  1. TIME_ALLOCATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_TIME_ALLOCATIONS.ALLOCATION_FOR_ID OZF_ACCOUNT_ALLOCATIONS
OZF_TIME_ALLOCATIONS.ALLOCATION_FOR_ID OZF_PRODUCT_ALLOCATIONS

[top of page]

OZF.OZF_TIME_ALLOCATIONS does not reference any database object

OZF.OZF_TIME_ALLOCATIONS is referenced by following:

OZF
VIEW - OZF_TIME_ALLOCATIONS#

[top of page]

Table: OZF_TIME_DAY

Description: This is a time structure table storing day information.

[top of page]

OZF.OZF_TIME_DAY does not reference any database object

OZF.OZF_TIME_DAY is referenced by following:

APPS
MATERIALIZED VIEW - OZF_CUST_FUND_SUMMARY_MV
MATERIALIZED VIEW - OZF_EARNING_SUMMARY_MV
OZF
VIEW - OZF_TIME_DAY#

[top of page]

Table: OZF_TIME_ENT_PERIOD

Description: This is a time structure table storing enterprise period names.

[top of page]

OZF.OZF_TIME_ENT_PERIOD does not reference any database object

OZF.OZF_TIME_ENT_PERIOD is referenced by following:

OZF
VIEW - OZF_TIME_ENT_PERIOD#

[top of page]

Table: OZF_TIME_ENT_QTR

Description: This is a time structure table storing enterprise quarter names.

[top of page]

OZF.OZF_TIME_ENT_QTR does not reference any database object

OZF.OZF_TIME_ENT_QTR is referenced by following:

OZF
VIEW - OZF_TIME_ENT_QTR#

[top of page]

Table: OZF_TIME_ENT_YEAR

Description: This is a time structure table storing enterprise year names.

[top of page]

OZF.OZF_TIME_ENT_YEAR does not reference any database object

OZF.OZF_TIME_ENT_YEAR is referenced by following:

OZF
VIEW - OZF_TIME_ENT_YEAR#

[top of page]

Table: OZF_TIME_RPT_STRUCT

Description: This is a time structure table used for calculating period amounts and XTD amounts for the given period range. It stores time structure data to resolve given period range.

[top of page]

OZF.OZF_TIME_RPT_STRUCT does not reference any database object

OZF.OZF_TIME_RPT_STRUCT is referenced by following:

OZF
VIEW - OZF_TIME_RPT_STRUCT#

[top of page]

Table: OZF_TIME_WEEK

Description: This is a time structure table storing the Gregorian week names

[top of page]

OZF.OZF_TIME_WEEK does not reference any database object

OZF.OZF_TIME_WEEK is referenced by following:

OZF
VIEW - OZF_TIME_WEEK#

[top of page]

Table: OZF_TP_TERRUSG_MAP

Description: Table to store the territory and store mappings
Primary Key: OZF_TP_TERRUSG_PK
  1. OZF_TP_TERRUSG_MAP_ID

[top of page]

OZF.OZF_TP_TERRUSG_MAP does not reference any database object

OZF.OZF_TP_TERRUSG_MAP is referenced by following:

OZF
VIEW - OZF_TP_TERRUSG_MAP#

[top of page]

Table: OZF_TRADE_TACTICS_MAPPING

Description: This table stores details all distinct trade medium ids and their respective column names. This information is derived from ozf_lift_factor_facts table.
Primary Key: OZF_TRADE_TACTICS_MAPPING_PK
  1. TRADE_TACTICS_MAPPING_ID

[top of page]

OZF.OZF_TRADE_TACTICS_MAPPING does not reference any database object

OZF.OZF_TRADE_TACTICS_MAPPING is referenced by following:

OZF
VIEW - OZF_TRADE_TACTICS_MAPPING#

[top of page]

Table: OZF_VOLUME_DETAIL

Description: This table stores volume transaction detail for volume offers
Primary Key: OZF_VOLUME_DETAIL_PK
  1. VOLUME_DETAIL_ID

[top of page]

OZF.OZF_VOLUME_DETAIL does not reference any database object

OZF.OZF_VOLUME_DETAIL is referenced by following:

OZF
VIEW - OZF_VOLUME_DETAIL#

[top of page]

Table: OZF_VOLUME_OFFER_TIERS

Description: Stores tier info of volume offer
Primary Key: OZF_VOLUME_OFFER_TIERS_PK
  1. VOLUME_OFFER_TIERS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_VOLUME_OFFER_TIERS.QP_LIST_HEADER_ID OZF_OFFERS

[top of page]

OZF.OZF_VOLUME_OFFER_TIERS does not reference any database object

OZF.OZF_VOLUME_OFFER_TIERS is referenced by following:

OZF
VIEW - OZF_VOLUME_OFFER_TIERS#

[top of page]

Table: OZF_VOLUME_SUMMARY

Description: This table stores accumulated volume for volume offers
Primary Key: OZF_VOLUME_SUMMARY_PK
  1. VOLUME_SUMMARY_ID

[top of page]

OZF.OZF_VOLUME_SUMMARY does not reference any database object

OZF.OZF_VOLUME_SUMMARY is referenced by following:

OZF
VIEW - OZF_VOLUME_SUMMARY#

[top of page]

Table: OZF_VO_PRODUCTS_TEMP

Description: This table stores denorm product id temporarily during volume offer activation
Primary Key: OZF_VO_PRODUCTS_TEMP_PK
  1. VO_PRODUCTS_TEMP_ID

[top of page]

OZF.OZF_VO_PRODUCTS_TEMP does not reference any database object

OZF.OZF_VO_PRODUCTS_TEMP is referenced by following:

OZF
VIEW - OZF_VO_PRODUCTS_TEMP#

[top of page]

Table: OZF_WORKSHEET_HEADERS_B

Description: Table to store the Worksheet header information
Primary Key: OZF_WORKSHEET_HEADERS_PK
  1. WORKSHEET_HEADER_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
OZF_ACT_FORECASTS_ALL.ACT_FCAST_USED_BY_ID OZF_WORKSHEET_HEADERS_B
OZF_FORECAST_CUSTOMERS.OBJ_ID OZF_WORKSHEET_HEADERS_B
OZF_FORECAST_DIMENTIONS.OBJ_ID OZF_WORKSHEET_HEADERS_B
OZF_FORECAST_PERIODS.OBJ_ID OZF_WORKSHEET_HEADERS_B
OZF_FORECAST_PRODUCTS.OBJ_ID OZF_WORKSHEET_HEADERS_B
OZF_OFFER_PERFORMANCES.USED_BY_ID OZF_WORKSHEET_HEADERS_B
OZF_WORKSHEET_HEADERS_TL.WORKSHEET_HEADER_ID OZF_WORKSHEET_HEADERS_B
OZF_WORKSHEET_LINES.WORKSHEET_HEADER_ID OZF_WORKSHEET_HEADERS_B
OZF_WORKSHEET_LINES.WORKSHEET_HEADER_ID OZF_WORKSHEET_HEADERS_B
OZF_WORKSHEET_QUALIFIERS.WORKSHEET_HEADER_ID OZF_WORKSHEET_HEADERS_B

[top of page]

OZF.OZF_WORKSHEET_HEADERS_B does not reference any database object

OZF.OZF_WORKSHEET_HEADERS_B is referenced by following:

OZF
VIEW - OZF_WORKSHEET_HEADERS_B#

[top of page]

Table: OZF_WORKSHEET_HEADERS_TL

Description: Table to store the translated values for Workhsheet Header
Primary Key: OZF_WORKSHEET_HEADERS_TL_PK
  1. WORKSHEET_HEADER_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_WORKSHEET_HEADERS_TL.WORKSHEET_HEADER_ID OZF_WORKSHEET_HEADERS_B

[top of page]

OZF.OZF_WORKSHEET_HEADERS_TL does not reference any database object

OZF.OZF_WORKSHEET_HEADERS_TL is referenced by following:

OZF
VIEW - OZF_WORKSHEET_HEADERS_TL#

[top of page]

Table: OZF_WORKSHEET_LINES

Description: Table to store the Worksheet Discount lines
Primary Key: OZF_WORKSHEET_LINES_PK
  1. WORKSHEET_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_WORKSHEET_LINES.WORKSHEET_HEADER_ID OZF_WORKSHEET_HEADERS_B
OZF_WORKSHEET_LINES.WORKSHEET_HEADER_ID OZF_WORKSHEET_HEADERS_B

[top of page]

OZF.OZF_WORKSHEET_LINES does not reference any database object

OZF.OZF_WORKSHEET_LINES is referenced by following:

OZF
VIEW - OZF_WORKSHEET_LINES#

[top of page]

Table: OZF_WORKSHEET_QUALIFIERS

Description: Table to store the Market eligibilty for a Offer Worksheet
Primary Key: OZF_WORKSHEET_QUALIFIERS_PK
  1. WORKSHEET_QUALIFIER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
OZF_WORKSHEET_QUALIFIERS.WORKSHEET_HEADER_ID OZF_WORKSHEET_HEADERS_B

[top of page]

OZF.OZF_WORKSHEET_QUALIFIERS does not reference any database object

OZF.OZF_WORKSHEET_QUALIFIERS is referenced by following:

OZF
VIEW - OZF_WORKSHEET_QUALIFIERS#

[top of page]

Table: OZF_XLA_ACCRUALS

Description: This table stores SLA Accrual extract information
Primary Key: XLA_ACCRUAL_ID_U1
  1. XLA_ACCRUAL_ID

[top of page]

OZF.OZF_XLA_ACCRUALS does not reference any database object

OZF.OZF_XLA_ACCRUALS is referenced by following:

OZF
VIEW - OZF_XLA_ACCRUALS#

[top of page]

Table: OZF_XLA_ACCRUALS_BACKUP

Description:

[top of page]

OZF.OZF_XLA_ACCRUALS_BACKUP does not reference any database object

OZF.OZF_XLA_ACCRUALS_BACKUP is referenced by following:

OZF
VIEW - OZF_XLA_ACCRUALS_BACKUP#

[top of page]

Table: OZF_XLA_CLAIM_HEADERS

Description: This table stores the SLA Claim Extract Header Data
Primary Key: XLA_CLAIM_HEADER_ID_U1
  1. XLA_CLAIM_HEADER_ID

[top of page]

OZF.OZF_XLA_CLAIM_HEADERS does not reference any database object

OZF.OZF_XLA_CLAIM_HEADERS is referenced by following:

OZF
VIEW - OZF_XLA_CLAIM_HEADERS#

[top of page]

Table: OZF_XLA_CLAIM_HEADERS_BACKUP

Description:

[top of page]

OZF.OZF_XLA_CLAIM_HEADERS_BACKUP does not reference any database object

OZF.OZF_XLA_CLAIM_HEADERS_BACKUP is referenced by following:

OZF
VIEW - OZF_XLA_CLAIM_HEADERS_BACKUP#

[top of page]

Table: OZF_XLA_CLAIM_LINES

Description: This table stores the SLA Claim Extract Lines Data

[top of page]

OZF.OZF_XLA_CLAIM_LINES does not reference any database object

OZF.OZF_XLA_CLAIM_LINES is referenced by following:

OZF
VIEW - OZF_XLA_CLAIM_LINES#

[top of page]

Table: OZF_XLA_CLAIM_LINES_BACKUP

Description:

[top of page]

OZF.OZF_XLA_CLAIM_LINES_BACKUP does not reference any database object

OZF.OZF_XLA_CLAIM_LINES_BACKUP is referenced by following:

OZF
VIEW - OZF_XLA_CLAIM_LINES_BACKUP#

[top of page]

Table: OZF_XREF_MAP

Description: OZF_XREF_MAP table created for SIebel TPM Integration

[top of page]

OZF.OZF_XREF_MAP does not reference any database object

OZF.OZF_XREF_MAP is referenced by following:

OZF
VIEW - OZF_XREF_MAP#

[top of page]

View: OZF_BATCHES

[top of page]

APPS.OZF_BATCHES references the following:

APPS
SYNONYM - OZF_BATCHES_ALL

APPS.OZF_BATCHES is not referenced by any database object

[top of page]

View: OZF_CLAIMS_HISTORY_V

[top of page]

APPS.OZF_CLAIMS_HISTORY_V references the following:

APPS
VIEW - AMS_USER_STATUSES_VL
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_PARTIES
SYNONYM - OZF_CLAIMS_HISTORY
VIEW - OZF_CLAIM_TYPES_VL
VIEW - OZF_LOOKUPS
SYNONYM - OZF_SYS_PARAMETERS

APPS.OZF_CLAIMS_HISTORY_V is not referenced by any database object

[top of page]

View: OZF_CLAIMS_V

[top of page]

APPS.OZF_CLAIMS_V references the following:

APPS
VIEW - AMS_USER_STATUSES_VL
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_PARTIES
SYNONYM - OZF_CLAIMS
VIEW - OZF_CLAIM_TYPES_VL
VIEW - OZF_LOOKUPS
SYNONYM - OZF_SYS_PARAMETERS

APPS.OZF_CLAIMS_V is not referenced by any database object

[top of page]

View: OZF_CLAIM_LINES_HIST_V

[top of page]

APPS.OZF_CLAIM_LINES_HIST_V references the following:

APPS
SYNONYM - JTF_RS_RESOURCE_EXTNS
SYNONYM - OZF_CLAIM_LINES_HIST
VIEW - OZF_LOOKUPS
SYNONYM - OZF_SYS_PARAMETERS

APPS.OZF_CLAIM_LINES_HIST_V is not referenced by any database object

[top of page]

View: OZF_CLAIM_LINES_V

[top of page]

APPS.OZF_CLAIM_LINES_V references the following:

APPS
SYNONYM - JTF_RS_RESOURCE_EXTNS
SYNONYM - OZF_CLAIM_LINES
VIEW - OZF_LOOKUPS
SYNONYM - OZF_SYS_PARAMETERS

APPS.OZF_CLAIM_LINES_V is not referenced by any database object

[top of page]

View: OZF_CLAIM_TYPES_ALL_VL

[top of page]

APPS.OZF_CLAIM_TYPES_ALL_VL references the following:

APPS
SYNONYM - OZF_CLAIM_TYPES_ALL_B
SYNONYM - OZF_CLAIM_TYPES_ALL_TL
APPS.OZF_CLAIM_TYPES_ALL_VL is referenced by following:

APPS
VIEW - OZF_AEL_GL_CLA_V
VIEW - OZF_AEL_SL_CLA_V
VIEW - OZF_FUNDS_PAID_V
VIEW - OZF_REQ_CLAIMS_V

[top of page]

View: OZF_CLAIM_TYPES_VL

[top of page]

APPS.OZF_CLAIM_TYPES_VL references the following:

APPS
SYNONYM - OZF_CLAIM_TYPES
SYNONYM - OZF_CLAIM_TYPES_ALL_TL
APPS.OZF_CLAIM_TYPES_VL is referenced by following:

APPS
VIEW - OZF_CLAIMS_HISTORY_V
VIEW - OZF_CLAIMS_V
VIEW - OZF_CLAIM_SUMMARY_V
VIEW - OZF_XLA_CLAIM_V

[top of page]

View: OZF_CUST_PROD_CONT

[top of page]

APPS.OZF_CUST_PROD_CONT references the following:

APPS
SYNONYM - OZF_CUST_PROD_CONT_ALL

APPS.OZF_CUST_PROD_CONT is not referenced by any database object

[top of page]

View: OZF_CUST_TRD_PRFLS_V

[top of page]

APPS.OZF_CUST_TRD_PRFLS_V references the following:

APPS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_SITE_USES
SYNONYM - HZ_PARTIES
SYNONYM - OZF_CUST_TRD_PRFLS
VIEW - PO_VENDORS

APPS.OZF_CUST_TRD_PRFLS_V is not referenced by any database object

[top of page]

View: OZF_FUNDS

[top of page]

APPS.OZF_FUNDS references the following:

APPS
SYNONYM - OZF_FUNDS_ALL_B

APPS.OZF_FUNDS is not referenced by any database object

[top of page]

View: OZF_FUNDS_ALL_VL

[top of page]

APPS.OZF_FUNDS_ALL_VL references the following:

APPS
SYNONYM - OZF_FUNDS_ALL_B
SYNONYM - OZF_FUNDS_ALL_TL
APPS.OZF_FUNDS_ALL_VL is referenced by following:

APPS
VIEW - OZF_AEL_GL_UTL_V
VIEW - OZF_AEL_SL_UTL_V
VIEW - OZF_FUNDS_CUST_V
VIEW - OZF_QUOTA_CLOB_V
VIEW - OZF_TARGET_CLOB_V
VIEW - OZF_XLA_ACC_HEADER_V

[top of page]

View: OZF_FUNDS_PAID

[top of page]

APPS.OZF_FUNDS_PAID references the following:

APPS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - OZF_CLAIMS
SYNONYM - OZF_CLAIM_LINES
SYNONYM - OZF_FUNDS_UTILIZED_ALL_B

APPS.OZF_FUNDS_PAID is not referenced by any database object

[top of page]

View: OZF_FUNDS_PAID_V

[top of page]

APPS.OZF_FUNDS_PAID_V references the following:

APPS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_PARTIES
SYNONYM - OZF_CLAIMS_ALL
SYNONYM - OZF_CLAIM_LINES_ALL
SYNONYM - OZF_CLAIM_LINES_UTIL_ALL
VIEW - OZF_CLAIM_TYPES_ALL_VL
SYNONYM - OZF_FUNDS_UTILIZED_ALL_B

APPS.OZF_FUNDS_PAID_V is not referenced by any database object

[top of page]

View: OZF_FUNDS_UTILIZED_ALL_VL

[top of page]

APPS.OZF_FUNDS_UTILIZED_ALL_VL references the following:

APPS
SYNONYM - OZF_FUNDS_UTILIZED_ALL_B
SYNONYM - OZF_FUNDS_UTILIZED_ALL_TL
APPS.OZF_FUNDS_UTILIZED_ALL_VL is referenced by following:

APPS
VIEW - OZF_AEL_GL_UTL_V
VIEW - OZF_AEL_SL_UTL_V
VIEW - OZF_CLAIM_REQ_HEADER_V
VIEW - OZF_OBJECT_CHECKBOOK_V

[top of page]

View: OZF_FUNDS_UTILIZED_VL

[top of page]

APPS.OZF_FUNDS_UTILIZED_VL references the following:

APPS
SYNONYM - OZF_FUNDS_UTILIZED
SYNONYM - OZF_FUNDS_UTILIZED_ALL_TL

APPS.OZF_FUNDS_UTILIZED_VL is not referenced by any database object

[top of page]

View: OZF_FUNDS_VL

[top of page]

APPS.OZF_FUNDS_VL references the following:

APPS
SYNONYM - OZF_FUNDS_ALL_B
SYNONYM - OZF_FUNDS_ALL_TL

APPS.OZF_FUNDS_VL is not referenced by any database object

[top of page]

View: OZF_FUND_ALLOCATIONS_V

[top of page]

APPS.OZF_FUND_ALLOCATIONS_V references the following:

APPS
SYNONYM - AMS_ACT_METRICS_ALL
- OZF_FUND_DETAILS_V

APPS.OZF_FUND_ALLOCATIONS_V is not referenced by any database object

[top of page]

View: OZF_FUND_ALLOCTREE_V

[top of page]

APPS.OZF_FUND_ALLOCTREE_V references the following:

APPS
SYNONYM - AMS_ACT_METRICS_ALL
SYNONYM - AMS_ACT_METRIC_FACTS_ALL
SYNONYM - AMS_ACT_METRIC_FORMULAS
VIEW - AMS_TERR_V

APPS.OZF_FUND_ALLOCTREE_V is not referenced by any database object

[top of page]

View: OZF_FUND_CHECKBOOK_V

[top of page]

APPS.OZF_FUND_CHECKBOOK_V references the following:

APPS
VIEW - AMS_CAMPAIGNS_VL
VIEW - AMS_CAMPAIGN_SCHEDULES_VL
VIEW - AMS_DELIVERABLES_VL
VIEW - AMS_EVENT_HEADERS_VL
VIEW - AMS_EVENT_OFFERS_VL
SYNONYM - OZF_ACT_BUDGETS
SYNONYM - OZF_ACT_OFFERS
SYNONYM - OZF_FUNDS_ALL_B
PACKAGE - OZF_FUND_ADJUSTMENT_PVT
SYNONYM - OZF_OFFERS
- QP_LIST_HEADERS_VL

APPS.OZF_FUND_CHECKBOOK_V is not referenced by any database object

[top of page]

View: OZF_FUND_DETAILS_V

[top of page]

APPS.OZF_FUND_DETAILS_V references the following:

APPS
VIEW - AMS_CATEGORIES_VL
VIEW - AMS_JTF_RS_EMP_V
VIEW - AMS_USER_STATUSES_VL
- OZF_FUNDS_ALL_VL
APPS.OZF_FUND_DETAILS_V is referenced by following:

APPS
VIEW - OZF_FUND_REQUESTS_V

[top of page]

View: OZF_FUND_REQUESTS_V

[top of page]

APPS.OZF_FUND_REQUESTS_V references the following:

APPS
VIEW - OZF_FUND_DETAILS_V
SYNONYM - OZF_FUND_REQUESTS

APPS.OZF_FUND_REQUESTS_V is not referenced by any database object

[top of page]

View: OZF_JE_CATEGORIES_V

[top of page]

APPS.OZF_JE_CATEGORIES_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
- GL_JE_CATEGORIES

APPS.OZF_JE_CATEGORIES_V is not referenced by any database object

[top of page]

View: OZF_LOOKUPS

[top of page]

APPS.OZF_LOOKUPS references the following:

APPS
SYNONYM - FND_LOOKUP_VALUES
APPS.OZF_LOOKUPS is referenced by following:

APPS
VIEW - OZF_AEL_GL_CLA_V
VIEW - OZF_AEL_GL_UTL_V
VIEW - OZF_AEL_SL_CLA_V
VIEW - OZF_AEL_SL_UTL_V
VIEW - OZF_CLAIMS_HISTORY_V
VIEW - OZF_CLAIMS_V
VIEW - OZF_CLAIM_LINES_HIST_V
VIEW - OZF_CLAIM_LINES_V
VIEW - OZF_CLAIM_REQ_HEADER_V
VIEW - OZF_CLAIM_SUMMARY_V
VIEW - OZF_REQ_CLAIMS_V
VIEW - OZF_RESALE_BATCHES_V
VIEW - OZF_RESALE_HEADERS_V
VIEW - OZF_RESALE_LINES_V
VIEW - OZF_RESALE_WEBADI_DOWNLOAD_V

[top of page]

View: OZF_LOOKUP_TYPES

[top of page]

APPS.OZF_LOOKUP_TYPES references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - FND_LOOKUP_TYPES
VIEW - FND_LOOKUP_TYPES_VL

APPS.OZF_LOOKUP_TYPES is not referenced by any database object

[top of page]

View: OZF_MC_TRANSACTIONS

[top of page]

APPS.OZF_MC_TRANSACTIONS references the following:

APPS
SYNONYM - OZF_MC_TRANSACTIONS_ALL

APPS.OZF_MC_TRANSACTIONS is not referenced by any database object

[top of page]

View: OZF_REASON_CODES_ALL_VL

[top of page]

APPS.OZF_REASON_CODES_ALL_VL references the following:

APPS
SYNONYM - OZF_REASON_CODES_ALL_B
SYNONYM - OZF_REASON_CODES_ALL_TL
APPS.OZF_REASON_CODES_ALL_VL is referenced by following:

APPS
VIEW - OZF_AEL_GL_CLA_V
VIEW - OZF_AEL_SL_CLA_V
VIEW - OZF_REQ_CLAIMS_V

[top of page]

View: OZF_REASON_CODES_VL

[top of page]

APPS.OZF_REASON_CODES_VL references the following:

APPS
SYNONYM - OZF_REASON_CODES
SYNONYM - OZF_REASON_CODES_ALL_TL
APPS.OZF_REASON_CODES_VL is referenced by following:

APPS
VIEW - OZF_CLAIM_SUMMARY_V
VIEW - OZF_XLA_CLAIM_V

[top of page]

View: OZF_THRESHOLDS

[top of page]

APPS.OZF_THRESHOLDS references the following:

APPS
SYNONYM - OZF_THRESHOLDS_ALL_B

APPS.OZF_THRESHOLDS is not referenced by any database object

[top of page]

View: OZF_THRESHOLDS_ALL_VL

[top of page]

APPS.OZF_THRESHOLDS_ALL_VL references the following:

APPS
SYNONYM - OZF_THRESHOLDS_ALL_B
SYNONYM - OZF_THRESHOLDS_ALL_TL

APPS.OZF_THRESHOLDS_ALL_VL is not referenced by any database object

[top of page]

View: OZF_THRESHOLDS_VL

[top of page]

APPS.OZF_THRESHOLDS_VL references the following:

APPS
SYNONYM - OZF_THRESHOLDS_ALL_B
SYNONYM - OZF_THRESHOLDS_ALL_TL

APPS.OZF_THRESHOLDS_VL is not referenced by any database object

[top of page]

View: OZF_THRESHOLD_RULES

[top of page]

APPS.OZF_THRESHOLD_RULES references the following:

APPS
SYNONYM - OZF_THRESHOLD_RULES_ALL

APPS.OZF_THRESHOLD_RULES is not referenced by any database object

[top of page]

View: OZF_X_AGING_BUCKETS

[top of page]

APPS.OZF_X_AGING_BUCKETS references the following:

APPS
SYNONYM - AR_AGING_BUCKETS

APPS.OZF_X_AGING_BUCKETS is not referenced by any database object

[top of page]

View: OZF_X_AGING_BUCKET_LNS

[top of page]

APPS.OZF_X_AGING_BUCKET_LNS references the following:

APPS
SYNONYM - AR_AGING_BUCKET_LINES_B
SYNONYM - AR_AGING_BUCKET_LINES_TL

APPS.OZF_X_AGING_BUCKET_LNS is not referenced by any database object

[top of page]

View: OZF_X_CUST_SITE_USES

[top of page]

APPS.OZF_X_CUST_SITE_USES references the following:

APPS
SYNONYM - HZ_CUST_ACCT_SITES
SYNONYM - HZ_CUST_SITE_USES
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTY_SITES

APPS.OZF_X_CUST_SITE_USES is not referenced by any database object

[top of page]

View: OZF_X_GET_TRX_TYPES

[top of page]

APPS.OZF_X_GET_TRX_TYPES references the following:

APPS
SYNONYM - RA_CUST_TRX_TYPES_ALL

APPS.OZF_X_GET_TRX_TYPES is not referenced by any database object

[top of page]

View: OZF_X_INVOICES_V

[top of page]

APPS.OZF_X_INVOICES_V references the following:

APPS
SYNONYM - AR_PAYMENT_SCHEDULES_ALL

APPS.OZF_X_INVOICES_V is not referenced by any database object

[top of page]

View: OZF_X_INVOICE_LINE_V

[top of page]

APPS.OZF_X_INVOICE_LINE_V references the following:

APPS
SYNONYM - RA_CUSTOMER_TRX_ALL
SYNONYM - RA_CUSTOMER_TRX_LINES_ALL

APPS.OZF_X_INVOICE_LINE_V is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract