This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.
The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend
This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.
Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.
| Description: | Contains employee and partner access records for customers, sales leads and opportunities |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_ACCESSES_ALL_ALL.LEAD_ID | AS_LEADS_ALL |
| AS_ACCESSES_ALL_ALL.SALES_LEAD_ID | AS_SALES_LEADS |
| AS_ACCESSES_ALL_ALL.SALES_GROUP_ID | JTF_RS_GROUPS_B |
| AS_ACCESSES_ALL_ALL.CUSTOMER_ID | HZ_PARTIES |
| AS_ACCESSES_ALL_ALL.ADDRESS_ID | HZ_PARTY_SITES |
| AS_ACCESSES_ALL_ALL.PARTNER_CUSTOMER_ID | HZ_PARTIES |
| AS_ACCESSES_ALL_ALL.PARTNER_ADDRESS_ID | HZ_PARTY_SITES |
| AS_ACCESSES_ALL_ALL.SALES_GROUP_ID | JTF_RS_GROUPS_B |
| AS_ACCESSES_ALL_ALL.SALESFORCE_ID | JTF_RS_RESOURCE_EXTNS |
| AS_ACCESSES_ALL_ALL.LEAD_ID | AS_LEADS_ALL |
| AS_ACCESSES_ALL_ALL.CUSTOMER_ID | RA_CUSTOMERS |
| AS_ACCESSES_ALL_ALL.ADDRESS_ID | RA_ADDRESSES_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| AS_TERRITORY_ACCESSES.ACCESS_ID | AS_ACCESSES_ALL_ALL |
| PV_ACCESS_MIGRATION_LOG.ACCESS_ID | AS_ACCESSES_ALL_ALL |
OSM.AS_ACCESSES_ALL_ALL does not reference any database object
OSM.AS_ACCESSES_ALL_ALL is referenced by following:
| Description: |
|---|
OSM.AS_ACCESSES_PURGE_TEMP does not reference any database object
OSM.AS_ACCESSES_PURGE_TEMP is referenced by following:
| Description: | Contains changed accounts - obsolete |
|---|
OSM.AS_ACCOUNT_QUAL_VALUES_ALL does not reference any database object
OSM.AS_ACCOUNT_QUAL_VALUES_ALL is referenced by following:
| Description: | This is the header table that will hold account plans for various customers |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_AP_ACCOUNT_PLANS.CUST_PARTY_ID | HZ_PARTIES |
| AS_AP_ACCOUNT_PLANS.CURRENCY_CODE | FND_CURRENCIES |
| Foreign Key Column | Foreign Table |
|---|---|
| AS_AP_BUSINESS_DRIVERS.ACCOUNT_PLAN_ID | AS_AP_ACCOUNT_PLANS |
| AS_AP_STRTGC_OBJECTIVES.ACCOUNT_PLAN_ID | AS_AP_ACCOUNT_PLANS |
| AS_AP_TRACKING_OBJECTIVES.ACCOUNT_PLAN_ID | AS_AP_ACCOUNT_PLANS |
OSM.AS_AP_ACCOUNT_PLANS does not reference any database object
OSM.AS_AP_ACCOUNT_PLANS is referenced by following:
| Description: | This table will hold all the business drivers for each of the account plans |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_AP_BUSINESS_DRIVERS.ACCOUNT_PLAN_ID | AS_AP_ACCOUNT_PLANS |
OSM.AS_AP_BUSINESS_DRIVERS does not reference any database object
OSM.AS_AP_BUSINESS_DRIVERS is referenced by following:
| Description: | This table will hold all the strategic objectives for each of the account plans |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_AP_STRTGC_OBJECTIVES.ACCOUNT_PLAN_ID | AS_AP_ACCOUNT_PLANS |
| AS_AP_STRTGC_OBJECTIVES.OWNER_SALESFORCE_ID | JTF_RS_RESOURCE_EXTNS |
OSM.AS_AP_STRTGC_OBJECTIVES does not reference any database object
OSM.AS_AP_STRTGC_OBJECTIVES is referenced by following:
| Description: | This table will hold all the revenue objectives for each of the account plans |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_AP_TRACKING_OBJECTIVES.ACCOUNT_PLAN_ID | AS_AP_ACCOUNT_PLANS |
| AS_AP_TRACKING_OBJECTIVES.OWNER_SALESFORCE_ID | JTF_RS_RESOURCE_EXTNS |
| AS_AP_TRACKING_OBJECTIVES.PRODUCT_CAT_SET_ID | MTL_CATEGORY_SETS_B |
| AS_AP_TRACKING_OBJECTIVES.PRODUCT_CATEGORY_ID | MTL_CATEGORIES_B |
|
AS_AP_TRACKING_OBJECTIVES.INVENTORY_ITEM_ID
AS_AP_TRACKING_OBJECTIVES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
OSM.AS_AP_TRACKING_OBJECTIVES does not reference any database object
OSM.AS_AP_TRACKING_OBJECTIVES is referenced by following:
| Description: | Holds the information about various parameters used in the rule. Records can be deleted. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_CARD_RULE_QUAL_VALUES.CARD_RULE_ID | AS_SALES_LEAD_CARD_RULES |
| AS_CARD_RULE_QUAL_VALUES.SEED_QUAL_ID | AS_SALES_LEAD_QUALS_B |
| AS_CARD_RULE_QUAL_VALUES.SCORECARD_ID | AS_SALES_LEAD_SCORECARDS |
OSM.AS_CARD_RULE_QUAL_VALUES does not reference any database object
OSM.AS_CARD_RULE_QUAL_VALUES is referenced by following:
| Description: | Contains collateral categories |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_COLLATERAL_CAT_ALL.CATEGORY_ID | AS_CATEGORIES_ALL |
OSM.AS_CATEGORIES_ALL does not reference any database object
OSM.AS_CATEGORIES_ALL is referenced by following:
| Description: | Contains changed accounts |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_CHANGED_ACCOUNTS_ALL.LEAD_ID | AS_LEADS_ALL |
| AS_CHANGED_ACCOUNTS_ALL.CUSTOMER_ID | HZ_PARTIES |
| AS_CHANGED_ACCOUNTS_ALL.ADDRESS_ID | HZ_PARTY_SITES |
| AS_CHANGED_ACCOUNTS_ALL.SALES_LEAD_ID | AS_SALES_LEADS |
OSM.AS_CHANGED_ACCOUNTS_ALL does not reference any database object
OSM.AS_CHANGED_ACCOUNTS_ALL is referenced by following:
| Description: | Contains changed territories |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_CHANGED_TERRITORIES_ALL.TERRITORY_ID | AS_TERRITORIES_ALL |
| AS_CHANGED_TERRITORIES_ALL.TRANSFER_TO_SALESFORCE_ID | AS_SALESFORCE |
OSM.AS_CHANGED_TERRITORIES_ALL does not reference any database object
OSM.AS_CHANGED_TERRITORIES_ALL is referenced by following:
| Description: | Contains collateral categories |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_COLLATERAL_CAT_ALL.PROMOTION_ID | AS_PROMOTIONS_ALL |
| AS_COLLATERAL_CAT_ALL.CATEGORY_ID | AS_CATEGORIES_ALL |
OSM.AS_COLLATERAL_CAT_ALL does not reference any database object
OSM.AS_COLLATERAL_CAT_ALL is referenced by following:
| Description: | Contains collateral kits |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_COLLATERAL_KITS_ALL.PARENT_COLLATERAL_ID | AS_PROMOTIONS_ALL |
| AS_COLLATERAL_KITS_ALL.CHILD_COLLATERAL_ID | AS_PROMOTIONS_ALL |
OSM.AS_COLLATERAL_KITS_ALL does not reference any database object
OSM.AS_COLLATERAL_KITS_ALL is referenced by following:
| Description: | Contains collateral requests |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_COLLATERAL_REQ_ALL.LIST_ID | AS_PROMOTIONS_ALL |
| AS_COLLATERAL_REQ_ALL.MAIL_BLITZ_ID | AS_PROMOTIONS_ALL |
| AS_COLLATERAL_REQ_ALL.CONTACT_ID | % |
| AS_COLLATERAL_REQ_ALL.ADDRESS_ID | RA_ADDRESSES_ALL |
| AS_COLLATERAL_REQ_ALL.LETTER_ID | AS_PROMOTIONS_ALL |
| AS_COLLATERAL_REQ_ALL.CUSTOMER_ID | RA_CUSTOMERS |
| AS_COLLATERAL_REQ_ALL.LIST_ENTRY_ID | AS_LIST_ENTRIES |
| AS_COLLATERAL_REQ_ALL.ORDER_NUMBER | SO_HEADERS_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| AS_COLLATERAL_REQ_ITEMS.COLLATERAL_REQUEST_ID | AS_COLLATERAL_REQ_ALL |
OSM.AS_COLLATERAL_REQ_ALL does not reference any database object
OSM.AS_COLLATERAL_REQ_ALL is referenced by following:
| Description: | Contains items included in a collateral request |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_COLLATERAL_REQ_ITEMS.COLLATERAL_REQUEST_ID | AS_COLLATERAL_REQ_ALL |
|
AS_COLLATERAL_REQ_ITEMS.INVENTORY_ITEM_ID
AS_COLLATERAL_REQ_ITEMS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
| AS_COLLATERAL_REQ_ITEMS.COLLATERAL_ID | AS_PROMOTIONS_ALL |
OSM.AS_COLLATERAL_REQ_ITEMS does not reference any database object
OSM.AS_COLLATERAL_REQ_ITEMS is referenced by following:
| Description: | Contains error messages for concurrent programs |
|---|
OSM.AS_CONC_REQUEST_MESSAGES does not reference any database object
OSM.AS_CONC_REQUEST_MESSAGES is referenced by following:
| Description: | Contains education information for contacts |
|---|
OSM.AS_CONTACT_EDUCATION does not reference any database object
OSM.AS_CONTACT_EDUCATION is referenced by following:
| Description: | Contains entertainment information for contacts |
|---|
OSM.AS_CONTACT_ENTER does not reference any database object
OSM.AS_CONTACT_ENTER is referenced by following:
| Description: | Obsolete table in 11i |
|---|
OSM.AS_CONTACT_FAMILY does not reference any database object
OSM.AS_CONTACT_FAMILY is referenced by following:
| Description: | Contain information about hobbies for contacts |
|---|
OSM.AS_CONTACT_HOBBIES does not reference any database object
OSM.AS_CONTACT_HOBBIES is referenced by following:
| Description: | Contains job history information for contacts |
|---|
OSM.AS_CONTACT_JOB_HISTORY does not reference any database object
OSM.AS_CONTACT_JOB_HISTORY is referenced by following:
| Description: | Contains millitary information for contacts |
|---|
OSM.AS_CONTACT_MILITARY does not reference any database object
OSM.AS_CONTACT_MILITARY is referenced by following:
| Description: | Contains additional preferences for contacts |
|---|
OSM.AS_CONTACT_PREFERENCES does not reference any database object
OSM.AS_CONTACT_PREFERENCES is referenced by following:
| Description: | Contains sport information for contacts |
|---|
OSM.AS_CONTACT_SPORTS does not reference any database object
OSM.AS_CONTACT_SPORTS is referenced by following:
| Description: | Contains traits for contacts |
|---|
OSM.AS_CONTACT_TRAITS does not reference any database object
OSM.AS_CONTACT_TRAITS is referenced by following:
| Description: | Contains international dialing codes for countries |
|---|
OSM.AS_COUNTRY_PHONES does not reference any database object
OSM.AS_COUNTRY_PHONES is referenced by following:
| Description: | This table stores information about the current environment of the |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_CURRENT_ENVIRONMENT.INTEREST_TYPE_ID | AS_INTEREST_TYPES_B |
| AS_CURRENT_ENVIRONMENT.PRIMARY_INTEREST_CODE_ID | AS_INTEREST_CODES_B |
| AS_CURRENT_ENVIRONMENT.SECONDARY_INTEREST_CODE_ID | AS_INTEREST_CODES_B |
| AS_CURRENT_ENVIRONMENT.CUSTOMER_ID | HZ_PARTIES |
| AS_CURRENT_ENVIRONMENT.ADDRESS_ID | HZ_PARTY_SITES |
OSM.AS_CURRENT_ENVIRONMENT does not reference any database object
OSM.AS_CURRENT_ENVIRONMENT is referenced by following:
| Description: | Table for OSM disconnected, stores identifiers for newly created accounts. |
|---|
OSM.AS_CUST_PROFILES does not reference any database object
OSM.AS_CUST_PROFILES is referenced by following:
| Description: | Currently not in use |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_DEFAULT_PURCHASES_ALL.INTEREST_TYPE_ID | AS_INTEREST_TYPES_ALL |
OSM.AS_DEFAULT_PURCHASES_ALL does not reference any database object
OSM.AS_DEFAULT_PURCHASES_ALL is referenced by following:
| Description: | Table for storing Business Events data |
|---|
OSM.AS_EVENT_DATA does not reference any database object
OSM.AS_EVENT_DATA is referenced by following:
| Description: | Contains event enrollments |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_EVENT_ENROLLMENTS_ALL.CUSTOMER_ID | RA_CUSTOMERS |
| AS_EVENT_ENROLLMENTS_ALL.ADDRESS_ID | RA_ADDRESSES_ALL |
| AS_EVENT_ENROLLMENTS_ALL.CONTACT_ID | % |
| AS_EVENT_ENROLLMENTS_ALL.EVENT_ID | AS_PROMOTIONS_ALL |
| AS_EVENT_ENROLLMENTS_ALL.SOURCE_PROMOTION_ID | AS_PROMOTIONS_ALL |
OSM.AS_EVENT_ENROLLMENTS_ALL does not reference any database object
OSM.AS_EVENT_ENROLLMENTS_ALL is referenced by following:
| Description: | Contains event facilities |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_PROMOTIONS_ALL.EVENT_FACILITY_ID | AS_EVENT_FACILITIES_ALL |
OSM.AS_EVENT_FACILITIES_ALL does not reference any database object
OSM.AS_EVENT_FACILITIES_ALL is referenced by following:
| Description: | Contains event facility rooms |
|---|
OSM.AS_EVENT_FAC_ROOMS does not reference any database object
OSM.AS_EVENT_FAC_ROOMS is referenced by following:
| Description: | Contains event facility staff |
|---|
OSM.AS_EVENT_FAC_STAFF does not reference any database object
OSM.AS_EVENT_FAC_STAFF is referenced by following:
| Description: | Contains letters to be used for events |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_EVENT_LETTERS_ALL.EVENT_ID | AS_PROMOTIONS_ALL |
| AS_EVENT_LETTERS_ALL.LETTER_ID | AS_PROMOTIONS_ALL |
OSM.AS_EVENT_LETTERS_ALL does not reference any database object
OSM.AS_EVENT_LETTERS_ALL is referenced by following:
| Description: | Contains events |
|---|
OSM.AS_EVENT_NAMES_ALL does not reference any database object
OSM.AS_EVENT_NAMES_ALL is referenced by following:
| Description: | Contains event requirements |
|---|
OSM.AS_EVENT_NAME_REQUIREMENTS does not reference any database object
OSM.AS_EVENT_NAME_REQUIREMENTS is referenced by following:
| Description: | Contains event personnel |
|---|
OSM.AS_EVENT_PERSONNEL does not reference any database object
OSM.AS_EVENT_PERSONNEL is referenced by following:
| Description: | Base table to store exchanges |
|---|
OSM.AS_EXCHANGES_B does not reference any database object
OSM.AS_EXCHANGES_B is referenced by following:
| Description: | For MLS - Translated columns of Exchanges |
|---|
OSM.AS_EXCHANGES_TL does not reference any database object
OSM.AS_EXCHANGES_TL is referenced by following:
| Description: | Holds revenue and quota credit forecasts |
|---|
OSM.AS_FORECASTS does not reference any database object
OSM.AS_FORECASTS is referenced by following:
| Description: | Table for comparing the actual returns with forecasted values |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_FORECAST_ACTUALS.SALES_GROUP_ID | JTF_RS_GROUPS_B |
| AS_FORECAST_ACTUALS.SALESFORCE_ID | JTF_RS_RESOURCE_EXTNS |
| AS_FORECAST_ACTUALS.CURRENCY_CODE | FND_CURRENCIES |
| AS_FORECAST_ACTUALS.FORECAST_CATEGORY_ID | AS_FORECAST_CATEGORIES_B |
OSM.AS_FORECAST_ACTUALS does not reference any database object
OSM.AS_FORECAST_ACTUALS is referenced by following:
| Description: | Forecast categories will determine the selection of interest types available for forecast. Any opportunity which has interest types mapped to the forecast category can only be used for forecasting purpose. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_FORECAST_ACTUALS.FORECAST_CATEGORY_ID | AS_FORECAST_CATEGORIES_B |
| AS_FST_SALES_CATEGORIES.FORECAST_CATEGORY_ID | AS_FORECAST_CATEGORIES_B |
| AS_INTERNAL_FORECASTS.FORECAST_CATEGORY_ID | AS_FORECAST_CATEGORIES_B |
OSM.AS_FORECAST_CATEGORIES_B does not reference any database object
OSM.AS_FORECAST_CATEGORIES_B is referenced by following:
| Description: | Forecast categories will determine the selection of interest types available for forecast. Any opportunity which has interest types mapped to the forecast category can only be used for forecasting purpose. |
|---|
OSM.AS_FORECAST_CATEGORIES_TL does not reference any database object
OSM.AS_FORECAST_CATEGORIES_TL is referenced by following:
| Description: |
|---|
OSM.AS_FORECAST_CAT_DEN does not reference any database object
OSM.AS_FORECAST_CAT_DEN is referenced by following:
| Description: | AS_FORECAST_PROB_ALL defines win probability values for sales |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_FORECAST_PROB_ALL_TL.PROBABILITY_VALUE | AS_FORECAST_PROB_ALL_B |
| AS_LEADS_ALL.WIN_PROBABILITY | AS_FORECAST_PROB_ALL_B |
| AS_SALES_CREDITS_DENORM.WIN_PROBABILITY | AS_FORECAST_PROB_ALL_B |
| AS_SALES_METH_STAGE_MAP.MIN_WIN_PROBABILITY | AS_FORECAST_PROB_ALL_B |
| AS_SALES_METH_STAGE_MAP.MAX_WIN_PROBABILITY | AS_FORECAST_PROB_ALL_B |
| AS_SALES_STAGES_ALL_B.MAX_WIN_PROBABILITY | AS_FORECAST_PROB_ALL_B |
| AS_SALES_STAGES_ALL_B.MIN_WIN_PROBABILITY | AS_FORECAST_PROB_ALL_B |
OSM.AS_FORECAST_PROB_ALL_B does not reference any database object
OSM.AS_FORECAST_PROB_ALL_B is referenced by following:
| Description: | MLS - Translated columns of AS_FORECAST_PROB_ALL_B |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_FORECAST_PROB_ALL_TL.PROBABILITY_VALUE | AS_FORECAST_PROB_ALL_B |
OSM.AS_FORECAST_PROB_ALL_TL does not reference any database object
OSM.AS_FORECAST_PROB_ALL_TL is referenced by following:
| Description: | This will store header information for the opportunity and product category worksheet. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_FORECAST_WORKSHEETS.FORECAST_ID | AS_INTERNAL_FORECASTS |
| Foreign Key Column | Foreign Table |
|---|---|
| AS_OPP_WORKSHEET_LINES.FORECAST_WORKSHEET_ID | AS_FORECAST_WORKSHEETS |
| AS_PROD_WORKSHEET_LINES.FORECAST_WORKSHEET_ID | AS_FORECAST_WORKSHEETS |
OSM.AS_FORECAST_WORKSHEETS does not reference any database object
OSM.AS_FORECAST_WORKSHEETS is referenced by following:
| Description: | Resolving table between AS_FORECAST_CATEGORIES and AS_INTEREST_TYPES_B |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_FST_SALES_CATEGORIES.FORECAST_CATEGORY_ID | AS_FORECAST_CATEGORIES_B |
| AS_FST_SALES_CATEGORIES.INTEREST_TYPE_ID | AS_INTEREST_TYPES_B |
| Foreign Key Column | Foreign Table |
|---|---|
| AS_PROD_WORKSHEET_LINES.FST_SALES_CATEGORY_ID | AS_FST_SALES_CATEGORIES |
OSM.AS_FST_SALES_CATEGORIES does not reference any database object
OSM.AS_FST_SALES_CATEGORIES is referenced by following:
| Description: | Base table to store Funds |
|---|
OSM.AS_FUNDS_B does not reference any database object
OSM.AS_FUNDS_B is referenced by following:
| Description: | For MLS - Translated columns of Funds |
|---|
OSM.AS_FUNDS_TL does not reference any database object
OSM.AS_FUNDS_TL is referenced by following:
| Description: | Fund Contacts |
|---|
OSM.AS_FUND_CONTACTS does not reference any database object
OSM.AS_FUND_CONTACTS is referenced by following:
| Description: | Mapping table between issue groups and issues |
|---|
OSM.AS_GROUP_ISSUE_MAP does not reference any database object
OSM.AS_GROUP_ISSUE_MAP is referenced by following:
| Description: | Mapping table between issue groups and issues |
|---|
OSM.AS_GROUP_PARTY_MAP does not reference any database object
OSM.AS_GROUP_PARTY_MAP is referenced by following:
| Description: | Denormalized table to store customer classification code relations data denormalized from HZ_CLASS_CATEGORIES, HZ_CLASS_CATEGORY_USES, HZ_CLASS_CODE_RELATIONS, FND_LOOKUP_TYPES_TL and FND_LOOKUP_VALUES |
|---|
OSM.AS_HZ_CLASS_CODE_DENORM does not reference any database object
OSM.AS_HZ_CLASS_CODE_DENORM is referenced by following:
| Description: | staging table to hold data to be imported |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AML_INTERACTION_LEADS.IMPORT_INTERFACE_ID | AS_IMPORT_INTERFACE |
| AS_IMP_CNT_PNT_INTERFACE.IMPORT_INTERFACE_ID | AS_IMPORT_INTERFACE |
| AS_IMP_CNT_ROL_INTERFACE.IMPORT_INTERFACE_ID | AS_IMPORT_INTERFACE |
| AS_IMP_LINES_INTERFACE.IMPORT_INTERFACE_ID | AS_IMPORT_INTERFACE |
| AS_IMP_SL_FLEX.IMPORT_INTERFACE_ID | AS_IMPORT_INTERFACE |
| AS_LEAD_IMPORT_ERRORS.IMPORT_INTERFACE_ID | AS_IMPORT_INTERFACE |
OSM.AS_IMPORT_INTERFACE does not reference any database object
OSM.AS_IMPORT_INTERFACE is referenced by following:
| Description: | Interface table to hold contact points information to be imported. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_IMP_CNT_PNT_INTERFACE.IMPORT_INTERFACE_ID | AS_IMPORT_INTERFACE |
OSM.AS_IMP_CNT_PNT_INTERFACE does not reference any database object
OSM.AS_IMP_CNT_PNT_INTERFACE is referenced by following:
| Description: | Interface table to hold contact roles information to be imported. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_IMP_CNT_ROL_INTERFACE.IMPORT_INTERFACE_ID | AS_IMPORT_INTERFACE |
OSM.AS_IMP_CNT_ROL_INTERFACE does not reference any database object
OSM.AS_IMP_CNT_ROL_INTERFACE is referenced by following:
| Description: | Interface table to hold lead lines information to be imported. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_IMP_LINES_INTERFACE.IMPORT_INTERFACE_ID | AS_IMPORT_INTERFACE |
OSM.AS_IMP_LINES_INTERFACE does not reference any database object
OSM.AS_IMP_LINES_INTERFACE is referenced by following:
| Description: | Table to hold flex field information to be imported. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_IMP_SL_FLEX.IMPORT_INTERFACE_ID | AS_IMPORT_INTERFACE |
OSM.AS_IMP_SL_FLEX does not reference any database object
OSM.AS_IMP_SL_FLEX is referenced by following:
| Description: | Stores product interests, customer and opportunity classifications |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_INTERESTS_ALL.CONTACT_ID | HZ_ORG_CONTACTS |
| AS_INTERESTS_ALL.ADDRESS_ID | HZ_PARTY_SITES |
| AS_INTERESTS_ALL.LEAD_ID | AS_LEADS_ALL |
| AS_INTERESTS_ALL.PRIMARY_INTEREST_CODE_ID | AS_INTEREST_CODES_B |
| AS_INTERESTS_ALL.SECONDARY_INTEREST_CODE_ID | AS_INTEREST_CODES_B |
| AS_INTERESTS_ALL.INTEREST_TYPE_ID | AS_INTEREST_TYPES_B |
| AS_INTERESTS_ALL.CUSTOMER_ID | HZ_PARTIES |
| AS_INTERESTS_ALL.CONTACT_ID | % |
| AS_INTERESTS_ALL.CUSTOMER_ID | RA_CUSTOMERS |
| AS_INTERESTS_ALL.ADDRESS_ID | RA_ADDRESSES_ALL |
| AS_INTERESTS_ALL.LEAD_ID | AS_LEADS_ALL |
| AS_INTERESTS_ALL.PRIMARY_INTEREST_CODE_ID | AS_INTEREST_CODES_ALL |
| AS_INTERESTS_ALL.SECONDARY_INTEREST_CODE_ID | AS_INTEREST_CODES_ALL |
| AS_INTERESTS_ALL.INTEREST_TYPE_ID | AS_INTEREST_TYPES_ALL |
OSM.AS_INTERESTS_ALL does not reference any database object
OSM.AS_INTERESTS_ALL is referenced by following:
| Description: | Contains interest category sets |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_INTEREST_CATEGORY_SETS_ALL.CATEGORY_SET_ID | MTL_CATEGORY_SETS_B |
| AS_INTEREST_CATEGORY_SETS_ALL.INTEREST_TYPE_ID | AS_INTEREST_TYPES_ALL |
| AS_INTEREST_CATEGORY_SETS_ALL.INTEREST_TYPE_ID | AS_INTEREST_TYPES_B |
OSM.AS_INTEREST_CATEGORY_SETS_ALL does not reference any database object
OSM.AS_INTEREST_CATEGORY_SETS_ALL is referenced by following:
| Description: | Defines interest codes with multi-org flag columns |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_INTEREST_CODES_ALL.INTEREST_CODE_ID | AS_INTEREST_CODES_B |
| Foreign Key Column | Foreign Table |
|---|---|
| AS_INTERESTS_ALL.PRIMARY_INTEREST_CODE_ID | AS_INTEREST_CODES_ALL |
| AS_INTERESTS_ALL.SECONDARY_INTEREST_CODE_ID | AS_INTEREST_CODES_ALL |
| AS_LEAD_LINES_ALL.PRIMARY_INTEREST_CODE_ID | AS_INTEREST_CODES_ALL |
| AS_LEAD_LINES_ALL.SECONDARY_INTEREST_CODE_ID | AS_INTEREST_CODES_ALL |
| AS_TERRITORY_VALUES_ALL.PRIMARY_INTEREST_CODE_ID | AS_INTEREST_CODES_ALL |
| AS_TERRITORY_VALUES_ALL.SECONDARY_INTEREST_CODE_ID | AS_INTEREST_CODES_ALL |
OSM.AS_INTEREST_CODES_ALL does not reference any database object
OSM.AS_INTEREST_CODES_ALL is referenced by following:
| Description: | Define Interest code - Base table |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_INTEREST_CODES_B.PARENT_INTEREST_CODE_ID | AS_INTEREST_CODES_B |
| AS_INTEREST_CODES_B.INTEREST_TYPE_ID | AS_INTEREST_TYPES_B |
| AS_INTEREST_CODES_B.CATEGORY_ID | MTL_CATEGORIES_B |
| AS_INTEREST_CODES_B.CATEGORY_SET_ID | MTL_CATEGORY_SETS_B |
|
AS_INTEREST_CODES_B.PF_ITEM_ID
AS_INTEREST_CODES_B.PF_ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
| Foreign Key Column | Foreign Table |
|---|---|
| AS_CURRENT_ENVIRONMENT.PRIMARY_INTEREST_CODE_ID | AS_INTEREST_CODES_B |
| AS_CURRENT_ENVIRONMENT.SECONDARY_INTEREST_CODE_ID | AS_INTEREST_CODES_B |
| AS_INTERESTS_ALL.PRIMARY_INTEREST_CODE_ID | AS_INTEREST_CODES_B |
| AS_INTERESTS_ALL.SECONDARY_INTEREST_CODE_ID | AS_INTEREST_CODES_B |
| AS_INTEREST_CODES_ALL.INTEREST_CODE_ID | AS_INTEREST_CODES_B |
| AS_INTEREST_CODES_B.PARENT_INTEREST_CODE_ID | AS_INTEREST_CODES_B |
| AS_INTEREST_CODES_MC.INTEREST_CODE_ID | AS_INTEREST_CODES_B |
| AS_INTEREST_CODES_TL.INTEREST_CODE_ID | AS_INTEREST_CODES_B |
| AS_LEAD_LINES_ALL.PRIMARY_INTEREST_CODE_ID | AS_INTEREST_CODES_B |
| AS_LEAD_LINES_ALL.SECONDARY_INTEREST_CODE_ID | AS_INTEREST_CODES_B |
| AS_PE_INT_CATEGORIES.PRI_INTEREST_CODE_ID | AS_INTEREST_CODES_B |
| AS_PE_INT_CATEGORIES.SEC_INTEREST_CODE_ID | AS_INTEREST_CODES_B |
| AS_QUOTA_PROFILES.PRIMARY_INTEREST_CODE_ID | AS_INTEREST_CODES_B |
| AS_SALES_CREDITS_DENORM.PRIMARY_INTEREST_CODE_ID | AS_INTEREST_CODES_B |
| AS_SALES_CREDITS_DENORM.SECONDARY_INTEREST_CODE_ID | AS_INTEREST_CODES_B |
| AS_SALES_LEAD_LINES.PRIMARY_INTEREST_CODE_ID | AS_INTEREST_CODES_B |
| AS_SALES_LEAD_LINES.SECONDARY_INTEREST_CODE_ID | AS_INTEREST_CODES_B |
| AS_SALES_QUOTAS.PRIMARY_INTEREST_CODE_ID | AS_INTEREST_CODES_B |
| AS_SALES_QUOTAS.SECONDARY_INTEREST_CODE_ID | AS_INTEREST_CODES_B |
| IGS_RC_IS_I_LINES.INQ_PROG_CODE_ID | AS_INTEREST_CODES_B |
| IGS_RC_IS_I_LINES.INQ_UNIT_SET_CODE_ID | AS_INTEREST_CODES_B |
| IGS_RC_I_PKG_REDUCT.INQ_PROG_ID | AS_INTEREST_CODES_B |
| IGS_RC_I_PKG_REDUCT.INQ_USET_ID | AS_INTEREST_CODES_B |
OSM.AS_INTEREST_CODES_B does not reference any database object
OSM.AS_INTEREST_CODES_B is referenced by following:
| Description: | for recording a price and currency for a product family. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_INTEREST_CODES_MC.INTEREST_CODE_ID | AS_INTEREST_CODES_B |
OSM.AS_INTEREST_CODES_MC does not reference any database object
OSM.AS_INTEREST_CODES_MC is referenced by following:
| Description: | For MLS - Translated columns of Interest Codes. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_INTEREST_CODES_TL.INTEREST_CODE_ID | AS_INTEREST_CODES_B |
OSM.AS_INTEREST_CODES_TL does not reference any database object
OSM.AS_INTEREST_CODES_TL is referenced by following:
| Description: | Define interest statuses |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_INTEREST_STATUSES.INTEREST_TYPE_ID | AS_INTEREST_TYPES_ALL |
| AS_INTEREST_STATUSES.INTEREST_TYPE_ID | AS_INTEREST_TYPES_B |
OSM.AS_INTEREST_STATUSES does not reference any database object
OSM.AS_INTEREST_STATUSES is referenced by following:
| Description: | Defines interest types with multi-org flag columns |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_INTEREST_TYPES_ALL.INTEREST_TYPE_ID | AS_INTEREST_TYPES_B |
| Foreign Key Column | Foreign Table |
|---|---|
| AS_DEFAULT_PURCHASES_ALL.INTEREST_TYPE_ID | AS_INTEREST_TYPES_ALL |
| AS_INTERESTS_ALL.INTEREST_TYPE_ID | AS_INTEREST_TYPES_ALL |
| AS_INTEREST_CATEGORY_SETS_ALL.INTEREST_TYPE_ID | AS_INTEREST_TYPES_ALL |
| AS_INTEREST_STATUSES.INTEREST_TYPE_ID | AS_INTEREST_TYPES_ALL |
| AS_LEAD_LINES_ALL.INTEREST_TYPE_ID | AS_INTEREST_TYPES_ALL |
| AS_TERRITORY_VALUES_ALL.INTEREST_TYPE_ID | AS_INTEREST_TYPES_ALL |
OSM.AS_INTEREST_TYPES_ALL does not reference any database object
OSM.AS_INTEREST_TYPES_ALL is referenced by following:
| Description: | Define Interest types - base table |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_CURRENT_ENVIRONMENT.INTEREST_TYPE_ID | AS_INTEREST_TYPES_B |
| AS_FST_SALES_CATEGORIES.INTEREST_TYPE_ID | AS_INTEREST_TYPES_B |
| AS_INTERESTS_ALL.INTEREST_TYPE_ID | AS_INTEREST_TYPES_B |
| AS_INTEREST_CATEGORY_SETS_ALL.INTEREST_TYPE_ID | AS_INTEREST_TYPES_B |
| AS_INTEREST_CODES_B.INTEREST_TYPE_ID | AS_INTEREST_TYPES_B |
| AS_INTEREST_STATUSES.INTEREST_TYPE_ID | AS_INTEREST_TYPES_B |
| AS_INTEREST_TYPES_ALL.INTEREST_TYPE_ID | AS_INTEREST_TYPES_B |
| AS_INTEREST_TYPES_TL.INTEREST_TYPE_ID | AS_INTEREST_TYPES_B |
| AS_LEAD_LINES_ALL.INTEREST_TYPE_ID | AS_INTEREST_TYPES_B |
| AS_PE_INT_CATEGORIES.INTEREST_TYPE_ID | AS_INTEREST_TYPES_B |
| AS_QUOTA_PROFILES.INTEREST_TYPE_ID | AS_INTEREST_TYPES_B |
| AS_SALES_CREDITS_DENORM.INTEREST_TYPE_ID | AS_INTEREST_TYPES_B |
| AS_SALES_LEAD_LINES.INTEREST_TYPE_ID | AS_INTEREST_TYPES_B |
| AS_SALES_QUOTAS.INTEREST_TYPE_ID | AS_INTEREST_TYPES_B |
| IGS_RC_I_ENT_STATS.INTEREST_TYPE_ID | AS_INTEREST_TYPES_B |
| PV_ITYPE_ATTR_MAPS.INTEREST_TYPE_ID | AS_INTEREST_TYPES_B |
OSM.AS_INTEREST_TYPES_B does not reference any database object
OSM.AS_INTEREST_TYPES_B is referenced by following:
| Description: | For MLS - Translated columns of Interest Types |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_INTEREST_TYPES_TL.INTEREST_TYPE_ID | AS_INTEREST_TYPES_B |
OSM.AS_INTEREST_TYPES_TL does not reference any database object
OSM.AS_INTEREST_TYPES_TL is referenced by following:
| Description: | Table to store the summary forecast information for individual or group |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_INTERNAL_FORECASTS.ORIGINAL_FORECAST_ID | AS_INTERNAL_FORECASTS |
| AS_INTERNAL_FORECASTS.FORECAST_CATEGORY_ID | AS_FORECAST_CATEGORIES_B |
| AS_INTERNAL_FORECASTS.SALESFORCE_ID | JTF_RS_RESOURCE_EXTNS |
| AS_INTERNAL_FORECASTS.SALES_GROUP_ID | JTF_RS_GROUPS_B |
| AS_INTERNAL_FORECASTS.SALES_GROUP_ID | % |
| Foreign Key Column | Foreign Table |
|---|---|
| AS_FORECAST_WORKSHEETS.FORECAST_ID | AS_INTERNAL_FORECASTS |
| AS_INTERNAL_FORECASTS.ORIGINAL_FORECAST_ID | AS_INTERNAL_FORECASTS |
OSM.AS_INTERNAL_FORECASTS does not reference any database object
OSM.AS_INTERNAL_FORECASTS is referenced by following:
| Description: | Stores invalid addresses from ra_addresses |
|---|
OSM.AS_INVALID_ADDR does not reference any database object
OSM.AS_INVALID_ADDR is referenced by following:
| Description: | Stores Issuers |
|---|
OSM.AS_ISSUER does not reference any database object
OSM.AS_ISSUER is referenced by following:
| Description: | Holds Issues - Base Table |
|---|
OSM.AS_ISSUES_B does not reference any database object
OSM.AS_ISSUES_B is referenced by following:
| Description: | For MLS - Translated columns of Issues |
|---|
OSM.AS_ISSUES_TL does not reference any database object
OSM.AS_ISSUES_TL is referenced by following:
| Description: | Holds Issue Groups - Base Table |
|---|
OSM.AS_ISSUE_GROUPS_B does not reference any database object
OSM.AS_ISSUE_GROUPS_B is referenced by following:
| Description: | For MLS - Translated columns of Issue Groups |
|---|
OSM.AS_ISSUE_GROUPS_TL does not reference any database object
OSM.AS_ISSUE_GROUPS_TL is referenced by following:
| Description: | Holds Issue Group Identifiers |
|---|
OSM.AS_ISSUE_GROUP_IDFR does not reference any database object
OSM.AS_ISSUE_GROUP_IDFR is referenced by following:
| Description: | Holds Issue Group Types |
|---|
OSM.AS_ISSUE_GROUP_TYPES does not reference any database object
OSM.AS_ISSUE_GROUP_TYPES is referenced by following:
| Description: | Holds Issue Listings - base table |
|---|
OSM.AS_ISSUE_LISTING_B does not reference any database object
OSM.AS_ISSUE_LISTING_B is referenced by following:
| Description: | Holds issue listing identifiers |
|---|
OSM.AS_ISSUE_LISTING_IDFR does not reference any database object
OSM.AS_ISSUE_LISTING_IDFR is referenced by following:
| Description: | For MLS - Translated columns of Issue Listings |
|---|
OSM.AS_ISSUE_LISTING_TL does not reference any database object
OSM.AS_ISSUE_LISTING_TL is referenced by following:
| Description: | Stores Issue Relationships |
|---|
OSM.AS_ISSUE_RELATIONSHIPS does not reference any database object
OSM.AS_ISSUE_RELATIONSHIPS is referenced by following:
| Description: | Contains the last date an Oracle Sales and marketing concurrent program ran |
|---|
OSM.AS_LAST_RUN_DATES does not reference any database object
OSM.AS_LAST_RUN_DATES is referenced by following:
| Description: | Holds sales opportunities |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_LEADS_ALL.CUSTOMER_ID | HZ_PARTIES |
| AS_LEADS_ALL.WIN_PROBABILITY | AS_FORECAST_PROB_ALL_B |
| AS_LEADS_ALL.ADDRESS_ID | HZ_PARTY_SITES |
| AS_LEADS_ALL.OWNER_SALESFORCE_ID | JTF_RS_RESOURCE_EXTNS |
| AS_LEADS_ALL.OWNER_SALES_GROUP_ID | JTF_RS_GROUPS_B |
| AS_LEADS_ALL.SALES_STAGE_ID | AS_SALES_STAGES_ALL_B |
| AS_LEADS_ALL.SOURCE_PROMOTION_ID | AMS_SOURCE_CODES |
| AS_LEADS_ALL.STATUS | AS_STATUSES_B |
| AS_LEADS_ALL.CLOSE_COMPETITOR_ID | HZ_PARTIES |
| AS_LEADS_ALL.CURRENCY_CODE | FND_CURRENCIES |
| AS_LEADS_ALL.SALES_METHODOLOGY_ID | AS_SALES_METHODOLOGY_B |
| AS_LEADS_ALL.CUSTOMER_ID | RA_CUSTOMERS |
| AS_LEADS_ALL.ADDRESS_ID | RA_ADDRESSES_ALL |
| AS_LEADS_ALL.CURRENCY_CODE | FND_CURRENCIES |
| AS_LEADS_ALL.SALES_STAGE_ID | AS_SALES_STAGES_ALL_B |
| AS_LEADS_ALL.INITIATING_CONTACT_ID | % |
| Foreign Key Column | Foreign Table |
|---|---|
| ASO_QUOTE_RELATED_OBJECTS.OBJECT_ID | AS_LEADS_ALL |
| AS_ACCESSES_ALL_ALL.LEAD_ID | AS_LEADS_ALL |
| AS_ACCESSES_ALL_ALL.LEAD_ID | AS_LEADS_ALL |
| AS_CHANGED_ACCOUNTS_ALL.LEAD_ID | AS_LEADS_ALL |
| AS_INTERESTS_ALL.LEAD_ID | AS_LEADS_ALL |
| AS_INTERESTS_ALL.LEAD_ID | AS_LEADS_ALL |
| AS_LEAD_COMPETITORS.LEAD_ID | AS_LEADS_ALL |
| AS_LEAD_COMP_PRODUCTS.LEAD_ID | AS_LEADS_ALL |
| AS_LEAD_CONTACTS_ALL.LEAD_ID | AS_LEADS_ALL |
| AS_LEAD_CONTACTS_ALL.LEAD_ID | AS_LEADS_ALL |
| AS_LEAD_LINES_ALL.LEAD_ID | AS_LEADS_ALL |
| AS_LEAD_LINES_ALL.LEAD_ID | AS_LEADS_ALL |
| AS_LEAD_LOG.LEAD_ID | AS_LEADS_ALL |
| AS_LEADS_LOG.LEAD_ID | AS_LEADS_ALL |
| AS_LEAD_OBSTACLES.LEAD_ID | AS_LEADS_ALL |
| AS_LEAD_ORDERS.LEAD_ID | AS_LEADS_ALL |
| AS_OPP_WORKSHEET_LINES.LEAD_ID | AS_LEADS_ALL |
| AS_SALES_CREDITS_DENORM.LEAD_ID | AS_LEADS_ALL |
| AS_SALES_CREDITS.LEAD_ID | AS_LEADS_ALL |
| AS_SALES_LEAD_OPPORTUNITY.OPPORTUNITY_ID | AS_LEADS_ALL |
| AS_TERR_RESOURCES_TMP.LEAD_ID | AS_LEADS_ALL |
| JTF_NOTES_B.SOURCE_OBJECT_ID | AS_LEADS_ALL |
| JTF_NOTE_CONTEXTS.NOTE_CONTEXT_TYPE_ID | AS_LEADS_ALL |
| PV_REFERRALS_B.ENTITY_ID_LINKED_TO | AS_LEADS_ALL |
| PV_ENTY_ATTR_VALUES.ENTITY_ID | AS_LEADS_ALL |
| PV_LEAD_ASSIGNMENTS.LEAD_ID | AS_LEADS_ALL |
| PV_LEAD_PSS_LINES.LEAD_ID | AS_LEADS_ALL |
| PV_LEAD_WORKFLOWS.LEAD_ID | AS_LEADS_ALL |
OSM.AS_LEADS_ALL does not reference any database object
OSM.AS_LEADS_ALL is referenced by following:
| Description: | Holds opportunity header change history |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_LEADS_LOG.CUSTOMER_ID | HZ_PARTIES |
| AS_LEADS_LOG.LEAD_ID | AS_LEADS_ALL |
OSM.AS_LEADS_LOG does not reference any database object
OSM.AS_LEADS_LOG is referenced by following:
| Description: | Stores adjustments to a lead (opportunity). |
|---|
OSM.AS_LEAD_ADJS does not reference any database object
OSM.AS_LEAD_ADJS is referenced by following:
| Description: | Defines competitors for sales opportunities |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_LEAD_COMPETITORS.LEAD_ID | AS_LEADS_ALL |
| AS_LEAD_COMPETITORS.COMPETITOR_ID | HZ_PARTIES |
| Foreign Key Column | Foreign Table |
|---|---|
| AS_LEAD_COMPETITOR_PRODS.LEAD_COMPETITOR_ID | AS_LEAD_COMPETITORS |
OSM.AS_LEAD_COMPETITORS does not reference any database object
OSM.AS_LEAD_COMPETITORS is referenced by following:
| Description: | Holds competitor products |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_LEAD_COMP_PRODUCTS.LEAD_ID | AS_LEADS_ALL |
| AS_LEAD_COMP_PRODUCTS.LEAD_LINE_ID | AS_LEAD_LINES_ALL |
| AS_LEAD_COMP_PRODUCTS.COMPETITOR_PRODUCT_ID | AMS_COMPETITOR_PRODUCTS_B |
| AS_LEAD_COMP_PRODUCTS.COMPETITOR_ID | HZ_PARTIES |
OSM.AS_LEAD_COMP_PRODUCTS does not reference any database object
OSM.AS_LEAD_COMP_PRODUCTS is referenced by following:
| Description: | Contains contacts linked to sales opportunities |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_LEAD_CONTACTS_ALL.LEAD_ID | AS_LEADS_ALL |
| AS_LEAD_CONTACTS_ALL.CONTACT_PARTY_ID | HZ_PARTIES |
| AS_LEAD_CONTACTS_ALL.ADDRESS_ID | HZ_PARTY_SITES |
| AS_LEAD_CONTACTS_ALL.CUSTOMER_ID | HZ_PARTIES |
| AS_LEAD_CONTACTS_ALL.PHONE_ID | HZ_CONTACT_POINTS |
| AS_LEAD_CONTACTS_ALL.CONTACT_ID | HZ_ORG_CONTACTS |
| AS_LEAD_CONTACTS_ALL.LEAD_ID | AS_LEADS_ALL |
| AS_LEAD_CONTACTS_ALL.PHONE_ID | RA_PHONES |
| AS_LEAD_CONTACTS_ALL.CONTACT_ID | % |
OSM.AS_LEAD_CONTACTS_ALL does not reference any database object
OSM.AS_LEAD_CONTACTS_ALL is referenced by following:
| Description: | Holds decision factors |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_LEAD_DECISION_FACTORS.LEAD_LINE_ID | AS_LEAD_LINES_ALL |
OSM.AS_LEAD_DECISION_FACTORS does not reference any database object
OSM.AS_LEAD_DECISION_FACTORS is referenced by following:
| Description: | Contains the error messages for imported sales leads |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_LEAD_IMPORT_ERRORS.IMPORT_INTERFACE_ID | AS_IMPORT_INTERFACE |
OSM.AS_LEAD_IMPORT_ERRORS does not reference any database object
OSM.AS_LEAD_IMPORT_ERRORS is referenced by following:
| Description: | Holds sales opportunity lines |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_LEAD_LINES_ALL.LEAD_ID | AS_LEADS_ALL |
|
AS_LEAD_LINES_ALL.INVENTORY_ITEM_ID
AS_LEAD_LINES_ALL.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
| AS_LEAD_LINES_ALL.INTEREST_TYPE_ID | AS_INTEREST_TYPES_B |
| AS_LEAD_LINES_ALL.PRIMARY_INTEREST_CODE_ID | AS_INTEREST_CODES_B |
| AS_LEAD_LINES_ALL.SECONDARY_INTEREST_CODE_ID | AS_INTEREST_CODES_B |
| AS_LEAD_LINES_ALL.SOURCE_PROMOTION_ID | AMS_SOURCE_CODES |
| AS_LEAD_LINES_ALL.OFFER_ID | AMS_ACT_OFFERS |
| AS_LEAD_LINES_ALL.LEAD_ID | AS_LEADS_ALL |
|
AS_LEAD_LINES_ALL.INVENTORY_ITEM_ID
AS_LEAD_LINES_ALL.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
| AS_LEAD_LINES_ALL.PRIMARY_INTEREST_CODE_ID | AS_INTEREST_CODES_ALL |
| AS_LEAD_LINES_ALL.SECONDARY_INTEREST_CODE_ID | AS_INTEREST_CODES_ALL |
| AS_LEAD_LINES_ALL.INTEREST_TYPE_ID | AS_INTEREST_TYPES_ALL |
| AS_LEAD_LINES_ALL.SALES_STAGE_ID | AS_SALES_STAGES_ALL_B |
| Foreign Key Column | Foreign Table |
|---|---|
| ASO_QUOTE_RELATED_OBJECTS.OBJECT_ID | AS_LEAD_LINES_ALL |
| AS_LEAD_COMP_PRODUCTS.LEAD_LINE_ID | AS_LEAD_LINES_ALL |
| AS_LEAD_DECISION_FACTORS.LEAD_LINE_ID | AS_LEAD_LINES_ALL |
| AS_OPP_COMPETING_PRODS.LEAD_LINE_ID | AS_LEAD_LINES_ALL |
| AS_SALES_CREDITS_DENORM.LEAD_LINE_ID | AS_LEAD_LINES_ALL |
| AS_SALES_CREDITS.LEAD_LINE_ID | AS_LEAD_LINES_ALL |
| AS_SALES_LEAD_OPP_LINES.OPP_LINE_ID | AS_LEAD_LINES_ALL |
OSM.AS_LEAD_LINES_ALL does not reference any database object
OSM.AS_LEAD_LINES_ALL is referenced by following:
| Description: | Hold purchase line change history |
|---|
OSM.AS_LEAD_LINES_LOG does not reference any database object
OSM.AS_LEAD_LINES_LOG is referenced by following:
| Description: | Stores adjustments to lead (opportunity) lines. |
|---|
OSM.AS_LEAD_LINE_ADJS does not reference any database object
OSM.AS_LEAD_LINE_ADJS is referenced by following:
| Description: | Defines obstacles for sales opportunities |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_LEAD_OBSTACLES.LEAD_ID | AS_LEADS_ALL |
OSM.AS_LEAD_OBSTACLES does not reference any database object
OSM.AS_LEAD_OBSTACLES is referenced by following:
| Description: | Contains orders resulting from sales opportunities |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_LEAD_ORDERS.LEAD_ID | AS_LEADS_ALL |
OSM.AS_LEAD_ORDERS does not reference any database object
OSM.AS_LEAD_ORDERS is referenced by following:
| Description: | Store partner information for Opportunity Exchange Transaction Server |
|---|
OSM.AS_LETS_PARTNER_MAP does not reference any database object
OSM.AS_LETS_PARTNER_MAP is referenced by following:
| Description: | Defines market and campaign lists |
|---|
OSM.AS_LISTS_ALL does not reference any database object
OSM.AS_LISTS_ALL is referenced by following:
| Description: | Holds list entries |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_LIST_ENTRIES.ADDRESS_ID | RA_ADDRESSES_ALL |
| AS_LIST_ENTRIES.PHONE_ID | RA_PHONES |
| AS_LIST_ENTRIES.CONTACT_ID | % |
| AS_LIST_ENTRIES.CUSTOMER_ID | RA_CUSTOMERS |
| AS_LIST_ENTRIES.LIST_ID | AS_PROMOTIONS_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| AS_COLLATERAL_REQ_ALL.LIST_ENTRY_ID | AS_LIST_ENTRIES |
OSM.AS_LIST_ENTRIES does not reference any database object
OSM.AS_LIST_ENTRIES is referenced by following:
| Description: | Contains the assignement of list entries to the sales person and the promotion. |
|---|
OSM.AS_LIST_ENTRY_USAGES does not reference any database object
OSM.AS_LIST_ENTRY_USAGES is referenced by following:
| Description: | This table stores the user-defined rules for identifying duplicates in a list. |
|---|
OSM.AS_LIST_RULES does not reference any database object
OSM.AS_LIST_RULES is referenced by following:
| Description: | This table stores the columns that are used to identify duplicates in a list. |
|---|
OSM.AS_LIST_RULE_ENTRIES does not reference any database object
OSM.AS_LIST_RULE_ENTRIES is referenced by following:
| Description: | Holds data for opportunity log status summary |
|---|
OSM.AS_LLOG_STATUS_SUMMARY does not reference any database object
OSM.AS_LLOG_STATUS_SUMMARY is referenced by following:
| Description: | For Lead Sharing use |
|---|
OSM.AS_LS_ERRS does not reference any database object
OSM.AS_LS_ERRS is referenced by following:
| Description: | Holds reporting currencies |
|---|
OSM.AS_MC_REPORTING_CURR does not reference any database object
OSM.AS_MC_REPORTING_CURR is referenced by following:
| Description: | Multi currency table to store sales credit amounts converted in various reporting currencies based on daily as well as pseudo period rates |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_MC_SALES_CREDITS_DEN.SALES_CREDIT_ID | AS_SALES_CREDITS_DENORM |
|
AS_MC_SALES_CREDITS_DEN.CONVERSION_PERIOD_TYPE
AS_MC_SALES_CREDITS_DEN.CONVERSION_TYPE AS_MC_SALES_CREDITS_DEN.CONVERSION_PERIOD_SET_NAME |
AS_MC_TYPE_MAPPINGS |
|
AS_MC_SALES_CREDITS_DEN.CONVERSION_PERIOD_SET_NAME
AS_MC_SALES_CREDITS_DEN.CONVERSION_PERIOD_NAME |
GL_PERIODS |
OSM.AS_MC_SALES_CREDITS_DEN does not reference any database object
OSM.AS_MC_SALES_CREDITS_DEN is referenced by following:
| Description: | Define the mapping from Period to Conversion_type. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
|
AS_MC_SALES_CREDITS_DEN.CONVERSION_PERIOD_TYPE
AS_MC_SALES_CREDITS_DEN.CONVERSION_TYPE AS_MC_SALES_CREDITS_DEN.CONVERSION_PERIOD_SET_NAME |
AS_MC_TYPE_MAPPINGS |
OSM.AS_MC_TYPE_MAPPINGS does not reference any database object
OSM.AS_MC_TYPE_MAPPINGS is referenced by following:
| Description: | Holds information about letter merge files |
|---|
OSM.AS_MERGE_FILES_ALL does not reference any database object
OSM.AS_MERGE_FILES_ALL is referenced by following:
| Description: | This table stores methodology stage instances. |
|---|
OSM.AS_METH_STAGE_INSTANCES does not reference any database object
OSM.AS_METH_STAGE_INSTANCES is referenced by following:
| Description: | This table stores methodology step instances. |
|---|
OSM.AS_METH_STEP_INSTANCES does not reference any database object
OSM.AS_METH_STEP_INSTANCES is referenced by following:
| Description: |
|---|
OSM.AS_MRP_FCT_DETAIL does not reference any database object
OSM.AS_MRP_FCT_DETAIL is referenced by following:
| Description: |
|---|
OSM.AS_MRP_FCT_REPORT does not reference any database object
OSM.AS_MRP_FCT_REPORT is referenced by following:
| Description: | Holds OSM-MRP interface header information |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_MRP_INTERFACE_LINES.SEQUENCE_ID | AS_MRP_INTERFACE |
OSM.AS_MRP_INTERFACE does not reference any database object
OSM.AS_MRP_INTERFACE is referenced by following:
| Description: | Holds OSM-MRP interface lines information |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_MRP_INTERFACE_LINES.SEQUENCE_ID | AS_MRP_INTERFACE |
OSM.AS_MRP_INTERFACE_LINES does not reference any database object
OSM.AS_MRP_INTERFACE_LINES is referenced by following:
| Description: |
|---|
OSM.AS_MRP_OPP_REPORT does not reference any database object
OSM.AS_MRP_OPP_REPORT is referenced by following:
| Description: | PRM related table |
|---|
OSM.AS_OBJECT_ATTRIBUTES does not reference any database object
OSM.AS_OBJECT_ATTRIBUTES is referenced by following:
| Description: | Table to store the forecast information on all possible opportunities for individual or sales group |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_OPP_WORKSHEET_LINES.LEAD_ID | AS_LEADS_ALL |
| AS_OPP_WORKSHEET_LINES.FORECAST_WORKSHEET_ID | AS_FORECAST_WORKSHEETS |
| AS_OPP_WORKSHEET_LINES.SALES_STAGE_ID | AS_SALES_STAGES_ALL_B |
| AS_OPP_WORKSHEET_LINES.CUSTOMER_ID | HZ_PARTIES |
| AS_OPP_WORKSHEET_LINES.STATUS | AS_STATUSES_B |
OSM.AS_OPP_WORKSHEET_LINES does not reference any database object
OSM.AS_OPP_WORKSHEET_LINES is referenced by following:
| Description: | This table is only for Oracle internal rollout. |
|---|
OSM.AS_OSI_CONS_CCS_BASE does not reference any database object
OSM.AS_OSI_CONS_CCS_BASE is referenced by following:
| Description: | This table is only for Oracle internal rollout. |
|---|
OSM.AS_OSI_CONTR_NAMES_BASE does not reference any database object
OSM.AS_OSI_CONTR_NAMES_BASE is referenced by following:
| Description: | This table is only for Oracle internal rollout. |
|---|
OSM.AS_OSI_CONTR_VHCL_BASE does not reference any database object
OSM.AS_OSI_CONTR_VHCL_BASE is referenced by following:
| Description: | This table is only for Oracle internal rollout. |
|---|
OSM.AS_OSI_LEADS_ALL does not reference any database object
OSM.AS_OSI_LEADS_ALL is referenced by following:
| Description: | Denormalized table |
|---|
OSM.AS_OSI_LEADS_DENORM does not reference any database object
OSM.AS_OSI_LEADS_DENORM is referenced by following:
| Description: | This table is only for Oracle internal rollout. |
|---|
OSM.AS_OSI_LEAD_OVL_ALL does not reference any database object
OSM.AS_OSI_LEAD_OVL_ALL is referenced by following:
| Description: | This table is only for Oracle internal rollout. |
|---|
OSM.AS_OSI_LOOKUP does not reference any database object
OSM.AS_OSI_LOOKUP is referenced by following:
| Description: | This table is only for Oracle internal rollout. |
|---|
OSM.AS_OSI_OVERLAY_BASE does not reference any database object
OSM.AS_OSI_OVERLAY_BASE is referenced by following:
| Description: | Stores the sales rep information for a lead in partner's OSO database. |
|---|
OSM.AS_PARTNER_ACCESSES does not reference any database object
OSM.AS_PARTNER_ACCESSES is referenced by following:
| Description: | Stores the contact information for a lead in partner's OSO database. |
|---|
OSM.AS_PARTNER_LEAD_CONTACTS does not reference any database object
OSM.AS_PARTNER_LEAD_CONTACTS is referenced by following:
| Description: | Stores the contact information for a lead in partner's OSO database. |
|---|
OSM.AS_PARTNER_LEAD_LINES does not reference any database object
OSM.AS_PARTNER_LEAD_LINES is referenced by following:
| Description: | Stores the Notes information for a lead in partner's OSO database. |
|---|
OSM.AS_PARTNER_LEAD_NOTES does not reference any database object
OSM.AS_PARTNER_LEAD_NOTES is referenced by following:
| Description: | OBSOLETE |
|---|
OSM.AS_PARTNER_MAP does not reference any database object
OSM.AS_PARTNER_MAP is referenced by following:
| Description: | simplifies gl_periods |
|---|
OSM.AS_PERIOD_DAYS does not reference any database object
OSM.AS_PERIOD_DAYS is referenced by following:
| Description: | Holds currency conversion rates |
|---|
OSM.AS_PERIOD_RATES does not reference any database object
OSM.AS_PERIOD_RATES is referenced by following:
| Description: | Mapping table between plan elements in osc and forecast |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_PE_INT_CATEGORIES.QUOTA_ID | CN_QUOTAS_ALL |
| AS_PE_INT_CATEGORIES.INTEREST_TYPE_ID | AS_INTEREST_TYPES_B |
| AS_PE_INT_CATEGORIES.PRI_INTEREST_CODE_ID | AS_INTEREST_CODES_B |
| AS_PE_INT_CATEGORIES.SEC_INTEREST_CODE_ID | AS_INTEREST_CODES_B |
OSM.AS_PE_INT_CATEGORIES does not reference any database object
OSM.AS_PE_INT_CATEGORIES is referenced by following:
| Description: | Defines valid phone formats for a particular country |
|---|
OSM.AS_PHONE_FORMATS does not reference any database object
OSM.AS_PHONE_FORMATS is referenced by following:
| Description: | Price lists |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_PRICE_LISTS.PRICE_LIST_ID | QP_LIST_HEADERS_B |
| AS_PRICE_LISTS.GROUP_ID | AS_PRICE_LIST_GROUPS |
OSM.AS_PRICE_LISTS does not reference any database object
OSM.AS_PRICE_LISTS is referenced by following:
| Description: | Price lists groups |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_PRICE_LISTS.GROUP_ID | AS_PRICE_LIST_GROUPS |
OSM.AS_PRICE_LIST_GROUPS does not reference any database object
OSM.AS_PRICE_LIST_GROUPS is referenced by following:
| Description: |
|---|
OSM.AS_PRODUCT_FILTERS does not reference any database object
OSM.AS_PRODUCT_FILTERS is referenced by following:
| Description: | Table to store the forecast information on all possible product categories for individual or sales group |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_PROD_WORKSHEET_LINES.SALES_QUOTA_ID | AS_SALES_QUOTAS |
| AS_PROD_WORKSHEET_LINES.FORECAST_WORKSHEET_ID | AS_FORECAST_WORKSHEETS |
| AS_PROD_WORKSHEET_LINES.FST_SALES_CATEGORY_ID | AS_FST_SALES_CATEGORIES |
OSM.AS_PROD_WORKSHEET_LINES does not reference any database object
OSM.AS_PROD_WORKSHEET_LINES is referenced by following:
| Description: | Defines promotions |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_PROMOTIONS_ALL.EVENT_FACILITY_ID | AS_EVENT_FACILITIES_ALL |
| AS_PROMOTIONS_ALL.CURRENCY_CODE | FND_CURRENCIES |
|
AS_PROMOTIONS_ALL.COLLATERAL_INVENTORY_ITEM_ID
AS_PROMOTIONS_ALL.COLLATERAL_ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
| Foreign Key Column | Foreign Table |
|---|---|
| AS_COLLATERAL_KITS_ALL.PARENT_COLLATERAL_ID | AS_PROMOTIONS_ALL |
| AS_COLLATERAL_KITS_ALL.CHILD_COLLATERAL_ID | AS_PROMOTIONS_ALL |
| AS_COLLATERAL_REQ_ALL.LIST_ID | AS_PROMOTIONS_ALL |
| AS_COLLATERAL_REQ_ALL.MAIL_BLITZ_ID | AS_PROMOTIONS_ALL |
| AS_COLLATERAL_REQ_ALL.LETTER_ID | AS_PROMOTIONS_ALL |
| AS_COLLATERAL_CAT_ALL.PROMOTION_ID | AS_PROMOTIONS_ALL |
| AS_COLLATERAL_REQ_ITEMS.COLLATERAL_ID | AS_PROMOTIONS_ALL |
| AS_EVENT_ENROLLMENTS_ALL.EVENT_ID | AS_PROMOTIONS_ALL |
| AS_EVENT_ENROLLMENTS_ALL.SOURCE_PROMOTION_ID | AS_PROMOTIONS_ALL |
| AS_EVENT_LETTERS_ALL.EVENT_ID | AS_PROMOTIONS_ALL |
| AS_EVENT_LETTERS_ALL.LETTER_ID | AS_PROMOTIONS_ALL |
| AS_LIST_ENTRIES.LIST_ID | AS_PROMOTIONS_ALL |
| AS_PROMOTION_RELATIONSHIPS.PARENT_PROMOTION_ID | AS_PROMOTIONS_ALL |
| AS_PROMOTION_RELATIONSHIPS.CHILD_PROMOTION_ID | AS_PROMOTIONS_ALL |
| AS_PROMOTION_SCRIPTS.SCRIPT_ID | AS_PROMOTIONS_ALL |
| AS_PROMOTION_SCRIPTS.PROMOTION_ID | AS_PROMOTIONS_ALL |
| AS_SCRIPT_QUESTIONS.SCRIPT_ID | AS_PROMOTIONS_ALL |
| AS_SCRIPT_ANSWER_ACTIONS_ALL.PROMOTION_ID | AS_PROMOTIONS_ALL |
| AS_SCRIPT_PRE_DEFINED_ANSWERS.SCRIPT_ID | AS_PROMOTIONS_ALL |
OSM.AS_PROMOTIONS_ALL does not reference any database object
OSM.AS_PROMOTIONS_ALL is referenced by following:
| Description: | Defines promotion relationships |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_PROMOTION_RELATIONSHIPS.PARENT_PROMOTION_ID | AS_PROMOTIONS_ALL |
| AS_PROMOTION_RELATIONSHIPS.CHILD_PROMOTION_ID | AS_PROMOTIONS_ALL |
OSM.AS_PROMOTION_RELATIONSHIPS does not reference any database object
OSM.AS_PROMOTION_RELATIONSHIPS is referenced by following:
| Description: | Holds scripts linked to promotions |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_PROMOTION_SCRIPTS.SCRIPT_ID | AS_PROMOTIONS_ALL |
| AS_PROMOTION_SCRIPTS.PROMOTION_ID | AS_PROMOTIONS_ALL |
OSM.AS_PROMOTION_SCRIPTS does not reference any database object
OSM.AS_PROMOTION_SCRIPTS is referenced by following:
| Description: |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_QUOTA_PROFILES.PRIMARY_INTEREST_CODE_ID | AS_INTEREST_CODES_B |
| AS_QUOTA_PROFILES.INTEREST_TYPE_ID | AS_INTEREST_TYPES_B |
| AS_QUOTA_PROFILES.SALESFORCE_ID | % |
| AS_QUOTA_PROFILES.SALES_GROUP_ID | % |
OSM.AS_QUOTA_PROFILES does not reference any database object
OSM.AS_QUOTA_PROFILES is referenced by following:
| Description: | Defines quotations |
|---|
OSM.AS_QUOTES_ALL does not reference any database object
OSM.AS_QUOTES_ALL is referenced by following:
| Description: | Holds quotation lines information |
|---|
OSM.AS_QUOTE_LINES_ALL does not reference any database object
OSM.AS_QUOTE_LINES_ALL is referenced by following:
| Description: | Tracks changes of quote status and quote version |
|---|
OSM.AS_QUOTE_STATUS_LOG does not reference any database object
OSM.AS_QUOTE_STATUS_LOG is referenced by following:
| Description: | This table stores relationships between entities. |
|---|
OSM.AS_RELATIONSHIPS does not reference any database object
OSM.AS_RELATIONSHIPS is referenced by following:
| Description: | Denormalized table derived from AS_SALESFORCE. |
|---|
OSM.AS_REPORTING_MANAGERS does not reference any database object
OSM.AS_REPORTING_MANAGERS is referenced by following:
| Description: | Stores Rolling Calendars for Sales Forecasts |
|---|
OSM.AS_ROLLING_CALENDARS does not reference any database object
OSM.AS_ROLLING_CALENDARS is referenced by following:
| Description: | Stores Rolling Periods within rolling calendars for Sales Forecasts |
|---|
OSM.AS_ROLLING_PERIODS does not reference any database object
OSM.AS_ROLLING_PERIODS is referenced by following:
| Description: | Obsolete Defines the salesforce |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_SALESFORCE.PARTNER_CUSTOMER_ID | RA_CUSTOMERS |
| AS_SALESFORCE.PARTNER_ADDRESS_ID | RA_ADDRESSES_ALL |
| AS_SALESFORCE.PARTNER_CONTACT_ID | % |
| AS_SALESFORCE.SALES_GROUP_ID | AS_SALES_GROUPS |
| Foreign Key Column | Foreign Table |
|---|---|
| AS_CHANGED_TERRITORIES_ALL.TRANSFER_TO_SALESFORCE_ID | AS_SALESFORCE |
| AS_TERRITORIES_ALL.SALESFORCE_ID | AS_SALESFORCE |
| RA_SALESREPS_ALL.SALESFORCE_ID | AS_SALESFORCE |
OSM.AS_SALESFORCE does not reference any database object
OSM.AS_SALESFORCE is referenced by following:
| Description: | Defines sales representative jobs |
|---|
OSM.AS_SALESREP_JOBS does not reference any database object
OSM.AS_SALESREP_JOBS is referenced by following:
| Description: | Holds sales credits |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_SALES_CREDITS.LEAD_LINE_ID | AS_LEAD_LINES_ALL |
| AS_SALES_CREDITS.PARTNER_ADDRESS_ID | HZ_PARTY_SITES |
| AS_SALES_CREDITS.PARTNER_CUSTOMER_ID | HZ_PARTIES |
| AS_SALES_CREDITS.SALESFORCE_ID | JTF_RS_RESOURCE_EXTNS |
| AS_SALES_CREDITS.SALESGROUP_ID | JTF_RS_GROUPS_B |
| AS_SALES_CREDITS.LEAD_ID | AS_LEADS_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| AS_SALES_CREDITS_DENORM.SALES_CREDIT_ID | AS_SALES_CREDITS |
OSM.AS_SALES_CREDITS does not reference any database object
OSM.AS_SALES_CREDITS is referenced by following:
| Description: | Denormalized table to store opportunity data denormalized from AS_LEADS_ALL, AS_LEAD_LINES_ALL, AS_SALES_CREDITS, AS_SALES_STAGE_ALL, AS_INTEREST_TYPES_ALL, AS_INTEREST_CODES_ALL, HZ_PARTIES, AS_SALES_GROUPS, PER_ALL_PEOPLR_F |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_SALES_CREDITS_DENORM.SALESFORCE_ID | JTF_RS_RESOURCE_EXTNS |
| AS_SALES_CREDITS_DENORM.WIN_PROBABILITY | AS_FORECAST_PROB_ALL_B |
| AS_SALES_CREDITS_DENORM.INTEREST_TYPE_ID | AS_INTEREST_TYPES_B |
| AS_SALES_CREDITS_DENORM.PRIMARY_INTEREST_CODE_ID | AS_INTEREST_CODES_B |
| AS_SALES_CREDITS_DENORM.SECONDARY_INTEREST_CODE_ID | AS_INTEREST_CODES_B |
| AS_SALES_CREDITS_DENORM.CLOSE_COMPETITOR_ID | HZ_PARTIES |
| AS_SALES_CREDITS_DENORM.PARTNER_CUSTOMER_ID | HZ_PARTIES |
| AS_SALES_CREDITS_DENORM.PARTNER_ADDRESS_ID | HZ_PARTY_SITES |
| AS_SALES_CREDITS_DENORM.SALES_GROUP_ID | JTF_RS_GROUPS_B |
| AS_SALES_CREDITS_DENORM.SALES_CREDIT_ID | AS_SALES_CREDITS |
| AS_SALES_CREDITS_DENORM.CUSTOMER_ID | HZ_PARTIES |
| AS_SALES_CREDITS_DENORM.LEAD_ID | AS_LEADS_ALL |
| AS_SALES_CREDITS_DENORM.LEAD_LINE_ID | AS_LEAD_LINES_ALL |
| AS_SALES_CREDITS_DENORM.SALES_STAGE_ID | AS_SALES_STAGES_ALL_B |
| AS_SALES_CREDITS_DENORM.STATUS_CODE | AS_STATUSES_B |
| AS_SALES_CREDITS_DENORM.ADDRESS_ID | HZ_PARTY_SITES |
| Foreign Key Column | Foreign Table |
|---|---|
| AS_MC_SALES_CREDITS_DEN.SALES_CREDIT_ID | AS_SALES_CREDITS_DENORM |
OSM.AS_SALES_CREDITS_DENORM does not reference any database object
OSM.AS_SALES_CREDITS_DENORM is referenced by following:
| Description: | Holds sales credit change history |
|---|
OSM.AS_SALES_CREDITS_LOG does not reference any database object
OSM.AS_SALES_CREDITS_LOG is referenced by following:
| Description: | Stores adjustments to sales credits. |
|---|
OSM.AS_SALES_CREDIT_ADJS does not reference any database object
OSM.AS_SALES_CREDIT_ADJS is referenced by following:
| Description: | Defines sales groups |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_SALESFORCE.SALES_GROUP_ID | AS_SALES_GROUPS |
OSM.AS_SALES_GROUPS does not reference any database object
OSM.AS_SALES_GROUPS is referenced by following:
| Description: | Denormalized table derived from AS_SALES_GROUPS |
|---|
OSM.AS_SALES_GROUPS_DENORM does not reference any database object
OSM.AS_SALES_GROUPS_DENORM is referenced by following:
| Description: | Defines administrators for sales groups |
|---|
OSM.AS_SALES_GRP_ADMIN does not reference any database object
OSM.AS_SALES_GRP_ADMIN is referenced by following:
| Description: | Holds sales leads |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_SALES_LEADS.STATUS_CODE | AS_STATUSES_B |
| AS_SALES_LEADS.ADDRESS_ID | HZ_PARTY_SITES |
| AS_SALES_LEADS.INCUMBENT_PARTNER_PARTY_ID | HZ_PARTIES |
| AS_SALES_LEADS.ADDRESS_ID | HZ_PARTY_SITES |
| AS_SALES_LEADS.PRIMARY_CONTACT_PHONE_ID | HZ_CONTACT_POINTS |
| AS_SALES_LEADS.PRIMARY_CNT_PERSON_PARTY_ID | HZ_PARTIES |
| AS_SALES_LEADS.ASSIGN_TO_SALESFORCE_ID | JTF_RS_RESOURCE_EXTNS |
| AS_SALES_LEADS.LEAD_RANK_ID | AS_SALES_LEAD_RANKS_B |
| AS_SALES_LEADS.OFFER_ID | AMS_ACT_OFFERS |
| AS_SALES_LEADS.CUSTOMER_ID | HZ_PARTIES |
| AS_SALES_LEADS.CUSTOMER_ID | % |
| AS_SALES_LEADS.SCORECARD_ID | AS_SALES_LEAD_SCORECARDS |
| AS_SALES_LEADS.ASSIGN_SALES_GROUP_ID | JTF_RS_GROUPS_B |
| Foreign Key Column | Foreign Table |
|---|---|
| AML_INTERACTION_LEADS.SALES_LEAD_ID | AS_SALES_LEADS |
| ASO_QUOTE_RELATED_OBJECTS.OBJECT_ID | AS_SALES_LEADS |
| AS_ACCESSES_ALL_ALL.SALES_LEAD_ID | AS_SALES_LEADS |
| AS_CHANGED_ACCOUNTS_ALL.SALES_LEAD_ID | AS_SALES_LEADS |
| AS_SALES_LEAD_CONTACTS.SALES_LEAD_ID | AS_SALES_LEADS |
| AS_SALES_LEADS_LOG.SALES_LEAD_ID | AS_SALES_LEADS |
| AS_SALES_LEAD_CONTACTS.SALES_LEAD_ID | AS_SALES_LEADS |
| AS_SALES_LEAD_LINES.SALES_LEAD_ID | AS_SALES_LEADS |
| AS_SALES_LEAD_OPPORTUNITY.SALES_LEAD_ID | AS_SALES_LEADS |
| IGR_I_APPL_ALL.SALES_LEAD_ID | AS_SALES_LEADS |
| IGS_RC_I_APPL_ALL.SALES_LEAD_ID | AS_SALES_LEADS |
| JTF_NOTES_B.SOURCE_OBJECT_ID | AS_SALES_LEADS |
| JTF_NOTE_CONTEXTS.NOTE_CONTEXT_TYPE_ID | AS_SALES_LEADS |
| PV_REFERRALS_B.ENTITY_ID_LINKED_TO | AS_SALES_LEADS |
| PV_LEAD_PSS_LINES.LEAD_ID | AS_SALES_LEADS |
OSM.AS_SALES_LEADS does not reference any database object
OSM.AS_SALES_LEADS is referenced by following:
| Description: | Holds opportunity change history |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_SALES_LEADS_LOG.SALES_LEAD_ID | AS_SALES_LEADS |
OSM.AS_SALES_LEADS_LOG does not reference any database object
OSM.AS_SALES_LEADS_LOG is referenced by following:
| Description: | Holds the score and description information for a score card rule |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_SALES_LEAD_CARD_RULES.SCORECARD_ID | AS_SALES_LEAD_SCORECARDS |
| Foreign Key Column | Foreign Table |
|---|---|
| AS_CARD_RULE_QUAL_VALUES.CARD_RULE_ID | AS_SALES_LEAD_CARD_RULES |
OSM.AS_SALES_LEAD_CARD_RULES does not reference any database object
OSM.AS_SALES_LEAD_CARD_RULES is referenced by following:
| Description: | Holds contact information for the Lead. Records can be deleted. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_SALES_LEAD_CONTACTS.SALES_LEAD_ID | AS_SALES_LEADS |
| AS_SALES_LEAD_CONTACTS.SALES_LEAD_ID | AS_SALES_LEADS |
| AS_SALES_LEAD_CONTACTS.CONTACT_ID | % |
| AS_SALES_LEAD_CONTACTS.PHONE_ID | HZ_CONTACT_POINTS |
| AS_SALES_LEAD_CONTACTS.CUSTOMER_ID | HZ_PARTIES |
| AS_SALES_LEAD_CONTACTS.ADDRESS_ID | HZ_PARTY_SITES |
OSM.AS_SALES_LEAD_CONTACTS does not reference any database object
OSM.AS_SALES_LEAD_CONTACTS is referenced by following:
| Description: | Holds sales lead lines informaiton |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_SALES_LEAD_LINES.SALES_LEAD_ID | AS_SALES_LEADS |
| AS_SALES_LEAD_LINES.INTEREST_TYPE_ID | AS_INTEREST_TYPES_B |
| AS_SALES_LEAD_LINES.PRIMARY_INTEREST_CODE_ID | AS_INTEREST_CODES_B |
| AS_SALES_LEAD_LINES.SECONDARY_INTEREST_CODE_ID | AS_INTEREST_CODES_B |
|
AS_SALES_LEAD_LINES.INVENTORY_ITEM_ID
AS_SALES_LEAD_LINES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
| AS_SALES_LEAD_LINES.SOURCE_PROMOTION_ID | AMS_SOURCE_CODES |
| AS_SALES_LEAD_LINES.OFFER_ID | AMS_ACT_OFFERS |
| Foreign Key Column | Foreign Table |
|---|---|
| ASO_QUOTE_RELATED_OBJECTS.OBJECT_ID | AS_SALES_LEAD_LINES |
| AS_SALES_LEAD_OPP_LINES.SALES_LEAD_LINE_ID | AS_SALES_LEAD_LINES |
| IGR_I_A_LINES.SALES_LEAD_LINE_ID | AS_SALES_LEAD_LINES |
| IGS_RC_I_A_LINES.SALES_LEAD_LINE_ID | AS_SALES_LEAD_LINES |
OSM.AS_SALES_LEAD_LINES does not reference any database object
OSM.AS_SALES_LEAD_LINES is referenced by following:
| Description: | Holds the linking information between sales leads and opportunity. Records can not be deleted. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_SALES_LEAD_OPPORTUNITY.OPPORTUNITY_ID | AS_LEADS_ALL |
| AS_SALES_LEAD_OPPORTUNITY.SALES_LEAD_ID | AS_SALES_LEADS |
OSM.AS_SALES_LEAD_OPPORTUNITY does not reference any database object
OSM.AS_SALES_LEAD_OPPORTUNITY is referenced by following:
| Description: | Holds the linking information between sales lead linesand opportunity lines |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_SALES_LEAD_OPP_LINES.OPP_LINE_ID | AS_LEAD_LINES_ALL |
| AS_SALES_LEAD_OPP_LINES.SALES_LEAD_LINE_ID | AS_SALES_LEAD_LINES |
OSM.AS_SALES_LEAD_OPP_LINES does not reference any database object
OSM.AS_SALES_LEAD_OPP_LINES is referenced by following:
| Description: | Holds lead owners information |
|---|
OSM.AS_SALES_LEAD_OWNERS does not reference any database object
OSM.AS_SALES_LEAD_OWNERS is referenced by following:
| Description: | Holds information about the columns which are used in scorecard rules |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_CARD_RULE_QUAL_VALUES.SEED_QUAL_ID | AS_SALES_LEAD_QUALS_B |
OSM.AS_SALES_LEAD_QUALS_B does not reference any database object
OSM.AS_SALES_LEAD_QUALS_B is referenced by following:
| Description: | Holds transalation information for multi lingual support |
|---|
OSM.AS_SALES_LEAD_QUALS_TL does not reference any database object
OSM.AS_SALES_LEAD_QUALS_TL is referenced by following:
| Description: | Defines the various ranks a lead can have |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_SALES_LEADS.LEAD_RANK_ID | AS_SALES_LEAD_RANKS_B |
| AS_SALES_LEAD_RANKS_TL.RANK_ID | AS_SALES_LEAD_RANKS_B |
OSM.AS_SALES_LEAD_RANKS_B does not reference any database object
OSM.AS_SALES_LEAD_RANKS_B is referenced by following:
| Description: | Holds transalation information for multi lingual support |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_SALES_LEAD_RANKS_TL.RANK_ID | AS_SALES_LEAD_RANKS_B |
OSM.AS_SALES_LEAD_RANKS_TL does not reference any database object
OSM.AS_SALES_LEAD_RANKS_TL is referenced by following:
| Description: | Holds the score card information |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_CARD_RULE_QUAL_VALUES.SCORECARD_ID | AS_SALES_LEAD_SCORECARDS |
| AS_SALES_LEADS.SCORECARD_ID | AS_SALES_LEAD_SCORECARDS |
| AS_SALES_LEAD_CARD_RULES.SCORECARD_ID | AS_SALES_LEAD_SCORECARDS |
OSM.AS_SALES_LEAD_SCORECARDS does not reference any database object
OSM.AS_SALES_LEAD_SCORECARDS is referenced by following:
| Description: | Holds information about the columns which are used in scorecard rules |
|---|
OSM.AS_SALES_LEAD_SEED_QUAL_B does not reference any database object
OSM.AS_SALES_LEAD_SEED_QUAL_B is referenced by following:
| Description: | Define Sales Methodologies |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_LEADS_ALL.SALES_METHODOLOGY_ID | AS_SALES_METHODOLOGY_B |
| AS_SALES_METHODOLOGY_TL.SALES_METHODOLOGY_ID | AS_SALES_METHODOLOGY_B |
| AS_SALES_METH_STAGE_MAP.SALES_METHODOLOGY_ID | AS_SALES_METHODOLOGY_B |
| AS_SALES_METH_TASK_MAP.SALES_METHODOLOGY_ID | AS_SALES_METHODOLOGY_B |
OSM.AS_SALES_METHODOLOGY_B does not reference any database object
OSM.AS_SALES_METHODOLOGY_B is referenced by following:
| Description: | For MLS - Translated columns of AS_SALES_METHODOLOGY_B |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_SALES_METHODOLOGY_TL.SALES_METHODOLOGY_ID | AS_SALES_METHODOLOGY_B |
OSM.AS_SALES_METHODOLOGY_TL does not reference any database object
OSM.AS_SALES_METHODOLOGY_TL is referenced by following:
| Description: | Table for mapping Sales Stages with Task Template Groups |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_SALES_METH_STAGE_MAP.SALES_STAGE_ID | AS_SALES_STAGES_ALL_B |
| AS_SALES_METH_STAGE_MAP.SALES_METHODOLOGY_ID | AS_SALES_METHODOLOGY_B |
| AS_SALES_METH_STAGE_MAP.TASK_TEMPLATE_GROUP_ID | JTF_TASK_TEMP_GROUPS_B |
| AS_SALES_METH_STAGE_MAP.MIN_WIN_PROBABILITY | AS_FORECAST_PROB_ALL_B |
| AS_SALES_METH_STAGE_MAP.MAX_WIN_PROBABILITY | AS_FORECAST_PROB_ALL_B |
OSM.AS_SALES_METH_STAGE_MAP does not reference any database object
OSM.AS_SALES_METH_STAGE_MAP is referenced by following:
| Description: | Stores information about task created automatically by the sales methodology |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_SALES_METH_TASK_MAP.SALES_METHODOLOGY_ID | AS_SALES_METHODOLOGY_B |
| AS_SALES_METH_TASK_MAP.TASK_ID | JTF_TASKS_B |
| AS_SALES_METH_TASK_MAP.TASK_TEMPLATE_ID | JTF_TASK_TEMPLATES_B |
| AS_SALES_METH_TASK_MAP.TASK_TEMPLATE_GROUP_ID | JTF_TASK_TEMP_GROUPS_B |
OSM.AS_SALES_METH_TASK_MAP does not reference any database object
OSM.AS_SALES_METH_TASK_MAP is referenced by following:
| Description: | Defines sales quotas |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_SALES_QUOTAS.INTEREST_TYPE_ID | AS_INTEREST_TYPES_B |
| AS_SALES_QUOTAS.PARTNER_CUSTOMER_ID | % |
| AS_SALES_QUOTAS.PARTNER_ADDRESS_ID | HZ_PARTY_SITES |
| AS_SALES_QUOTAS.PRIMARY_INTEREST_CODE_ID | AS_INTEREST_CODES_B |
| AS_SALES_QUOTAS.SECONDARY_INTEREST_CODE_ID | AS_INTEREST_CODES_B |
| AS_SALES_QUOTAS.SALESFORCE_ID | % |
| AS_SALES_QUOTAS.SALES_GROUP_ID | % |
| Foreign Key Column | Foreign Table |
|---|---|
| AS_PROD_WORKSHEET_LINES.SALES_QUOTA_ID | AS_SALES_QUOTAS |
OSM.AS_SALES_QUOTAS does not reference any database object
OSM.AS_SALES_QUOTAS is referenced by following:
| Description: | Defines sales stages |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_SALES_STAGES_ALL_B.MAX_WIN_PROBABILITY | AS_FORECAST_PROB_ALL_B |
| AS_SALES_STAGES_ALL_B.MIN_WIN_PROBABILITY | AS_FORECAST_PROB_ALL_B |
| Foreign Key Column | Foreign Table |
|---|---|
| AS_LEADS_ALL.SALES_STAGE_ID | AS_SALES_STAGES_ALL_B |
| AS_LEADS_ALL.SALES_STAGE_ID | AS_SALES_STAGES_ALL_B |
| AS_LEAD_LINES_ALL.SALES_STAGE_ID | AS_SALES_STAGES_ALL_B |
| AS_OPP_WORKSHEET_LINES.SALES_STAGE_ID | AS_SALES_STAGES_ALL_B |
| AS_SALES_CREDITS_DENORM.SALES_STAGE_ID | AS_SALES_STAGES_ALL_B |
| AS_SALES_METH_STAGE_MAP.SALES_STAGE_ID | AS_SALES_STAGES_ALL_B |
| AS_SALES_STAGES_ALL_TL.SALES_STAGE_ID | AS_SALES_STAGES_ALL_B |
OSM.AS_SALES_STAGES_ALL_B does not reference any database object
OSM.AS_SALES_STAGES_ALL_B is referenced by following:
| Description: | For MLS - Translated columns of AS_SALES_STAGES_ALL_B |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_SALES_STAGES_ALL_TL.SALES_STAGE_ID | AS_SALES_STAGES_ALL_B |
OSM.AS_SALES_STAGES_ALL_TL does not reference any database object
OSM.AS_SALES_STAGES_ALL_TL is referenced by following:
| Description: | Holds answers for script questions |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_SCRIPT_ACTUAL_ANSWERS.PRE_DEF_ANSWER_ID | AS_SCRIPT_PRE_DEFINED_ANSWERS |
| AS_SCRIPT_ACTUAL_ANSWERS.QUESTION_ID | AS_SCRIPT_QUESTIONS |
| AS_SCRIPT_ACTUAL_ANSWERS.CONTACT_ID | % |
| AS_SCRIPT_ACTUAL_ANSWERS.CUSTOMER_ID | RA_CUSTOMERS |
| AS_SCRIPT_ACTUAL_ANSWERS.ADDRESS_ID | RA_SITE_USES_ALL |
OSM.AS_SCRIPT_ACTUAL_ANSWERS does not reference any database object
OSM.AS_SCRIPT_ACTUAL_ANSWERS is referenced by following:
| Description: | Holds actions resulting from script answers |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_SCRIPT_ANSWER_ACTIONS_ALL.PRE_DEF_ANSWER_ID | AS_SCRIPT_PRE_DEFINED_ANSWERS |
| AS_SCRIPT_ANSWER_ACTIONS_ALL.PROMOTION_ID | AS_PROMOTIONS_ALL |
|
AS_SCRIPT_ANSWER_ACTIONS_ALL.INVENTORY_ITEM_ID
AS_SCRIPT_ANSWER_ACTIONS_ALL.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
OSM.AS_SCRIPT_ANSWER_ACTIONS_ALL does not reference any database object
OSM.AS_SCRIPT_ANSWER_ACTIONS_ALL is referenced by following:
| Description: | Defines answers to script questions |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_SCRIPT_PRE_DEFINED_ANSWERS.QUESTION_ID | AS_SCRIPT_QUESTIONS |
| AS_SCRIPT_PRE_DEFINED_ANSWERS.SCRIPT_ID | AS_PROMOTIONS_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| AS_SCRIPT_ACTUAL_ANSWERS.PRE_DEF_ANSWER_ID | AS_SCRIPT_PRE_DEFINED_ANSWERS |
| AS_SCRIPT_ANSWER_ACTIONS_ALL.PRE_DEF_ANSWER_ID | AS_SCRIPT_PRE_DEFINED_ANSWERS |
OSM.AS_SCRIPT_PRE_DEFINED_ANSWERS does not reference any database object
OSM.AS_SCRIPT_PRE_DEFINED_ANSWERS is referenced by following:
| Description: | Defines script questions |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_SCRIPT_QUESTIONS.SCRIPT_ID | AS_PROMOTIONS_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| AS_SCRIPT_ACTUAL_ANSWERS.QUESTION_ID | AS_SCRIPT_QUESTIONS |
| AS_SCRIPT_PRE_DEFINED_ANSWERS.QUESTION_ID | AS_SCRIPT_QUESTIONS |
OSM.AS_SCRIPT_QUESTIONS does not reference any database object
OSM.AS_SCRIPT_QUESTIONS is referenced by following:
| Description: | OBSOLETE |
|---|
OSM.AS_SERVERS does not reference any database object
OSM.AS_SERVERS is referenced by following:
| Description: | Hold three types of status, opportunity, lead and quote |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_LEADS_ALL.STATUS | AS_STATUSES_B |
| AS_OPP_WORKSHEET_LINES.STATUS | AS_STATUSES_B |
| AS_SALES_LEADS.STATUS_CODE | AS_STATUSES_B |
| AS_SALES_CREDITS_DENORM.STATUS_CODE | AS_STATUSES_B |
| AS_STATUSES_TL.STATUS_CODE | AS_STATUSES_B |
| PV_ALLOWED_STATUSES.TO_STATUS_CODE | AS_STATUSES_B |
| PV_ALLOWED_STATUSES.FROM_STATUS_CODE | AS_STATUSES_B |
OSM.AS_STATUSES_B does not reference any database object
OSM.AS_STATUSES_B is referenced by following:
| Description: | For MLS, Translated columns of AS_STATUSES_B |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_STATUSES_TL.STATUS_CODE | AS_STATUSES_B |
OSM.AS_STATUSES_TL does not reference any database object
OSM.AS_STATUSES_TL is referenced by following:
| Description: | The working table for TAP purge program |
|---|
OSM.AS_TAP_PURGE_WORKING does not reference any database object
OSM.AS_TAP_PURGE_WORKING is referenced by following:
| Description: | Obsolete Sales out to JTF Terr Core -- Holds territory definitions |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_TERRITORIES_ALL.TERRITORY_TYPE_ID | AS_TERRITORY_TYPES_ALL |
| AS_TERRITORIES_ALL.SALESFORCE_ID | AS_SALESFORCE |
| AS_TERRITORIES_ALL.TERRITORY_GROUP_ID | AS_TERRITORY_GROUPS_ALL |
| AS_TERRITORIES_ALL.EXPANDED_FROM_TERR_ID | AS_TERRITORIES_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| AS_CHANGED_TERRITORIES_ALL.TERRITORY_ID | AS_TERRITORIES_ALL |
| AS_TERRITORIES_ALL.EXPANDED_FROM_TERR_ID | AS_TERRITORIES_ALL |
| AS_TERRITORY_ROLLUPS.TERRITORY_ID | AS_TERRITORIES_ALL |
| AS_TERRITORY_ROLLUPS.ROLLUP_TERRITORY_ID | AS_TERRITORIES_ALL |
OSM.AS_TERRITORIES_ALL does not reference any database object
OSM.AS_TERRITORIES_ALL is referenced by following:
| Description: | Defines territory accesses |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_TERRITORY_ACCESSES.TERRITORY_ID | JTF_TERR_ALL |
| AS_TERRITORY_ACCESSES.ACCESS_ID | AS_ACCESSES_ALL_ALL |
OSM.AS_TERRITORY_ACCESSES does not reference any database object
OSM.AS_TERRITORY_ACCESSES is referenced by following:
| Description: |
|---|
OSM.AS_TERRITORY_ACC_PURGE_TEMP does not reference any database object
OSM.AS_TERRITORY_ACC_PURGE_TEMP is referenced by following:
| Description: | Obsolete Defines territory groups |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_TERRITORIES_ALL.TERRITORY_GROUP_ID | AS_TERRITORY_GROUPS_ALL |
| AS_TERRITORY_TYPES_ALL.TERRITORY_GROUP_ID | AS_TERRITORY_GROUPS_ALL |
| AS_TERRITORY_TYPES_ALL.TERRITORY_GROUP_ID | AS_TERRITORY_GROUPS_ALL |
OSM.AS_TERRITORY_GROUPS_ALL does not reference any database object
OSM.AS_TERRITORY_GROUPS_ALL is referenced by following:
| Description: | Defines rollup territories |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_TERRITORY_ROLLUPS.TERRITORY_ID | AS_TERRITORIES_ALL |
| AS_TERRITORY_ROLLUPS.ROLLUP_TERRITORY_ID | AS_TERRITORIES_ALL |
OSM.AS_TERRITORY_ROLLUPS does not reference any database object
OSM.AS_TERRITORY_ROLLUPS is referenced by following:
| Description: | Obsolete To JTF Terr Core Defines territory types |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_TERRITORY_TYPES_ALL.TERRITORY_GROUP_ID | AS_TERRITORY_GROUPS_ALL |
| AS_TERRITORY_TYPES_ALL.TERRITORY_GROUP_ID | AS_TERRITORY_GROUPS_ALL |
| Foreign Key Column | Foreign Table |
|---|---|
| AS_TERRITORIES_ALL.TERRITORY_TYPE_ID | AS_TERRITORY_TYPES_ALL |
| AS_TERR_TYPE_QUALIFIERS.TERRITORY_TYPE_ID | AS_TERRITORY_TYPES_ALL |
OSM.AS_TERRITORY_TYPES_ALL does not reference any database object
OSM.AS_TERRITORY_TYPES_ALL is referenced by following:
| Description: | Obsolete To JTF Terr Core Holds territory values |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
|
AS_TERRITORY_VALUES_ALL.INVENTORY_ITEM_ID
AS_TERRITORY_VALUES_ALL.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
| AS_TERRITORY_VALUES_ALL.CUSTOMER_ID | RA_CUSTOMERS |
| AS_TERRITORY_VALUES_ALL.ADDRESS_ID | RA_ADDRESSES_ALL |
| AS_TERRITORY_VALUES_ALL.INTEREST_TYPE_ID | AS_INTEREST_TYPES_ALL |
| AS_TERRITORY_VALUES_ALL.PRIMARY_INTEREST_CODE_ID | AS_INTEREST_CODES_ALL |
| AS_TERRITORY_VALUES_ALL.SECONDARY_INTEREST_CODE_ID | AS_INTEREST_CODES_ALL |
|
AS_TERRITORY_VALUES_ALL.INVENTORY_ITEM_ID
AS_TERRITORY_VALUES_ALL.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
OSM.AS_TERRITORY_VALUES_ALL does not reference any database object
OSM.AS_TERRITORY_VALUES_ALL is referenced by following:
| Description: | Hold territory assignment results. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_TERR_RESOURCES_TMP.PARTY_ID | HZ_PARTIES |
| AS_TERR_RESOURCES_TMP.PARTY_SITE_ID | HZ_PARTY_SITES |
| AS_TERR_RESOURCES_TMP.LEAD_ID | AS_LEADS_ALL |
| AS_TERR_RESOURCES_TMP.TERR_ID | JTF_TERR_ALL |
| AS_TERR_RESOURCES_TMP.RESOURCE_ID | JTF_RS_RESOURCE_EXTNS |
| AS_TERR_RESOURCES_TMP.RESOURCE_GROUP_ID | JTF_RS_GROUPS_B |
OSM.AS_TERR_RESOURCES_TMP does not reference any database object
OSM.AS_TERR_RESOURCES_TMP is referenced by following:
| Description: | Temporary table used by the Territory program |
|---|
OSM.AS_TERR_ROLLUPS_IMMEDIATE_TMP does not reference any database object
OSM.AS_TERR_ROLLUPS_IMMEDIATE_TMP is referenced by following:
| Description: | Defines qualifiers for territory definitions |
|---|
OSM.AS_TERR_SEEDED_QUALIFIERS_ALL does not reference any database object
OSM.AS_TERR_SEEDED_QUALIFIERS_ALL is referenced by following:
| Description: | Holds territory type and qualifier combinations |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| AS_TERR_TYPE_QUALIFIERS.TERRITORY_TYPE_ID | AS_TERRITORY_TYPES_ALL |
OSM.AS_TERR_TYPE_QUALIFIERS does not reference any database object
OSM.AS_TERR_TYPE_QUALIFIERS is referenced by following:
| Description: | Obsolete Holds activities for sales representatives |
|---|
OSM.AS_TODO_LISTS_ALL does not reference any database object
OSM.AS_TODO_LISTS_ALL is referenced by following:
| Description: | For Lead Sharing use |
|---|
OSM.AS_TRANSFER_DETAILS does not reference any database object
OSM.AS_TRANSFER_DETAILS is referenced by following:
| Description: | For Lead Sharing use |
|---|
OSM.AS_TRANSFER_QUES does not reference any database object
OSM.AS_TRANSFER_QUES is referenced by following:
| Description: | Defines word replacement rules for Fuzzy Find functionality |
|---|
OSM.AS_WORD_REPLACEMENTS does not reference any database object
OSM.AS_WORD_REPLACEMENTS is referenced by following:
| Description: | - Retrofitted |
|---|
HR.HR_ALL_ORGANIZATION_UNITS does not reference any database object
HR.HR_ALL_ORGANIZATION_UNITS is referenced by following:
APPS.AS_ACCESSES is not referenced by any database object
APPS.AS_ACCESSES_ACTIVE_V is not referenced by any database object
APPS.AS_ACCESS_TERRITORIES_SUM_V is not referenced by any database object
APPS.AS_CHANGED_ACCOUNTS is not referenced by any database object
APPS.AS_COLLATERAL_CAT is not referenced by any database object
APPS.AS_COLLATERAL_KITS is not referenced by any database object
APPS.AS_COLLATERAL_REQ is not referenced by any database object
APPS.AS_CURRENT_ENVIRONMENT_V is not referenced by any database object
APPS.AS_EVENT_LETTERS is not referenced by any database object
APPS.AS_EVENT_NAMES is not referenced by any database object
APPS.AS_EXCHANGES_VL is not referenced by any database object
APPS.AS_FC_SALESFORCE_V is not referenced by any database object
APPS.AS_FC_SALES_GROUPS_V is not referenced by any database object
APPS.AS_FORECAST_PROB is not referenced by any database object
APPS.AS_FORECAST_PROB_VL is not referenced by any database object
APPS.AS_FST_SALES_CATEGORIES_V is not referenced by any database object
APPS.AS_FUNDS_VL is not referenced by any database object
APPS.AS_FUND_CONTACTS_V is not referenced by any database object
APPS.AS_FUND_DETAILS_V is not referenced by any database object
APPS.AS_FUND_ISSUES_V is not referenced by any database object
APPS.AS_IMP_SL_V is not referenced by any database object
APPS.AS_INTERESTS_V is not referenced by any database object
APPS.AS_INTEREST_CATEGORY_SETS is not referenced by any database object
APPS.AS_INTEREST_CATEGORY_SETS_V is not referenced by any database object
APPS.AS_INTEREST_CODES_MC_V is not referenced by any database object
APPS.AS_INTEREST_STATUSES_ACTIVE_V is not referenced by any database object
APPS.AS_INTEREST_STATUSES_V is not referenced by any database object
APPS.AS_INTEREST_TYPES is not referenced by any database object
APPS.AS_INV_ITEM_LOV_V is not referenced by any database object
APPS.AS_INV_UOM_V is not referenced by any database object
APPS.AS_ISSUES_VL is not referenced by any database object
APPS.AS_ISSUE_GROUPS_VL is not referenced by any database object
APPS.AS_ISSUE_GROUP_DETAILS_V is not referenced by any database object
APPS.AS_ISSUE_GROUP_ISSUES_V is not referenced by any database object
APPS.AS_ISSUE_GROUP_PARTIES_V is not referenced by any database object
APPS.AS_ISSUE_LISTING_VL is not referenced by any database object
APPS.AS_LANGUAGES_ACTIVE_V is not referenced by any database object
APPS.AS_LEADS is not referenced by any database object
APPS.AS_LEAD_CONTACTS is not referenced by any database object
APPS.AS_LEAD_LINES is not referenced by any database object
APPS.AS_LISTS is not referenced by any database object
APPS.AS_LOOKUP_TYPES is not referenced by any database object
APPS.AS_L_SITES_ACTIVE_V is not referenced by any database object
APPS.AS_MC_TYPE_MAPPINGS_V is not referenced by any database object
APPS.AS_OPPORTUNITIES_V is not referenced by any database object
APPS.AS_OPPORTUNITY_COMPETITORS_V is not referenced by any database object
APPS.AS_OPPORTUNITY_CONTACTS is not referenced by any database object
APPS.AS_OPPORTUNITY_CONTACTS_V is not referenced by any database object
APPS.AS_OPPORTUNITY_DETAILS_V is not referenced by any database object
APPS.AS_OPPORTUNITY_LINES_V is not referenced by any database object
APPS.AS_OPPORTUNITY_OBSTACLES_V is not referenced by any database object
APPS.AS_OPPORTUNITY_ORDERS_V is not referenced by any database object
APPS.AS_OPP_CLASSIFICATION_V is not referenced by any database object
APPS.AS_PARTY_ORG_CONTACTS_V is not referenced by any database object
APPS.AS_PARTY_PHONES_V is not referenced by any database object
APPS.AS_PARTY_RELATIONSHIPS_V is not referenced by any database object
APPS.AS_PERIOD_RATES_V is not referenced by any database object
APPS.AS_PERSONS_ACTIVE_V is not referenced by any database object
APPS.AS_PE_INT_CATEGORIES_V is not referenced by any database object
APPS.AS_PRICE_LISTS_V is not referenced by any database object
APPS.AS_PRIMARY_INTERESTS_ACTIVE_V is not referenced by any database object
APPS.AS_RPT_ADMINS_V is not referenced by any database object
APPS.AS_RPT_MANAGERS_V is not referenced by any database object
APPS.AS_SALESFORCE_SUB_V is not referenced by any database object
APPS.AS_SALESFORCE_V is not referenced by any database object
APPS.AS_SALESGROUP_SUB_V is not referenced by any database object
APPS.AS_SALES_CREDITS_V is not referenced by any database object
APPS.AS_SALES_GROUPS_V is not referenced by any database object
APPS.AS_SALES_GRP_DENORM_V is not referenced by any database object
APPS.AS_SALES_LEADS_V is not referenced by any database object
APPS.AS_SALES_LEAD_CONTACTS_V is not referenced by any database object
APPS.AS_SALES_LEAD_LINES_V is not referenced by any database object
APPS.AS_SALES_LEAD_QUALS_VL is not referenced by any database object
APPS.AS_SALES_LEAD_RANKS_VL is not referenced by any database object
APPS.AS_SALES_LEAD_UWQ_V is not referenced by any database object
APPS.AS_SALES_METHODOLOGY_VL is not referenced by any database object
APPS.AS_SALES_OPP_UWQ_V is not referenced by any database object
APPS.AS_SALES_STAGES is not referenced by any database object
APPS.AS_SALES_STAGES_ALL_VL is not referenced by any database object
APPS.AS_SALES_STAGES_VL is not referenced by any database object
APPS.AS_SALES_TEAM_DISTINCT_V is not referenced by any database object
APPS.AS_SALES_TEAM_EMP_V is not referenced by any database object
APPS.AS_SALES_TEAM_PTR_V is not referenced by any database object
APPS.AS_SCORECARD_RULES_V is not referenced by any database object
APPS.AS_SECOND_INTERESTS_ACTIVE_V is not referenced by any database object
APPS.AS_SF_PTR_V is not referenced by any database object
APPS.AS_SG_ACTIVE_MGR_V is not referenced by any database object
APPS.AS_SITE_CLASSIFICATION_V is not referenced by any database object
APPS.AS_TAP_ACCOUNTS_V is not referenced by any database object
APPS.AS_TAP_LEADS_V is not referenced by any database object
APPS.AS_TAP_OPPORTUNITIES_V is not referenced by any database object
APPS.AS_TERRITORIES_V is not referenced by any database object
APPS.AS_TERRITORY_ACCESSES_V is not referenced by any database object
|
|
|
| Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |