eTRM uses javascript that opens and focuses a separate window to display reports.
Your browser does not appear to support javascript. This should not prevent you from using
eTRM but it does mean the window focus feature will not work. Please check the contents of
other windows on your desktop if you click on a link that does not appear to do anything.
Oracle eBusiness Suite Technical Reference
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®,
OracleDevConnect SM, Oracle® Discoverer™,
Oracle® Expert™, Oracle Financials®, OracleGOLD SM,
OracleIncident SM, OracleJSP™,
OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURY SM,
OracleMetaLink SM, Oraclemetals SM, OracleMobile™, Oracle Names®,
Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®,
Oracle OpenWorld®, OraclePLATINUM SM,
Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®,
Oracle Quality®, Oracle Secure Network Services®, OracleSILVER SM,
Oracle® SQL/Services™, Oracle® SQL*TutorSM,
OracleSTERLING SM, 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 - AS Tables and Views
TABLE - OSM.AS_ACCESSES_ALL_ALL
TABLE - OSM.AS_ACCESSES_PURGE_TEMP
TABLE - OSM.AS_ACCOUNT_QUAL_VALUES_ALL
TABLE - OSM.AS_AP_ACCOUNT_PLANS
TABLE - OSM.AS_AP_BUSINESS_DRIVERS
TABLE - OSM.AS_AP_STRTGC_OBJECTIVES
TABLE - OSM.AS_AP_TRACKING_OBJECTIVES
TABLE - OSM.AS_CARD_RULE_QUAL_VALUES
TABLE - OSM.AS_CATEGORIES_ALL
TABLE - OSM.AS_CHANGED_ACCOUNTS_ALL
TABLE - OSM.AS_CHANGED_TERRITORIES_ALL
TABLE - OSM.AS_COLLATERAL_CAT_ALL
TABLE - OSM.AS_COLLATERAL_KITS_ALL
TABLE - OSM.AS_COLLATERAL_REQ_ALL
TABLE - OSM.AS_COLLATERAL_REQ_ITEMS
TABLE - OSM.AS_CONC_REQUEST_MESSAGES
TABLE - OSM.AS_CONTACT_EDUCATION
TABLE - OSM.AS_CONTACT_ENTER
TABLE - OSM.AS_CONTACT_FAMILY
TABLE - OSM.AS_CONTACT_HOBBIES
TABLE - OSM.AS_CONTACT_JOB_HISTORY
TABLE - OSM.AS_CONTACT_MILITARY
TABLE - OSM.AS_CONTACT_PREFERENCES
TABLE - OSM.AS_CONTACT_SPORTS
TABLE - OSM.AS_CONTACT_TRAITS
TABLE - OSM.AS_COUNTRY_PHONES
TABLE - OSM.AS_CURRENT_ENVIRONMENT
TABLE - OSM.AS_CUST_PROFILES
TABLE - OSM.AS_DEFAULT_PURCHASES_ALL
TABLE - OSM.AS_EVENT_DATA
TABLE - OSM.AS_EVENT_ENROLLMENTS_ALL
TABLE - OSM.AS_EVENT_FACILITIES_ALL
TABLE - OSM.AS_EVENT_FAC_ROOMS
TABLE - OSM.AS_EVENT_FAC_STAFF
TABLE - OSM.AS_EVENT_LETTERS_ALL
TABLE - OSM.AS_EVENT_NAMES_ALL
TABLE - OSM.AS_EVENT_NAME_REQUIREMENTS
TABLE - OSM.AS_EVENT_PERSONNEL
TABLE - OSM.AS_EXCHANGES_B
TABLE - OSM.AS_EXCHANGES_TL
TABLE - OSM.AS_FORECASTS
TABLE - OSM.AS_FORECAST_ACTUALS
TABLE - OSM.AS_FORECAST_CATEGORIES_B
TABLE - OSM.AS_FORECAST_CATEGORIES_TL
TABLE - OSM.AS_FORECAST_CAT_DEN
TABLE - OSM.AS_FORECAST_PROB_ALL_B
TABLE - OSM.AS_FORECAST_PROB_ALL_TL
TABLE - OSM.AS_FORECAST_WORKSHEETS
TABLE - OSM.AS_FST_SALES_CATEGORIES
TABLE - OSM.AS_FUNDS_B
TABLE - OSM.AS_FUNDS_TL
TABLE - OSM.AS_FUND_CONTACTS
TABLE - OSM.AS_GROUP_ISSUE_MAP
TABLE - OSM.AS_GROUP_PARTY_MAP
TABLE - OSM.AS_HZ_CLASS_CODE_DENORM
TABLE - OSM.AS_IMPORT_INTERFACE
TABLE - OSM.AS_IMP_CNT_PNT_INTERFACE
TABLE - OSM.AS_IMP_CNT_ROL_INTERFACE
TABLE - OSM.AS_IMP_LINES_INTERFACE
TABLE - OSM.AS_IMP_SL_FLEX
TABLE - OSM.AS_INTERESTS_ALL
TABLE - OSM.AS_INTEREST_CATEGORY_SETS_ALL
TABLE - OSM.AS_INTEREST_CODES_ALL
TABLE - OSM.AS_INTEREST_CODES_B
TABLE - OSM.AS_INTEREST_CODES_MC
TABLE - OSM.AS_INTEREST_CODES_TL
TABLE - OSM.AS_INTEREST_STATUSES
TABLE - OSM.AS_INTEREST_TYPES_ALL
TABLE - OSM.AS_INTEREST_TYPES_B
TABLE - OSM.AS_INTEREST_TYPES_TL
TABLE - OSM.AS_INTERNAL_FORECASTS
TABLE - OSM.AS_INVALID_ADDR
TABLE - OSM.AS_ISSUER
TABLE - OSM.AS_ISSUES_B
TABLE - OSM.AS_ISSUES_TL
TABLE - OSM.AS_ISSUE_GROUPS_B
TABLE - OSM.AS_ISSUE_GROUPS_TL
TABLE - OSM.AS_ISSUE_GROUP_IDFR
TABLE - OSM.AS_ISSUE_GROUP_TYPES
TABLE - OSM.AS_ISSUE_LISTING_B
TABLE - OSM.AS_ISSUE_LISTING_IDFR
TABLE - OSM.AS_ISSUE_LISTING_TL
TABLE - OSM.AS_ISSUE_RELATIONSHIPS
TABLE - OSM.AS_LAST_RUN_DATES
TABLE - OSM.AS_LEADS_ALL
TABLE - OSM.AS_LEADS_LOG
TABLE - OSM.AS_LEAD_ADJS
TABLE - OSM.AS_LEAD_COMPETITORS
TABLE - OSM.AS_LEAD_COMP_PRODUCTS
TABLE - OSM.AS_LEAD_CONTACTS_ALL
TABLE - OSM.AS_LEAD_DECISION_FACTORS
TABLE - OSM.AS_LEAD_IMPORT_ERRORS
TABLE - OSM.AS_LEAD_LINES_ALL
TABLE - OSM.AS_LEAD_LINES_LOG
TABLE - OSM.AS_LEAD_LINE_ADJS
TABLE - OSM.AS_LEAD_OBSTACLES
TABLE - OSM.AS_LEAD_ORDERS
TABLE - OSM.AS_LETS_PARTNER_MAP
TABLE - OSM.AS_LISTS_ALL
TABLE - OSM.AS_LIST_ENTRIES
TABLE - OSM.AS_LIST_ENTRY_USAGES
TABLE - OSM.AS_LIST_QUERIES
TABLE - OSM.AS_LIST_RULES
TABLE - OSM.AS_LIST_RULE_ENTRIES
TABLE - OSM.AS_LLOG_STATUS_SUMMARY
TABLE - OSM.AS_LS_ERRS
TABLE - OSM.AS_MC_REPORTING_CURR
TABLE - OSM.AS_MC_SALES_CREDITS_DEN
TABLE - OSM.AS_MC_TYPE_MAPPINGS
TABLE - OSM.AS_MERGE_FILES_ALL
TABLE - OSM.AS_METH_STAGE_INSTANCES
TABLE - OSM.AS_METH_STEP_INSTANCES
TABLE - OSM.AS_MRP_FCT_DETAIL
TABLE - OSM.AS_MRP_FCT_REPORT
TABLE - OSM.AS_MRP_INTERFACE
TABLE - OSM.AS_MRP_INTERFACE_LINES
TABLE - OSM.AS_MRP_OPP_REPORT
TABLE - OSM.AS_OBJECT_ATTRIBUTES
TABLE - OSM.AS_OPP_WORKSHEET_LINES
TABLE - OSM.AS_OSI_CONS_CCS_BASE
TABLE - OSM.AS_OSI_CONTR_NAMES_BASE
TABLE - OSM.AS_OSI_CONTR_VHCL_BASE
TABLE - OSM.AS_OSI_LEADS_ALL
TABLE - OSM.AS_OSI_LEADS_DENORM
TABLE - OSM.AS_OSI_LEAD_OVL_ALL
TABLE - OSM.AS_OSI_LOOKUP
TABLE - OSM.AS_OSI_OVERLAY_BASE
TABLE - OSM.AS_PARTNER_ACCESSES
TABLE - OSM.AS_PARTNER_LEAD_CONTACTS
TABLE - OSM.AS_PARTNER_LEAD_LINES
TABLE - OSM.AS_PARTNER_LEAD_NOTES
TABLE - OSM.AS_PARTNER_MAP
TABLE - OSM.AS_PERIOD_DAYS
TABLE - OSM.AS_PERIOD_RATES
TABLE - OSM.AS_PE_INT_CATEGORIES
TABLE - OSM.AS_PHONE_FORMATS
TABLE - OSM.AS_PRICE_LISTS
TABLE - OSM.AS_PRICE_LIST_GROUPS
TABLE - OSM.AS_PRODUCT_FILTERS
TABLE - OSM.AS_PROD_WORKSHEET_LINES
TABLE - OSM.AS_PROMOTIONS_ALL
TABLE - OSM.AS_PROMOTION_RELATIONSHIPS
TABLE - OSM.AS_PROMOTION_SCRIPTS
TABLE - OSM.AS_QUOTA_PROFILES
TABLE - OSM.AS_QUOTES_ALL
TABLE - OSM.AS_QUOTE_LINES_ALL
TABLE - OSM.AS_QUOTE_STATUS_LOG
TABLE - OSM.AS_RELATIONSHIPS
TABLE - OSM.AS_REPORTING_MANAGERS
TABLE - OSM.AS_ROLLING_CALENDARS
TABLE - OSM.AS_ROLLING_PERIODS
TABLE - OSM.AS_SALESFORCE
TABLE - OSM.AS_SALESREP_JOBS
TABLE - OSM.AS_SALES_CREDITS
TABLE - OSM.AS_SALES_CREDITS_DENORM
TABLE - OSM.AS_SALES_CREDITS_LOG
TABLE - OSM.AS_SALES_CREDIT_ADJS
TABLE - OSM.AS_SALES_GROUPS
TABLE - OSM.AS_SALES_GROUPS_DENORM
TABLE - OSM.AS_SALES_GRP_ADMIN
TABLE - OSM.AS_SALES_LEADS
TABLE - OSM.AS_SALES_LEADS_LOG
TABLE - OSM.AS_SALES_LEAD_CARD_RULES
TABLE - OSM.AS_SALES_LEAD_CONTACTS
TABLE - OSM.AS_SALES_LEAD_LINES
TABLE - OSM.AS_SALES_LEAD_OPPORTUNITY
TABLE - OSM.AS_SALES_LEAD_OPP_LINES
TABLE - OSM.AS_SALES_LEAD_OWNERS
TABLE - OSM.AS_SALES_LEAD_QUALS_B
TABLE - OSM.AS_SALES_LEAD_QUALS_TL
TABLE - OSM.AS_SALES_LEAD_RANKS_B
TABLE - OSM.AS_SALES_LEAD_RANKS_TL
TABLE - OSM.AS_SALES_LEAD_SCORECARDS
TABLE - OSM.AS_SALES_LEAD_SEED_QUAL_B
TABLE - OSM.AS_SALES_METHODOLOGY_B
TABLE - OSM.AS_SALES_METHODOLOGY_TL
TABLE - OSM.AS_SALES_METH_STAGE_MAP
TABLE - OSM.AS_SALES_METH_TASK_MAP
TABLE - OSM.AS_SALES_QUOTAS
TABLE - OSM.AS_SALES_STAGES_ALL_B
TABLE - OSM.AS_SALES_STAGES_ALL_TL
TABLE - OSM.AS_SCRIPT_ACTUAL_ANSWERS
TABLE - OSM.AS_SCRIPT_ANSWER_ACTIONS_ALL
TABLE - OSM.AS_SCRIPT_PRE_DEFINED_ANSWERS
TABLE - OSM.AS_SCRIPT_QUESTIONS
TABLE - OSM.AS_SERVERS
TABLE - OSM.AS_STATUSES_B
TABLE - OSM.AS_STATUSES_TL
TABLE - OSM.AS_TAP_PURGE_WORKING
TABLE - OSM.AS_TERRITORIES_ALL
TABLE - OSM.AS_TERRITORY_ACCESSES
TABLE - OSM.AS_TERRITORY_ACC_PURGE_TEMP
TABLE - OSM.AS_TERRITORY_GROUPS_ALL
TABLE - OSM.AS_TERRITORY_ROLLUPS
TABLE - OSM.AS_TERRITORY_TYPES_ALL
TABLE - OSM.AS_TERRITORY_VALUES_ALL
TABLE - OSM.AS_TERR_RESOURCES_TMP
TABLE - OSM.AS_TERR_ROLLUPS_IMMEDIATE_TMP
TABLE - OSM.AS_TERR_SEEDED_QUALIFIERS_ALL
TABLE - OSM.AS_TERR_TYPE_QUALIFIERS
TABLE - OSM.AS_TODO_LISTS_ALL
TABLE - OSM.AS_TRANSFER_DETAILS
TABLE - OSM.AS_TRANSFER_QUES
TABLE - OSM.AS_WORD_REPLACEMENTS
TABLE - HR.HR_ALL_ORGANIZATION_UNITS
VIEW - APPS.AS_ACCESSES
VIEW - APPS.AS_ACCESSES_ACTIVE_V
VIEW - APPS.AS_ACCESSES_ALL
VIEW - APPS.AS_ACCESS_TERRITORIES_SUM_V
VIEW - APPS.AS_CHANGED_ACCOUNTS
VIEW - APPS.AS_COLLATERAL_CAT
VIEW - APPS.AS_COLLATERAL_KITS
VIEW - APPS.AS_COLLATERAL_REQ
VIEW - APPS.AS_CURRENT_ENVIRONMENT_V
VIEW - APPS.AS_EVENT_FACILITIES
VIEW - APPS.AS_EVENT_LETTERS
VIEW - APPS.AS_EVENT_NAMES
VIEW - APPS.AS_EXCHANGES_VL
VIEW - APPS.AS_FC_SALESFORCE_V
VIEW - APPS.AS_FC_SALES_GROUPS_V
VIEW - APPS.AS_FORECAST_CATEGORIES_VL
VIEW - APPS.AS_FORECAST_PROB
VIEW - APPS.AS_FORECAST_PROB_ALL_VL
VIEW - APPS.AS_FORECAST_PROB_VL
VIEW - APPS.AS_FST_SALES_CATEGORIES_V
VIEW - APPS.AS_FUNDS_VL
VIEW - APPS.AS_FUND_CONTACTS_V
VIEW - APPS.AS_FUND_DETAILS_V
VIEW - APPS.AS_FUND_ISSUES_V
VIEW - APPS.AS_IMP_SL_V
VIEW - APPS.AS_INTERESTS
VIEW - APPS.AS_INTERESTS_V
VIEW - APPS.AS_INTEREST_CATEGORY_SETS
VIEW - APPS.AS_INTEREST_CATEGORY_SETS_V
VIEW - APPS.AS_INTEREST_CODES_MC_V
VIEW - APPS.AS_INTEREST_CODES_V
VIEW - APPS.AS_INTEREST_CODES_VL
VIEW - APPS.AS_INTEREST_STATUSES_ACTIVE_V
VIEW - APPS.AS_INTEREST_STATUSES_V
VIEW - APPS.AS_INTEREST_TYPES
VIEW - APPS.AS_INTEREST_TYPES_V
VIEW - APPS.AS_INTEREST_TYPES_VL
VIEW - APPS.AS_INV_ITEM_LOV_V
VIEW - APPS.AS_INV_UOM_V
VIEW - APPS.AS_ISSUES_VL
VIEW - APPS.AS_ISSUE_GROUPS_VL
VIEW - APPS.AS_ISSUE_GROUP_DETAILS_V
VIEW - APPS.AS_ISSUE_GROUP_ISSUES_V
VIEW - APPS.AS_ISSUE_GROUP_PARTIES_V
VIEW - APPS.AS_ISSUE_LISTING_VL
VIEW - APPS.AS_LANGUAGES_ACTIVE_V
VIEW - APPS.AS_LEADS
VIEW - APPS.AS_LEAD_CONTACTS
VIEW - APPS.AS_LEAD_LINES
VIEW - APPS.AS_LISTS
VIEW - APPS.AS_LOOKUPS
VIEW - APPS.AS_LOOKUP_TYPES
VIEW - APPS.AS_L_SITES_ACTIVE_V
VIEW - APPS.AS_MC_TYPE_MAPPINGS_V
VIEW - APPS.AS_OPPORTUNITIES_V
VIEW - APPS.AS_OPPORTUNITY_COMPETITORS_V
VIEW - APPS.AS_OPPORTUNITY_CONTACTS
VIEW - APPS.AS_OPPORTUNITY_CONTACTS_V
VIEW - APPS.AS_OPPORTUNITY_DETAILS_V
VIEW - APPS.AS_OPPORTUNITY_LINES_V
VIEW - APPS.AS_OPPORTUNITY_OBSTACLES_V
VIEW - APPS.AS_OPPORTUNITY_ORDERS_V
VIEW - APPS.AS_OPP_CLASSIFICATION_V
VIEW - APPS.AS_PARTY_ADDRESSES_V
VIEW - APPS.AS_PARTY_CONTACTS_V
VIEW - APPS.AS_PARTY_CUSTOMERS_V
VIEW - APPS.AS_PARTY_ORG_CONTACTS_V
VIEW - APPS.AS_PARTY_PHONES_V
VIEW - APPS.AS_PARTY_RELATIONSHIPS_V
VIEW - APPS.AS_PERIOD_RATES_V
VIEW - APPS.AS_PERSONS_ACTIVE_V
VIEW - APPS.AS_PE_INT_CATEGORIES_V
VIEW - APPS.AS_PRICE_LISTS_V
VIEW - APPS.AS_PRIMARY_INTERESTS_ACTIVE_V
VIEW - APPS.AS_RPT_ADMINS_V
VIEW - APPS.AS_RPT_MANAGERS_V
VIEW - APPS.AS_SALESFORCE_SUB_V
VIEW - APPS.AS_SALESFORCE_V
VIEW - APPS.AS_SALESGROUP_SUB_V
VIEW - APPS.AS_SALES_CREDITS_V
VIEW - APPS.AS_SALES_FORECAST_UWQ_V
VIEW - APPS.AS_SALES_GROUPS_V
VIEW - APPS.AS_SALES_GRP_DENORM_V
VIEW - APPS.AS_SALES_LEADS_V
VIEW - APPS.AS_SALES_LEAD_CONTACTS_V
VIEW - APPS.AS_SALES_LEAD_LINES_V
VIEW - APPS.AS_SALES_LEAD_QUALS_VL
VIEW - APPS.AS_SALES_LEAD_RANKS_VL
VIEW - APPS.AS_SALES_LEAD_UWQ_V
VIEW - APPS.AS_SALES_METHODOLOGY_VL
VIEW - APPS.AS_SALES_OPP_UWQ_V
VIEW - APPS.AS_SALES_STAGES
VIEW - APPS.AS_SALES_STAGES_ALL_VL
VIEW - APPS.AS_SALES_STAGES_VL
VIEW - APPS.AS_SALES_TEAM_DISTINCT_V
VIEW - APPS.AS_SALES_TEAM_EMP_V
VIEW - APPS.AS_SALES_TEAM_PTR_V
VIEW - APPS.AS_SALES_TEAM_V
VIEW - APPS.AS_SCORECARD_RULES_V
VIEW - APPS.AS_SECOND_INTERESTS_ACTIVE_V
VIEW - APPS.AS_SF_PTR_V
VIEW - APPS.AS_SG_ACTIVE_MGR_V
VIEW - APPS.AS_SITE_CLASSIFICATION_V
VIEW - APPS.AS_STATUSES_VL
VIEW - APPS.AS_TAP_ACCOUNTS_V
VIEW - APPS.AS_TAP_LEADS_V
VIEW - APPS.AS_TAP_OPPORTUNITIES_V
VIEW - APPS.AS_TERRITORIES
VIEW - APPS.AS_TERRITORIES_V
VIEW - APPS.AS_TERRITORY_ACCESSES_V
VIEW - APPS.AS_TODO_LISTS
Table: AS_ACCESSES_ALL_ALL
Description: Contains employee and partner access records for customers, sales leads and opportunities
Primary Key: AS_ACCESSES_ALL_PK
ACCESS_ID
Primary Key: AS_ACCESSES_PK
ACCESS_ID
Primary Key: AS_ACCESSES_UK
PERSON_ID
CUSTOMER_ID
ADDRESS_ID
LEAD_ID
Foreign Keys from this table:
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 Keys to this table:
Foreign Key Column
Foreign Table
AS_TERRITORY_ACCESSES.ACCESS_ID
AS_ACCESSES_ALL_ALL
PV_ACCESS_MIGRATION_LOG.ACCESS_ID
AS_ACCESSES_ALL_ALL
[top of page]
OSM.AS_ACCESSES_ALL_ALL does not reference any database object
OSM.AS_ACCESSES_ALL_ALL is referenced by following:
APPS
SYNONYM - AS_ACCESSES_ALL_ALL
[top of page]
Table: AS_ACCESSES_PURGE_TEMP
[top of page]
OSM.AS_ACCESSES_PURGE_TEMP does not reference any database object
OSM.AS_ACCESSES_PURGE_TEMP is referenced by following:
APPS
SYNONYM - AS_ACCESSES_PURGE_TEMP
[top of page]
Table: AS_ACCOUNT_QUAL_VALUES_ALL
Description: Contains changed accounts - obsolete
[top of page]
OSM.AS_ACCOUNT_QUAL_VALUES_ALL does not reference any database object
OSM.AS_ACCOUNT_QUAL_VALUES_ALL is referenced by following:
APPS
SYNONYM - AS_ACCOUNT_QUAL_VALUES_ALL
[top of page]
Table: AS_AP_ACCOUNT_PLANS
Description: This is the header table that will hold account plans for various customers
Primary Key: AS_AP_ACCOUNT_PLANS_PK
ACCOUNT_PLAN_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_AP_ACCOUNT_PLANS.CUST_PARTY_ID
HZ_PARTIES
AS_AP_ACCOUNT_PLANS.CURRENCY_CODE
FND_CURRENCIES
Foreign Keys to this table:
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
[top of page]
OSM.AS_AP_ACCOUNT_PLANS does not reference any database object
OSM.AS_AP_ACCOUNT_PLANS is referenced by following:
APPS
SYNONYM - AS_AP_ACCOUNT_PLANS
[top of page]
Table: AS_AP_BUSINESS_DRIVERS
Description: This table will hold all the business drivers for each of the account plans
Primary Key: AS_AP_BUSINESS_DRIVERS_PK
BUSINESS_DRIVER_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_AP_BUSINESS_DRIVERS.ACCOUNT_PLAN_ID
AS_AP_ACCOUNT_PLANS
[top of page]
OSM.AS_AP_BUSINESS_DRIVERS does not reference any database object
OSM.AS_AP_BUSINESS_DRIVERS is referenced by following:
APPS
SYNONYM - AS_AP_BUSINESS_DRIVERS
[top of page]
Table: AS_AP_STRTGC_OBJECTIVES
Description: This table will hold all the strategic objectives for each of the account plans
Primary Key: AS_AP_STRTGC_OBJECTIVES_PK
STRATEGIC_OBJECTIVE_ID
Foreign Keys from this table:
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
[top of page]
OSM.AS_AP_STRTGC_OBJECTIVES does not reference any database object
OSM.AS_AP_STRTGC_OBJECTIVES is referenced by following:
APPS
SYNONYM - AS_AP_STRTGC_OBJECTIVES
[top of page]
Table: AS_AP_TRACKING_OBJECTIVES
Description: This table will hold all the revenue objectives for each of the account plans
Primary Key: AS_AP_TRACKING_OBJECTIVE_PK
TRACKING_OBJECTIVE_ID
Foreign Keys from this table:
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
ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B
[top of page]
OSM.AS_AP_TRACKING_OBJECTIVES does not reference any database object
OSM.AS_AP_TRACKING_OBJECTIVES is referenced by following:
APPS
SYNONYM - AS_AP_TRACKING_OBJECTIVES
[top of page]
Table: AS_CARD_RULE_QUAL_VALUES
Description: Holds the information about various parameters used in the rule. Records can be deleted.
Primary Key: AS_CARD_RULE_QUAL_VALUES_PK
QUAL_VALUE_ID
Foreign Keys from this table:
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
[top of page]
OSM.AS_CARD_RULE_QUAL_VALUES does not reference any database object
OSM.AS_CARD_RULE_QUAL_VALUES is referenced by following:
APPS
SYNONYM - AS_CARD_RULE_QUAL_VALUES
[top of page]
Table: AS_CATEGORIES_ALL
Description: Contains collateral categories
Primary Key: AS_CATEGORIES_PK
CATEGORY_ID
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AS_COLLATERAL_CAT_ALL.CATEGORY_ID
AS_CATEGORIES_ALL
[top of page]
OSM.AS_CATEGORIES_ALL does not reference any database object
OSM.AS_CATEGORIES_ALL is referenced by following:
APPS
SYNONYM - AS_CATEGORIES_ALL
[top of page]
Table: AS_CHANGED_ACCOUNTS_ALL
Description: Contains changed accounts
Primary Key: AS_CHANGED_ACCOUNTS_PK
ADDRESS_ID
LEAD_ID
Foreign Keys from this table:
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
[top of page]
OSM.AS_CHANGED_ACCOUNTS_ALL does not reference any database object
OSM.AS_CHANGED_ACCOUNTS_ALL is referenced by following:
APPS
SYNONYM - AS_CHANGED_ACCOUNTS_ALL
[top of page]
Table: AS_CHANGED_TERRITORIES_ALL
Description: Contains changed territories
Primary Key: AS_CHANGED_TERRITORIES_PK
TERRITORY_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_CHANGED_TERRITORIES_ALL.TERRITORY_ID
AS_TERRITORIES_ALL
AS_CHANGED_TERRITORIES_ALL.TRANSFER_TO_SALESFORCE_ID
AS_SALESFORCE
[top of page]
OSM.AS_CHANGED_TERRITORIES_ALL does not reference any database object
OSM.AS_CHANGED_TERRITORIES_ALL is referenced by following:
APPS
SYNONYM - AS_CHANGED_TERRITORIES_ALL
[top of page]
Table: AS_COLLATERAL_CAT_ALL
Description: Contains collateral categories
Primary Key: AS_COLLATERAL_CATEGORIES_PK
PROMOTION_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_COLLATERAL_CAT_ALL.PROMOTION_ID
AS_PROMOTIONS_ALL
AS_COLLATERAL_CAT_ALL.CATEGORY_ID
AS_CATEGORIES_ALL
[top of page]
OSM.AS_COLLATERAL_CAT_ALL does not reference any database object
OSM.AS_COLLATERAL_CAT_ALL is referenced by following:
APPS
SYNONYM - AS_COLLATERAL_CAT_ALL
[top of page]
Table: AS_COLLATERAL_KITS_ALL
Description: Contains collateral kits
Primary Key: AS_COLLATERAL_KITS_PK
PARENT_COLLATERAL_ID
CHILD_COLLATERAL_ID
Foreign Keys from this table:
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
[top of page]
OSM.AS_COLLATERAL_KITS_ALL does not reference any database object
OSM.AS_COLLATERAL_KITS_ALL is referenced by following:
APPS
SYNONYM - AS_COLLATERAL_KITS_ALL
[top of page]
Table: AS_COLLATERAL_REQ_ALL
Description: Contains collateral requests
Primary Key: AS_COLLATERAL_REQUESTS_PK
COLLATERAL_REQUEST_ID
Foreign Keys from this table:
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 Keys to this table:
Foreign Key Column
Foreign Table
AS_COLLATERAL_REQ_ITEMS.COLLATERAL_REQUEST_ID
AS_COLLATERAL_REQ_ALL
[top of page]
OSM.AS_COLLATERAL_REQ_ALL does not reference any database object
OSM.AS_COLLATERAL_REQ_ALL is referenced by following:
APPS
SYNONYM - AS_COLLATERAL_REQ_ALL
[top of page]
Table: AS_COLLATERAL_REQ_ITEMS
Description: Contains items included in a collateral request
Primary Key: AS_COLL_REQ_ITEMS_PK
COLLATERAL_REQ_ITEM_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_COLLATERAL_REQ_ITEMS.COLLATERAL_REQUEST_ID
AS_COLLATERAL_REQ_ALL
AS_COLLATERAL_REQ_ITEMS.INVENTORY_ITEM_ID
ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B
AS_COLLATERAL_REQ_ITEMS.COLLATERAL_ID
AS_PROMOTIONS_ALL
[top of page]
OSM.AS_COLLATERAL_REQ_ITEMS does not reference any database object
OSM.AS_COLLATERAL_REQ_ITEMS is referenced by following:
APPS
SYNONYM - AS_COLLATERAL_REQ_ITEMS
[top of page]
Table: AS_CONC_REQUEST_MESSAGES
Description: Contains error messages for concurrent programs
Primary Key: AS_CONC_REQUEST_MESSAGES_PK
CONC_REQUEST_MESSAGE_ID
[top of page]
OSM.AS_CONC_REQUEST_MESSAGES does not reference any database object
OSM.AS_CONC_REQUEST_MESSAGES is referenced by following:
APPS
SYNONYM - AS_CONC_REQUEST_MESSAGES
[top of page]
Table: AS_CONTACT_EDUCATION
Description: Contains education information for contacts
Primary Key: AS_CONTACT_EDUCATION_PK
EDUCATION_ID
[top of page]
OSM.AS_CONTACT_EDUCATION does not reference any database object
OSM.AS_CONTACT_EDUCATION is referenced by following:
APPS
SYNONYM - AS_CONTACT_EDUCATION
[top of page]
Table: AS_CONTACT_ENTER
Description: Contains entertainment information for contacts
Primary Key: AS_CONTACT_ENTERTAINMENT_PK
ENTERTAINMENT_ID
[top of page]
OSM.AS_CONTACT_ENTER does not reference any database object
OSM.AS_CONTACT_ENTER is referenced by following:
APPS
SYNONYM - AS_CONTACT_ENTER
[top of page]
Table: AS_CONTACT_FAMILY
Description: Obsolete table in 11i
Primary Key: AS_CONTACT_FAMILY_MATTERS_PK
FAMILY_ID
Primary Key: AS_CONTACT_FAMILY_PK
FAMILY_ID
[top of page]
OSM.AS_CONTACT_FAMILY does not reference any database object
OSM.AS_CONTACT_FAMILY is referenced by following:
APPS
SYNONYM - AS_CONTACT_FAMILY
[top of page]
Table: AS_CONTACT_HOBBIES
Description: Contain information about hobbies for contacts
Primary Key: AS_CONTACT_HOBBIES_PK
HOBBY_ID
[top of page]
OSM.AS_CONTACT_HOBBIES does not reference any database object
OSM.AS_CONTACT_HOBBIES is referenced by following:
APPS
SYNONYM - AS_CONTACT_HOBBIES
[top of page]
Table: AS_CONTACT_JOB_HISTORY
Description: Contains job history information for contacts
Primary Key: AS_CONTACT_JOB_HISTORY_PK
JOB_HISTORY_ID
[top of page]
OSM.AS_CONTACT_JOB_HISTORY does not reference any database object
OSM.AS_CONTACT_JOB_HISTORY is referenced by following:
APPS
SYNONYM - AS_CONTACT_JOB_HISTORY
[top of page]
Table: AS_CONTACT_MILITARY
Description: Contains millitary information for contacts
Primary Key: AS_CONTACT_MILITARY_PK
MILITARY_ID
[top of page]
OSM.AS_CONTACT_MILITARY does not reference any database object
OSM.AS_CONTACT_MILITARY is referenced by following:
APPS
SYNONYM - AS_CONTACT_MILITARY
[top of page]
Table: AS_CONTACT_PREFERENCES
Description: Contains additional preferences for contacts
Primary Key: AS_CONTACT_PREFERENCES_PK
PREFERENCE_ID
[top of page]
OSM.AS_CONTACT_PREFERENCES does not reference any database object
OSM.AS_CONTACT_PREFERENCES is referenced by following:
APPS
SYNONYM - AS_CONTACT_PREFERENCES
[top of page]
Table: AS_CONTACT_SPORTS
Description: Contains sport information for contacts
Primary Key: AS_CONTACT_SPORTS_PK
SPORTS_ID
[top of page]
OSM.AS_CONTACT_SPORTS does not reference any database object
OSM.AS_CONTACT_SPORTS is referenced by following:
APPS
SYNONYM - AS_CONTACT_SPORTS
[top of page]
Table: AS_CONTACT_TRAITS
Description: Contains traits for contacts
Primary Key: AS_CONTACT_TRAITS_PK
TRAIT_ID
[top of page]
OSM.AS_CONTACT_TRAITS does not reference any database object
OSM.AS_CONTACT_TRAITS is referenced by following:
APPS
SYNONYM - AS_CONTACT_TRAITS
[top of page]
Table: AS_COUNTRY_PHONES
Description: Contains international dialing codes for countries
Primary Key: AS_COUNTRY_PHONES_PK
COUNTRY_CODE
[top of page]
OSM.AS_COUNTRY_PHONES does not reference any database object
OSM.AS_COUNTRY_PHONES is referenced by following:
APPS
SYNONYM - AS_COUNTRY_PHONES
[top of page]
Table: AS_CURRENT_ENVIRONMENT
Description: This table stores information about the current environment of the
Primary Key: AS_CURRENT_ENVIRONMENT_PK
CURRENT_ENVIRONMENT_ID
Foreign Keys from this table:
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
[top of page]
OSM.AS_CURRENT_ENVIRONMENT does not reference any database object
OSM.AS_CURRENT_ENVIRONMENT is referenced by following:
APPS
SYNONYM - AS_CURRENT_ENVIRONMENT
[top of page]
Table: AS_CUST_PROFILES
Description: Table for OSM disconnected, stores identifiers for newly created accounts.
Primary Key: AS_CUST_PROFILES_PK
CUSTOMER_ID
ADDRESS_ID
[top of page]
OSM.AS_CUST_PROFILES does not reference any database object
OSM.AS_CUST_PROFILES is referenced by following:
APPS
SYNONYM - AS_CUST_PROFILES
[top of page]
Table: AS_DEFAULT_PURCHASES_ALL
Description: Currently not in use
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_DEFAULT_PURCHASES_ALL.INTEREST_TYPE_ID
AS_INTEREST_TYPES_ALL
[top of page]
OSM.AS_DEFAULT_PURCHASES_ALL does not reference any database object
OSM.AS_DEFAULT_PURCHASES_ALL is referenced by following:
APPS
SYNONYM - AS_DEFAULT_PURCHASES_ALL
[top of page]
Table: AS_EVENT_DATA
Description: Table for storing Business Events data
Primary Key: AS_EVENT_DATA_PK
EVENT_DATA_ID
[top of page]
OSM.AS_EVENT_DATA does not reference any database object
OSM.AS_EVENT_DATA is referenced by following:
APPS
SYNONYM - AS_EVENT_DATA
[top of page]
Table: AS_EVENT_ENROLLMENTS_ALL
Description: Contains event enrollments
Primary Key: AS_EVENT_ENROLLMENTS_PK
EVENT_ENROLLMENT_ID
Primary Key: AS_EVENT_ENROLLMENTS_UK
CONTACT_ID
EVENT_ID
Foreign Keys from this table:
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
[top of page]
OSM.AS_EVENT_ENROLLMENTS_ALL does not reference any database object
OSM.AS_EVENT_ENROLLMENTS_ALL is referenced by following:
APPS
SYNONYM - AS_EVENT_ENROLLMENTS_ALL
[top of page]
Table: AS_EVENT_FACILITIES_ALL
Description: Contains event facilities
Primary Key: AS_EVENT_FACILITIES_PK
EVENT_FACILITY_ID
Primary Key: AS_EVENT_FACILITIES_UK
CODE
NAME
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AS_PROMOTIONS_ALL.EVENT_FACILITY_ID
AS_EVENT_FACILITIES_ALL
[top of page]
OSM.AS_EVENT_FACILITIES_ALL does not reference any database object
OSM.AS_EVENT_FACILITIES_ALL is referenced by following:
APPS
SYNONYM - AS_EVENT_FACILITIES_ALL
[top of page]
Table: AS_EVENT_FAC_ROOMS
Description: Contains event facility rooms
Primary Key: AS_EVENT_FAC_ROOMS_PK
EVENT_FAC_ROOM_ID
[top of page]
OSM.AS_EVENT_FAC_ROOMS does not reference any database object
OSM.AS_EVENT_FAC_ROOMS is referenced by following:
APPS
SYNONYM - AS_EVENT_FAC_ROOMS
[top of page]
Table: AS_EVENT_FAC_STAFF
Description: Contains event facility staff
Primary Key: AS_EVENT_FAC_STAFF_PK
EVENT_FAC_STAFF_ID
[top of page]
OSM.AS_EVENT_FAC_STAFF does not reference any database object
OSM.AS_EVENT_FAC_STAFF is referenced by following:
APPS
SYNONYM - AS_EVENT_FAC_STAFF
[top of page]
Table: AS_EVENT_LETTERS_ALL
Description: Contains letters to be used for events
Primary Key: AS_EVENT_LETTERS_UK
EVENT_ID
LETTER_ID
Primary Key: AS_EVENT_LETTER_PK
EVENT_LETTER_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_EVENT_LETTERS_ALL.EVENT_ID
AS_PROMOTIONS_ALL
AS_EVENT_LETTERS_ALL.LETTER_ID
AS_PROMOTIONS_ALL
[top of page]
OSM.AS_EVENT_LETTERS_ALL does not reference any database object
OSM.AS_EVENT_LETTERS_ALL is referenced by following:
APPS
SYNONYM - AS_EVENT_LETTERS_ALL
[top of page]
Table: AS_EVENT_NAMES_ALL
Description: Contains events
Primary Key: AS_EVENT_NAMES_PK
EVENT_NAME_ID
[top of page]
OSM.AS_EVENT_NAMES_ALL does not reference any database object
OSM.AS_EVENT_NAMES_ALL is referenced by following:
APPS
SYNONYM - AS_EVENT_NAMES_ALL
[top of page]
Table: AS_EVENT_NAME_REQUIREMENTS
Description: Contains event requirements
Primary Key: AS_EVENT_NAME_REQUIREMENTS_PK
EVENT_NAME_REQUIREMENT_ID
[top of page]
OSM.AS_EVENT_NAME_REQUIREMENTS does not reference any database object
OSM.AS_EVENT_NAME_REQUIREMENTS is referenced by following:
APPS
SYNONYM - AS_EVENT_NAME_REQUIREMENTS
[top of page]
Table: AS_EVENT_PERSONNEL
Description: Contains event personnel
Primary Key: AS_EVENT_PERSONNEL_PK
EVENT_PERSONNEL_ID
[top of page]
OSM.AS_EVENT_PERSONNEL does not reference any database object
OSM.AS_EVENT_PERSONNEL is referenced by following:
APPS
SYNONYM - AS_EVENT_PERSONNEL
[top of page]
Table: AS_EXCHANGES_B
Description: Base table to store exchanges
Primary Key: AS_EXCHANGES_B_PK
EXCHANGE_ID
[top of page]
OSM.AS_EXCHANGES_B does not reference any database object
OSM.AS_EXCHANGES_B is referenced by following:
APPS
SYNONYM - AS_EXCHANGES_B
[top of page]
Table: AS_EXCHANGES_TL
Description: For MLS - Translated columns of Exchanges
Primary Key: AS_EXCHANGES_TL_PK
EXCHANGE_ID
LANGUAGE
[top of page]
OSM.AS_EXCHANGES_TL does not reference any database object
OSM.AS_EXCHANGES_TL is referenced by following:
APPS
SYNONYM - AS_EXCHANGES_TL
[top of page]
Table: AS_FORECASTS
Description: Holds revenue and quota credit forecasts
Primary Key: AS_FORECASTS_PK
FORECAST_ID
[top of page]
OSM.AS_FORECASTS does not reference any database object
OSM.AS_FORECASTS is referenced by following:
APPS
SYNONYM - AS_FORECASTS
[top of page]
Table: AS_FORECAST_ACTUALS
Description: Table for comparing the actual returns with forecasted values
Primary Key: AS_FORECAST_ACTUALS_PK
FORECAST_ACTUAL_ID
Foreign Keys from this table:
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
[top of page]
OSM.AS_FORECAST_ACTUALS does not reference any database object
OSM.AS_FORECAST_ACTUALS is referenced by following:
APPS
SYNONYM - AS_FORECAST_ACTUALS
[top of page]
Table: AS_FORECAST_CATEGORIES_B
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.
Primary Key: AS_FORECAST_CATEGORIES_B_PK
FORECAST_CATEGORY_ID
Foreign Keys to this table:
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
[top of page]
OSM.AS_FORECAST_CATEGORIES_B does not reference any database object
OSM.AS_FORECAST_CATEGORIES_B is referenced by following:
APPS
SYNONYM - AS_FORECAST_CATEGORIES_B
[top of page]
Table: AS_FORECAST_CATEGORIES_TL
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.
Primary Key: AS_FORECAST_CATEGORIES_TL_PK
FORECAST_CATEGORY_ID
[top of page]
OSM.AS_FORECAST_CATEGORIES_TL does not reference any database object
OSM.AS_FORECAST_CATEGORIES_TL is referenced by following:
APPS
SYNONYM - AS_FORECAST_CATEGORIES_TL
[top of page]
Table: AS_FORECAST_CAT_DEN
[top of page]
OSM.AS_FORECAST_CAT_DEN does not reference any database object
OSM.AS_FORECAST_CAT_DEN is referenced by following:
APPS
SYNONYM - AS_FORECAST_CAT_DEN
[top of page]
Table: AS_FORECAST_PROB_ALL_B
Description: AS_FORECAST_PROB_ALL defines win probability values for sales
Primary Key: AS_FORECAST_PROB_ALL_B_PK
PROBABILITY_VALUE
Foreign Keys to this table:
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
[top of page]
OSM.AS_FORECAST_PROB_ALL_B does not reference any database object
OSM.AS_FORECAST_PROB_ALL_B is referenced by following:
APPS
SYNONYM - AS_FORECAST_PROB_ALL_B
[top of page]
Table: AS_FORECAST_PROB_ALL_TL
Description: MLS - Translated columns of AS_FORECAST_PROB_ALL_B
Primary Key: AS_FORECAST_PROB_ALL_TL_PK
PROBABILITY_VALUE
LANGUAGE
Primary Key: AS_FORECAST_PROB_ALL_TL_UK
LANGUAGE
PROBABILITY_VALUE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_FORECAST_PROB_ALL_TL.PROBABILITY_VALUE
AS_FORECAST_PROB_ALL_B
[top of page]
OSM.AS_FORECAST_PROB_ALL_TL does not reference any database object
OSM.AS_FORECAST_PROB_ALL_TL is referenced by following:
APPS
SYNONYM - AS_FORECAST_PROB_ALL_TL
[top of page]
Table: AS_FORECAST_WORKSHEETS
Description: This will store header information for the opportunity and product category worksheet.
Primary Key: AS_FORECAST_WORKSHEETS_PK
FORECAST_WORKSHEET_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_FORECAST_WORKSHEETS.FORECAST_ID
AS_INTERNAL_FORECASTS
Foreign Keys to this table:
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
[top of page]
OSM.AS_FORECAST_WORKSHEETS does not reference any database object
OSM.AS_FORECAST_WORKSHEETS is referenced by following:
APPS
SYNONYM - AS_FORECAST_WORKSHEETS
[top of page]
Table: AS_FST_SALES_CATEGORIES
Description: Resolving table between AS_FORECAST_CATEGORIES and AS_INTEREST_TYPES_B
Primary Key: AS_FST_SALES_CATEGORIES_PK
FST_SALES_CATEGORY_ID
Foreign Keys from this table:
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 Keys to this table:
Foreign Key Column
Foreign Table
AS_PROD_WORKSHEET_LINES.FST_SALES_CATEGORY_ID
AS_FST_SALES_CATEGORIES
[top of page]
OSM.AS_FST_SALES_CATEGORIES does not reference any database object
OSM.AS_FST_SALES_CATEGORIES is referenced by following:
APPS
MATERIALIZED VIEW - AS_FORECAST_MV
SYNONYM - AS_FST_SALES_CATEGORIES
[top of page]
Table: AS_FUNDS_B
Description: Base table to store Funds
Primary Key: AS_FUNDS_B_PK
FUND_ID
[top of page]
OSM.AS_FUNDS_B does not reference any database object
OSM.AS_FUNDS_B is referenced by following:
APPS
SYNONYM - AS_FUNDS_B
[top of page]
Table: AS_FUNDS_TL
Description: For MLS - Translated columns of Funds
Primary Key: AS_FUNDS_TL_PK
FUND_ID
LANGUAGE
[top of page]
OSM.AS_FUNDS_TL does not reference any database object
OSM.AS_FUNDS_TL is referenced by following:
APPS
SYNONYM - AS_FUNDS_TL
[top of page]
Table: AS_FUND_CONTACTS
Description: Fund Contacts
Primary Key: AS_FUND_CONTACTS_PK
PARTY_ID
FUND_ID
[top of page]
OSM.AS_FUND_CONTACTS does not reference any database object
OSM.AS_FUND_CONTACTS is referenced by following:
APPS
SYNONYM - AS_FUND_CONTACTS
[top of page]
Table: AS_GROUP_ISSUE_MAP
Description: Mapping table between issue groups and issues
Primary Key: AS_GROUP_ISSUE_MAP_PK
ISSUE_GROUP_ID
ISSUE_ID
[top of page]
OSM.AS_GROUP_ISSUE_MAP does not reference any database object
OSM.AS_GROUP_ISSUE_MAP is referenced by following:
APPS
SYNONYM - AS_GROUP_ISSUE_MAP
[top of page]
Table: AS_GROUP_PARTY_MAP
Description: Mapping table between issue groups and issues
Primary Key: AS_GROUP_PARTY_MAP_PK
ISSUE_GROUP_ID
PARTY_ID
[top of page]
OSM.AS_GROUP_PARTY_MAP does not reference any database object
OSM.AS_GROUP_PARTY_MAP is referenced by following:
APPS
SYNONYM - AS_GROUP_PARTY_MAP
[top of page]
Table: AS_HZ_CLASS_CODE_DENORM
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
[top of page]
OSM.AS_HZ_CLASS_CODE_DENORM does not reference any database object
OSM.AS_HZ_CLASS_CODE_DENORM is referenced by following:
APPS
SYNONYM - AS_HZ_CLASS_CODE_DENORM
[top of page]
Table: AS_IMPORT_INTERFACE
Description: staging table to hold data to be imported
Primary Key: AS_IMPORT_INTERFACE_PK
IMPORT_INTERFACE_ID
Foreign Keys to this table:
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
[top of page]
OSM.AS_IMPORT_INTERFACE does not reference any database object
OSM.AS_IMPORT_INTERFACE is referenced by following:
APPS
SYNONYM - AS_IMPORT_INTERFACE
[top of page]
Table: AS_IMP_CNT_PNT_INTERFACE
Description: Interface table to hold contact points information to be imported.
Primary Key: AS_IMP_CNT_PNT_INTERFACE_PK
IMP_CNT_PNT_INTERFACE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_IMP_CNT_PNT_INTERFACE.IMPORT_INTERFACE_ID
AS_IMPORT_INTERFACE
[top of page]
OSM.AS_IMP_CNT_PNT_INTERFACE does not reference any database object
OSM.AS_IMP_CNT_PNT_INTERFACE is referenced by following:
APPS
SYNONYM - AS_IMP_CNT_PNT_INTERFACE
[top of page]
Table: AS_IMP_CNT_ROL_INTERFACE
Description: Interface table to hold contact roles information to be imported.
Primary Key: IMP_CNT_ROL_INTERFACE_PK
IMP_CNT_ROL_INTERFACE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_IMP_CNT_ROL_INTERFACE.IMPORT_INTERFACE_ID
AS_IMPORT_INTERFACE
[top of page]
OSM.AS_IMP_CNT_ROL_INTERFACE does not reference any database object
OSM.AS_IMP_CNT_ROL_INTERFACE is referenced by following:
APPS
SYNONYM - AS_IMP_CNT_ROL_INTERFACE
[top of page]
Table: AS_IMP_LINES_INTERFACE
Description: Interface table to hold lead lines information to be imported.
Primary Key: AS_IMP_LINES_INTERFACE_PK
IMP_LINES_INTERFACE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_IMP_LINES_INTERFACE.IMPORT_INTERFACE_ID
AS_IMPORT_INTERFACE
[top of page]
OSM.AS_IMP_LINES_INTERFACE does not reference any database object
OSM.AS_IMP_LINES_INTERFACE is referenced by following:
APPS
SYNONYM - AS_IMP_LINES_INTERFACE
[top of page]
Table: AS_IMP_SL_FLEX
Description: Table to hold flex field information to be imported.
Primary Key: AS_IMP_SL_FLEX_PK
IMP_SL_FLEX_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_IMP_SL_FLEX.IMPORT_INTERFACE_ID
AS_IMPORT_INTERFACE
[top of page]
OSM.AS_IMP_SL_FLEX does not reference any database object
OSM.AS_IMP_SL_FLEX is referenced by following:
APPS
SYNONYM - AS_IMP_SL_FLEX
[top of page]
Table: AS_INTERESTS_ALL
Description: Stores product interests, customer and opportunity classifications
Primary Key: AS_INTERESTS_ALL_PK
INTEREST_ID
Primary Key: AS_INTERESTS_PK
INTEREST_ID
Foreign Keys from this table:
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
[top of page]
OSM.AS_INTERESTS_ALL does not reference any database object
OSM.AS_INTERESTS_ALL is referenced by following:
APPS
SYNONYM - AS_INTERESTS_ALL
[top of page]
Table: AS_INTEREST_CATEGORY_SETS_ALL
Description: Contains interest category sets
Primary Key: AS_INTEREST_CATEGORY_SETS_PK
CATEGORY_SET_ID
INTEREST_TYPE_ID
Primary Key: AS_INT_CAT_SETS_ALL_PK
CATEGORY_SET_ID
INTEREST_TYPE_ID
Foreign Keys from this table:
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
[top of page]
OSM.AS_INTEREST_CATEGORY_SETS_ALL does not reference any database object
OSM.AS_INTEREST_CATEGORY_SETS_ALL is referenced by following:
APPS
SYNONYM - AS_INTEREST_CATEGORY_SETS_ALL
[top of page]
Table: AS_INTEREST_CODES_ALL
Description: Defines interest codes with multi-org flag columns
Primary Key: AS_INTEREST_CODES_ALL_PK
INTEREST_CODE_ID
ORG_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_INTEREST_CODES_ALL.INTEREST_CODE_ID
AS_INTEREST_CODES_B
Foreign Keys to this table:
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
[top of page]
OSM.AS_INTEREST_CODES_ALL does not reference any database object
OSM.AS_INTEREST_CODES_ALL is referenced by following:
APPS
SYNONYM - AS_INTEREST_CODES_ALL
[top of page]
Table: AS_INTEREST_CODES_B
Description: Define Interest code - Base table
Primary Key: AS_INTEREST_CODES_B_PK
INTEREST_CODE_ID
Foreign Keys from this 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
PF_ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B
Foreign Keys to this table:
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
[top of page]
OSM.AS_INTEREST_CODES_B does not reference any database object
OSM.AS_INTEREST_CODES_B is referenced by following:
APPS
SYNONYM - AS_INTEREST_CODES_B
[top of page]
Table: AS_INTEREST_CODES_MC
Description: for recording a price and currency for a product family.
Primary Key: AS_INTEREST_CODES_MC_PK
CURRENCY_CODE
INTEREST_CODE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_INTEREST_CODES_MC.INTEREST_CODE_ID
AS_INTEREST_CODES_B
[top of page]
OSM.AS_INTEREST_CODES_MC does not reference any database object
OSM.AS_INTEREST_CODES_MC is referenced by following:
APPS
SYNONYM - AS_INTEREST_CODES_MC
[top of page]
Table: AS_INTEREST_CODES_TL
Description: For MLS - Translated columns of Interest Codes.
Primary Key: AS_INTEREST_CODES_ALL_TL_PK
INTEREST_CODE_ID
LANGUAGE
Primary Key: AS_INTEREST_CODES_TL_UK
INTEREST_CODE_ID
CODE
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_INTEREST_CODES_TL.INTEREST_CODE_ID
AS_INTEREST_CODES_B
[top of page]
OSM.AS_INTEREST_CODES_TL does not reference any database object
OSM.AS_INTEREST_CODES_TL is referenced by following:
APPS
SYNONYM - AS_INTEREST_CODES_TL
[top of page]
Table: AS_INTEREST_STATUSES
Description: Define interest statuses
Primary Key: AS_INTEREST_STATUSES_PK
INTEREST_TYPE_ID
INTEREST_STATUS_CODE
Foreign Keys from this table:
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
[top of page]
OSM.AS_INTEREST_STATUSES does not reference any database object
OSM.AS_INTEREST_STATUSES is referenced by following:
APPS
SYNONYM - AS_INTEREST_STATUSES
[top of page]
Table: AS_INTEREST_TYPES_ALL
Description: Defines interest types with multi-org flag columns
Primary Key: AS_INTEREST_TYPES_ALL_PK
INTEREST_TYPE_ID
ORG_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_INTEREST_TYPES_ALL.INTEREST_TYPE_ID
AS_INTEREST_TYPES_B
Foreign Keys to this table:
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
[top of page]
OSM.AS_INTEREST_TYPES_ALL does not reference any database object
OSM.AS_INTEREST_TYPES_ALL is referenced by following:
APPS
SYNONYM - AS_INTEREST_TYPES_ALL
[top of page]
Table: AS_INTEREST_TYPES_B
Description: Define Interest types - base table
Primary Key: AS_INTEREST_TYPES_B_PK
INTEREST_TYPE_ID
Foreign Keys to this 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
[top of page]
OSM.AS_INTEREST_TYPES_B does not reference any database object
OSM.AS_INTEREST_TYPES_B is referenced by following:
APPS
SYNONYM - AS_INTEREST_TYPES_B
[top of page]
Table: AS_INTEREST_TYPES_TL
Description: For MLS - Translated columns of Interest Types
Primary Key: AS_INTEREST_TYPES_TL_PK
INTEREST_TYPE_ID
LANGUAGE
Primary Key: AS_INTEREST_TYPES_TL_UK
INTEREST_TYPE_ID
INTEREST_TYPE
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_INTEREST_TYPES_TL.INTEREST_TYPE_ID
AS_INTEREST_TYPES_B
[top of page]
OSM.AS_INTEREST_TYPES_TL does not reference any database object
OSM.AS_INTEREST_TYPES_TL is referenced by following:
APPS
SYNONYM - AS_INTEREST_TYPES_TL
[top of page]
Table: AS_INTERNAL_FORECASTS
Description: Table to store the summary forecast information for individual or group
Primary Key: AS_INTERNAL_FORECASTS_PK
FORECAST_ID
Foreign Keys from this table:
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 Keys to this table:
Foreign Key Column
Foreign Table
AS_FORECAST_WORKSHEETS.FORECAST_ID
AS_INTERNAL_FORECASTS
AS_INTERNAL_FORECASTS.ORIGINAL_FORECAST_ID
AS_INTERNAL_FORECASTS
[top of page]
OSM.AS_INTERNAL_FORECASTS does not reference any database object
OSM.AS_INTERNAL_FORECASTS is referenced by following:
APPS
SYNONYM - AS_INTERNAL_FORECASTS
[top of page]
Table: AS_INVALID_ADDR
Description: Stores invalid addresses from ra_addresses
Primary Key: AS_INVALID_ADDR_PK
ADDRESS_ID
[top of page]
OSM.AS_INVALID_ADDR does not reference any database object
OSM.AS_INVALID_ADDR is referenced by following:
APPS
SYNONYM - AS_INVALID_ADDR
[top of page]
Table: AS_ISSUER
Description: Stores Issuers
Primary Key: AS_ISSUER_PK
PARTY_ID
[top of page]
OSM.AS_ISSUER does not reference any database object
OSM.AS_ISSUER is referenced by following:
APPS
SYNONYM - AS_ISSUER
[top of page]
Table: AS_ISSUES_B
Description: Holds Issues - Base Table
Primary Key: AS_ISSUES_B_PK
ISSUE_ID
[top of page]
OSM.AS_ISSUES_B does not reference any database object
OSM.AS_ISSUES_B is referenced by following:
APPS
SYNONYM - AS_ISSUES_B
[top of page]
Table: AS_ISSUES_TL
Description: For MLS - Translated columns of Issues
Primary Key: AS_ISSUES_TL_PK
ISSUE_ID
LANGUAGE
[top of page]
OSM.AS_ISSUES_TL does not reference any database object
OSM.AS_ISSUES_TL is referenced by following:
APPS
SYNONYM - AS_ISSUES_TL
[top of page]
Table: AS_ISSUE_GROUPS_B
Description: Holds Issue Groups - Base Table
Primary Key: AS_ISSUE_GROUPS_B_PK
ISSUE_GROUP_ID
[top of page]
OSM.AS_ISSUE_GROUPS_B does not reference any database object
OSM.AS_ISSUE_GROUPS_B is referenced by following:
APPS
SYNONYM - AS_ISSUE_GROUPS_B
[top of page]
Table: AS_ISSUE_GROUPS_TL
Description: For MLS - Translated columns of Issue Groups
Primary Key: AS_ISSUE_GROUPS_TL_PK
ISSUE_GROUP_ID
LANGUAGE
[top of page]
OSM.AS_ISSUE_GROUPS_TL does not reference any database object
OSM.AS_ISSUE_GROUPS_TL is referenced by following:
APPS
SYNONYM - AS_ISSUE_GROUPS_TL
[top of page]
Table: AS_ISSUE_GROUP_IDFR
Description: Holds Issue Group Identifiers
Primary Key: AS_ISSUE_GROUP_IDFR_PK
ISSUE_GROUP_IDFR_ID
[top of page]
OSM.AS_ISSUE_GROUP_IDFR does not reference any database object
OSM.AS_ISSUE_GROUP_IDFR is referenced by following:
APPS
SYNONYM - AS_ISSUE_GROUP_IDFR
[top of page]
Table: AS_ISSUE_GROUP_TYPES
Description: Holds Issue Group Types
Primary Key: AS_ISSUE_GROUP_TYPES_PK
ISSUE_GROUP_TYPE_CODE
LANGUAGE
[top of page]
OSM.AS_ISSUE_GROUP_TYPES does not reference any database object
OSM.AS_ISSUE_GROUP_TYPES is referenced by following:
APPS
SYNONYM - AS_ISSUE_GROUP_TYPES
[top of page]
Table: AS_ISSUE_LISTING_B
Description: Holds Issue Listings - base table
Primary Key: AS_ISSUE_LISTING_B_PK
ISSUE_ID
EXCHANGE_ID
[top of page]
OSM.AS_ISSUE_LISTING_B does not reference any database object
OSM.AS_ISSUE_LISTING_B is referenced by following:
APPS
SYNONYM - AS_ISSUE_LISTING_B
[top of page]
Table: AS_ISSUE_LISTING_IDFR
Description: Holds issue listing identifiers
Primary Key: ISSUELTGID_PK
ISSUE_LISTING_IDFR_ID
[top of page]
OSM.AS_ISSUE_LISTING_IDFR does not reference any database object
OSM.AS_ISSUE_LISTING_IDFR is referenced by following:
APPS
SYNONYM - AS_ISSUE_LISTING_IDFR
[top of page]
Table: AS_ISSUE_LISTING_TL
Description: For MLS - Translated columns of Issue Listings
Primary Key: AS_ISSUE_LISTING_TL_PK
ISSUE_ID
EXCHANGE_ID
LANGUAGE
[top of page]
OSM.AS_ISSUE_LISTING_TL does not reference any database object
OSM.AS_ISSUE_LISTING_TL is referenced by following:
APPS
SYNONYM - AS_ISSUE_LISTING_TL
[top of page]
Table: AS_ISSUE_RELATIONSHIPS
Description: Stores Issue Relationships
Primary Key: AS_ISSUE_RELATIONSHIPS_PK
ISSUE_RELATIONSHIP_ID
[top of page]
OSM.AS_ISSUE_RELATIONSHIPS does not reference any database object
OSM.AS_ISSUE_RELATIONSHIPS is referenced by following:
APPS
SYNONYM - AS_ISSUE_RELATIONSHIPS
[top of page]
Table: AS_LAST_RUN_DATES
Description: Contains the last date an Oracle Sales and marketing concurrent program ran
Primary Key: AS_LAST_RUN_DATES_PK
PROGRAM_ID
[top of page]
OSM.AS_LAST_RUN_DATES does not reference any database object
OSM.AS_LAST_RUN_DATES is referenced by following:
APPS
SYNONYM - AS_LAST_RUN_DATES
[top of page]
Table: AS_LEADS_ALL
Description: Holds sales opportunities
Primary Key: AS_LEADS_ALL_PK
LEAD_ID
Primary Key: AS_LEADS_PK
LEAD_ID
Foreign Keys from this table:
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 Keys to this table:
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
[top of page]
OSM.AS_LEADS_ALL does not reference any database object
OSM.AS_LEADS_ALL is referenced by following:
APPS
SYNONYM - AS_LEADS_ALL
TRIGGER - AS_LEADS_BIUD
[top of page]
Table: AS_LEADS_LOG
Description: Holds opportunity header change history
Primary Key: AS_LEADS_LOG_PK
LOG_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_LEADS_LOG.CUSTOMER_ID
HZ_PARTIES
AS_LEADS_LOG.LEAD_ID
AS_LEADS_ALL
[top of page]
OSM.AS_LEADS_LOG does not reference any database object
OSM.AS_LEADS_LOG is referenced by following:
APPS
SYNONYM - AS_LEADS_LOG
[top of page]
Table: AS_LEAD_ADJS
Description: Stores adjustments to a lead (opportunity).
Primary Key: AS_LEAD_ADJS_PK
LEAD_ADJUSTMENT_ID
[top of page]
OSM.AS_LEAD_ADJS does not reference any database object
OSM.AS_LEAD_ADJS is referenced by following:
APPS
SYNONYM - AS_LEAD_ADJS
[top of page]
Table: AS_LEAD_COMPETITORS
Description: Defines competitors for sales opportunities
Primary Key: AS_LEAD_COMPETITORS_PK
LEAD_COMPETITOR_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_LEAD_COMPETITORS.LEAD_ID
AS_LEADS_ALL
AS_LEAD_COMPETITORS.COMPETITOR_ID
HZ_PARTIES
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AS_LEAD_COMPETITOR_PRODS.LEAD_COMPETITOR_ID
AS_LEAD_COMPETITORS
[top of page]
OSM.AS_LEAD_COMPETITORS does not reference any database object
OSM.AS_LEAD_COMPETITORS is referenced by following:
APPS
SYNONYM - AS_LEAD_COMPETITORS
[top of page]
Table: AS_LEAD_COMP_PRODUCTS
Description: Holds competitor products
Primary Key: AS_LEAD_COMP_PRODUCTS_PK
LEAD_COMPETITOR_PROD_ID
Foreign Keys from this table:
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
[top of page]
OSM.AS_LEAD_COMP_PRODUCTS does not reference any database object
OSM.AS_LEAD_COMP_PRODUCTS is referenced by following:
APPS
SYNONYM - AS_LEAD_COMP_PRODUCTS
[top of page]
Table: AS_LEAD_CONTACTS_ALL
Description: Contains contacts linked to sales opportunities
Primary Key: AS_LEAD_CONTACTS_ALL_PK
LEAD_CONTACT_ID
Primary Key: AS_LEAD_CONTACTS_PK
LEAD_CONTACT_ID
Primary Key: AS_LEAD_CONTACTS_UK
CONTACT_ID
LEAD_ID
Foreign Keys from this table:
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
%
[top of page]
OSM.AS_LEAD_CONTACTS_ALL does not reference any database object
OSM.AS_LEAD_CONTACTS_ALL is referenced by following:
APPS
SYNONYM - AS_LEAD_CONTACTS_ALL
[top of page]
Table: AS_LEAD_DECISION_FACTORS
Description: Holds decision factors
Primary Key: AS_LEAD_DECISION_FACTORS_PK
LEAD_DECISION_FACTOR_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_LEAD_DECISION_FACTORS.LEAD_LINE_ID
AS_LEAD_LINES_ALL
[top of page]
OSM.AS_LEAD_DECISION_FACTORS does not reference any database object
OSM.AS_LEAD_DECISION_FACTORS is referenced by following:
APPS
SYNONYM - AS_LEAD_DECISION_FACTORS
[top of page]
Table: AS_LEAD_IMPORT_ERRORS
Description: Contains the error messages for imported sales leads
Primary Key: AS_LEAD_IMPORT_ERRORS_PK
LEAD_IMPORT_ERROR_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_LEAD_IMPORT_ERRORS.IMPORT_INTERFACE_ID
AS_IMPORT_INTERFACE
[top of page]
OSM.AS_LEAD_IMPORT_ERRORS does not reference any database object
OSM.AS_LEAD_IMPORT_ERRORS is referenced by following:
APPS
SYNONYM - AS_LEAD_IMPORT_ERRORS
[top of page]
Table: AS_LEAD_LINES_ALL
Description: Holds sales opportunity lines
Primary Key: AS_LEAD_LINES_ALL_PK
LEAD_LINE_ID
Primary Key: AS_LEAD_LINES_PK
LEAD_LINE_ID
Primary Key: AS_LEAD_LINES_UK
LEAD_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_LEAD_LINES_ALL.LEAD_ID
AS_LEADS_ALL
AS_LEAD_LINES_ALL.INVENTORY_ITEM_ID
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
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 Keys to this table:
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
[top of page]
OSM.AS_LEAD_LINES_ALL does not reference any database object
OSM.AS_LEAD_LINES_ALL is referenced by following:
APPS
TRIGGER - AS_LEAD_LINES_AFTER_BIUD
SYNONYM - AS_LEAD_LINES_ALL
TRIGGER - AS_LEAD_LINES_BIUD
[top of page]
Table: AS_LEAD_LINES_LOG
Description: Hold purchase line change history
Primary Key: AS_LEAD_LINES_LOG_PK
LOG_ID
[top of page]
OSM.AS_LEAD_LINES_LOG does not reference any database object
OSM.AS_LEAD_LINES_LOG is referenced by following:
APPS
SYNONYM - AS_LEAD_LINES_LOG
[top of page]
Table: AS_LEAD_LINE_ADJS
Description: Stores adjustments to lead (opportunity) lines.
Primary Key: AS_LEAD_LINE_ADJS_PK
LEAD_LINE_ADJUSTMENT_ID
[top of page]
OSM.AS_LEAD_LINE_ADJS does not reference any database object
OSM.AS_LEAD_LINE_ADJS is referenced by following:
APPS
SYNONYM - AS_LEAD_LINE_ADJS
[top of page]
Table: AS_LEAD_OBSTACLES
Description: Defines obstacles for sales opportunities
Primary Key: AS_LEAD_OBSTACLES_PK
LEAD_OBSTACLE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_LEAD_OBSTACLES.LEAD_ID
AS_LEADS_ALL
[top of page]
OSM.AS_LEAD_OBSTACLES does not reference any database object
OSM.AS_LEAD_OBSTACLES is referenced by following:
APPS
SYNONYM - AS_LEAD_OBSTACLES
[top of page]
Table: AS_LEAD_ORDERS
Description: Contains orders resulting from sales opportunities
Primary Key: AS_LEAD_ORDERS_PK
LEAD_ORDER_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_LEAD_ORDERS.LEAD_ID
AS_LEADS_ALL
[top of page]
OSM.AS_LEAD_ORDERS does not reference any database object
OSM.AS_LEAD_ORDERS is referenced by following:
APPS
SYNONYM - AS_LEAD_ORDERS
[top of page]
Table: AS_LETS_PARTNER_MAP
Description: Store partner information for Opportunity Exchange Transaction Server
[top of page]
OSM.AS_LETS_PARTNER_MAP does not reference any database object
OSM.AS_LETS_PARTNER_MAP is referenced by following:
APPS
SYNONYM - AS_LETS_PARTNER_MAP
[top of page]
Table: AS_LISTS_ALL
Description: Defines market and campaign lists
Primary Key: AS_LISTS_PK
LIST_ID
[top of page]
OSM.AS_LISTS_ALL does not reference any database object
OSM.AS_LISTS_ALL is referenced by following:
APPS
SYNONYM - AS_LISTS_ALL
[top of page]
Table: AS_LIST_ENTRIES
Description: Holds list entries
Primary Key: AS_LIST_ENTRIES_PK
LIST_ENTRY_ID
Foreign Keys from this table:
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 Keys to this table:
Foreign Key Column
Foreign Table
AS_COLLATERAL_REQ_ALL.LIST_ENTRY_ID
AS_LIST_ENTRIES
[top of page]
OSM.AS_LIST_ENTRIES does not reference any database object
OSM.AS_LIST_ENTRIES is referenced by following:
APPS
SYNONYM - AS_LIST_ENTRIES
[top of page]
Table: AS_LIST_ENTRY_USAGES
Description: Contains the assignement of list entries to the sales person and the promotion.
Primary Key: AS_LIST_ENTRY_USAGES_PK
PROMOTION_ID
LIST_ENTRY_ID
[top of page]
OSM.AS_LIST_ENTRY_USAGES does not reference any database object
OSM.AS_LIST_ENTRY_USAGES is referenced by following:
APPS
SYNONYM - AS_LIST_ENTRY_USAGES
[top of page]
Table: AS_LIST_QUERIES
Description: Stores the predefined criteria for list creation.
Primary Key: AS_LIST_QUERIES_PK
QUERY_ID
[top of page]
OSM.AS_LIST_QUERIES does not reference any database object
OSM.AS_LIST_QUERIES is referenced by following:
APPS
SYNONYM - AS_LIST_QUERIES
[top of page]
Table: AS_LIST_RULES
Description: This table stores the user-defined rules for identifying duplicates in a list.
Primary Key: AS_LIST_RULES_PK
LIST_RULE_ID
[top of page]
OSM.AS_LIST_RULES does not reference any database object
OSM.AS_LIST_RULES is referenced by following:
APPS
SYNONYM - AS_LIST_RULES
[top of page]
Table: AS_LIST_RULE_ENTRIES
Description: This table stores the columns that are used to identify duplicates in a list.
Primary Key: AS_LIST_RULE_ENTRIES_PK
LIST_RULE_ENTRY_ID
[top of page]
OSM.AS_LIST_RULE_ENTRIES does not reference any database object
OSM.AS_LIST_RULE_ENTRIES is referenced by following:
APPS
SYNONYM - AS_LIST_RULE_ENTRIES
[top of page]
Table: AS_LLOG_STATUS_SUMMARY
Description: Holds data for opportunity log status summary
Primary Key: AS_LLOG_STATUS_SUM_PK
LEAD_ID
STATUS_CODE
[top of page]
OSM.AS_LLOG_STATUS_SUMMARY does not reference any database object
OSM.AS_LLOG_STATUS_SUMMARY is referenced by following:
APPS
SYNONYM - AS_LLOG_STATUS_SUMMARY
[top of page]
Table: AS_LS_ERRS
Description: For Lead Sharing use
Primary Key: AS_LS_ERRS_PK
ERROR_ID
[top of page]
OSM.AS_LS_ERRS does not reference any database object
OSM.AS_LS_ERRS is referenced by following:
APPS
SYNONYM - AS_LS_ERRS
[top of page]
Table: AS_MC_REPORTING_CURR
Description: Holds reporting currencies
[top of page]
OSM.AS_MC_REPORTING_CURR does not reference any database object
OSM.AS_MC_REPORTING_CURR is referenced by following:
APPS
SYNONYM - AS_MC_REPORTING_CURR
[top of page]
Table: AS_MC_SALES_CREDITS_DEN
Description: Multi currency table to store sales credit amounts converted in various reporting currencies based on daily as well as pseudo period rates
Primary Key: AS_MC_SALES_CREDITS_DEN_PK
MC_SALES_CREDIT_ID
Foreign Keys from this table:
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
CONVERSION_TYPE
CONVERSION_PERIOD_SET_NAME
AS_MC_TYPE_MAPPINGS
AS_MC_SALES_CREDITS_DEN.CONVERSION_PERIOD_SET_NAME
CONVERSION_PERIOD_NAME
GL_PERIODS
[top of page]
OSM.AS_MC_SALES_CREDITS_DEN does not reference any database object
OSM.AS_MC_SALES_CREDITS_DEN is referenced by following:
APPS
SYNONYM - AS_MC_SALES_CREDITS_DEN
[top of page]
Table: AS_MC_TYPE_MAPPINGS
Description: Define the mapping from Period to Conversion_type.
Primary Key: AS_MC_TYPE_MAPPINGS_PK
PERIOD_TYPE
CONVERSION_TYPE
PERIOD_SET_NAME
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AS_MC_SALES_CREDITS_DEN.CONVERSION_PERIOD_TYPE
.CONVERSION_TYPE
.CONVERSION_PERIOD_SET_NAME
AS_MC_TYPE_MAPPINGS
[top of page]
OSM.AS_MC_TYPE_MAPPINGS does not reference any database object
OSM.AS_MC_TYPE_MAPPINGS is referenced by following:
APPS
SYNONYM - AS_MC_TYPE_MAPPINGS
[top of page]
Table: AS_MERGE_FILES_ALL
Description: Holds information about letter merge files
Primary Key: AS_MERGE_FILES_PK
MERGE_FILE_ID
Primary Key: AS_MERGE_FILES_UK
LIST_ID
[top of page]
OSM.AS_MERGE_FILES_ALL does not reference any database object
OSM.AS_MERGE_FILES_ALL is referenced by following:
APPS
SYNONYM - AS_MERGE_FILES_ALL
[top of page]
Table: AS_METH_STAGE_INSTANCES
Description: This table stores methodology stage instances.
Primary Key: AS_METH_STAGE_INSTANCES_PK
METH_STAGE_INSTANCE_ID
[top of page]
OSM.AS_METH_STAGE_INSTANCES does not reference any database object
OSM.AS_METH_STAGE_INSTANCES is referenced by following:
APPS
SYNONYM - AS_METH_STAGE_INSTANCES
[top of page]
Table: AS_METH_STEP_INSTANCES
Description: This table stores methodology step instances.
Primary Key: AS_METH_STEP_INSTANCES_PK
METH_STEP_INSTANCE_ID
[top of page]
OSM.AS_METH_STEP_INSTANCES does not reference any database object
OSM.AS_METH_STEP_INSTANCES is referenced by following:
APPS
SYNONYM - AS_METH_STEP_INSTANCES
[top of page]
Table: AS_MRP_FCT_DETAIL
Primary Key: AS_MRP_FCT_DETAIL_PK
AS_MRP_DETAIL_ID
[top of page]
OSM.AS_MRP_FCT_DETAIL does not reference any database object
OSM.AS_MRP_FCT_DETAIL is referenced by following:
APPS
SYNONYM - AS_MRP_FCT_DETAIL
[top of page]
Table: AS_MRP_FCT_REPORT
[top of page]
OSM.AS_MRP_FCT_REPORT does not reference any database object
OSM.AS_MRP_FCT_REPORT is referenced by following:
APPS
SYNONYM - AS_MRP_FCT_REPORT
[top of page]
Table: AS_MRP_INTERFACE
Description: Holds OSM-MRP interface header information
Primary Key: AS_MRP_INTERFACE_PK
SEQUENCE_ID
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AS_MRP_INTERFACE_LINES.SEQUENCE_ID
AS_MRP_INTERFACE
[top of page]
OSM.AS_MRP_INTERFACE does not reference any database object
OSM.AS_MRP_INTERFACE is referenced by following:
APPS
SYNONYM - AS_MRP_INTERFACE
[top of page]
Table: AS_MRP_INTERFACE_LINES
Description: Holds OSM-MRP interface lines information
Primary Key: AS_MRP_INTERFACE_LINES_PK
LINE_SEQUENCE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_MRP_INTERFACE_LINES.SEQUENCE_ID
AS_MRP_INTERFACE
[top of page]
OSM.AS_MRP_INTERFACE_LINES does not reference any database object
OSM.AS_MRP_INTERFACE_LINES is referenced by following:
APPS
SYNONYM - AS_MRP_INTERFACE_LINES
[top of page]
Table: AS_MRP_OPP_REPORT
Primary Key: FK_AS_MRP_INTERFACE
AS_MRP_OPP_ID
[top of page]
OSM.AS_MRP_OPP_REPORT does not reference any database object
OSM.AS_MRP_OPP_REPORT is referenced by following:
APPS
SYNONYM - AS_MRP_OPP_REPORT
[top of page]
Table: AS_OBJECT_ATTRIBUTES
Description: PRM related table
Primary Key: AS_OBJECT_ATTRIBUTES_PK
OBJECT_ATTRIBUTE_ID
[top of page]
OSM.AS_OBJECT_ATTRIBUTES does not reference any database object
OSM.AS_OBJECT_ATTRIBUTES is referenced by following:
APPS
SYNONYM - AS_OBJECT_ATTRIBUTES
[top of page]
Table: AS_OPP_WORKSHEET_LINES
Description: Table to store the forecast information on all possible opportunities for individual or sales group
Primary Key: AS_OPP_WORKSHEET_LINES_PK
FORECAST_WORKSHEET_ID
Foreign Keys from this table:
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
[top of page]
OSM.AS_OPP_WORKSHEET_LINES does not reference any database object
OSM.AS_OPP_WORKSHEET_LINES is referenced by following:
APPS
SYNONYM - AS_OPP_WORKSHEET_LINES
[top of page]
Table: AS_OSI_CONS_CCS_BASE
Description: This table is only for Oracle internal rollout.
Primary Key: AS_OSI_CONS_CCS_BASE_PK
CC
[top of page]
OSM.AS_OSI_CONS_CCS_BASE does not reference any database object
OSM.AS_OSI_CONS_CCS_BASE is referenced by following:
APPS
SYNONYM - AS_OSI_CONS_CCS_BASE
[top of page]
Table: AS_OSI_CONTR_NAMES_BASE
Description: This table is only for Oracle internal rollout.
Primary Key: AS_OSI_CONTR_NAMES_BASE_PK
CNAME_ID
[top of page]
OSM.AS_OSI_CONTR_NAMES_BASE does not reference any database object
OSM.AS_OSI_CONTR_NAMES_BASE is referenced by following:
APPS
SYNONYM - AS_OSI_CONTR_NAMES_BASE
[top of page]
Table: AS_OSI_CONTR_VHCL_BASE
Description: This table is only for Oracle internal rollout.
Primary Key: AS_OSI_CONTR_VHCL_BASE_PK
CVEHICLE
[top of page]
OSM.AS_OSI_CONTR_VHCL_BASE does not reference any database object
OSM.AS_OSI_CONTR_VHCL_BASE is referenced by following:
APPS
SYNONYM - AS_OSI_CONTR_VHCL_BASE
[top of page]
Table: AS_OSI_LEADS_ALL
Description: This table is only for Oracle internal rollout.
[top of page]
OSM.AS_OSI_LEADS_ALL does not reference any database object
OSM.AS_OSI_LEADS_ALL is referenced by following:
APPS
SYNONYM - AS_OSI_LEADS_ALL
[top of page]
Table: AS_OSI_LEADS_DENORM
Description: Denormalized table
Primary Key: AS_OSI_LEADS_DENORM_PK
OSI_LEAD_ID
[top of page]
OSM.AS_OSI_LEADS_DENORM does not reference any database object
OSM.AS_OSI_LEADS_DENORM is referenced by following:
APPS
SYNONYM - AS_OSI_LEADS_DENORM
[top of page]
Table: AS_OSI_LEAD_OVL_ALL
Description: This table is only for Oracle internal rollout.
[top of page]
OSM.AS_OSI_LEAD_OVL_ALL does not reference any database object
OSM.AS_OSI_LEAD_OVL_ALL is referenced by following:
APPS
SYNONYM - AS_OSI_LEAD_OVL_ALL
[top of page]
Table: AS_OSI_LOOKUP
Description: This table is only for Oracle internal rollout.
[top of page]
OSM.AS_OSI_LOOKUP does not reference any database object
OSM.AS_OSI_LOOKUP is referenced by following:
APPS
SYNONYM - AS_OSI_LOOKUP
[top of page]
Table: AS_OSI_OVERLAY_BASE
Description: This table is only for Oracle internal rollout.
Primary Key: AS_OSI_OVERLAYBASE_PK
OVM_CODE
[top of page]
OSM.AS_OSI_OVERLAY_BASE does not reference any database object
OSM.AS_OSI_OVERLAY_BASE is referenced by following:
APPS
SYNONYM - AS_OSI_OVERLAY_BASE
[top of page]
Table: AS_PARTNER_ACCESSES
Description: Stores the sales rep information for a lead in partner's OSO database.
[top of page]
OSM.AS_PARTNER_ACCESSES does not reference any database object
OSM.AS_PARTNER_ACCESSES is referenced by following:
APPS
SYNONYM - AS_PARTNER_ACCESSES
[top of page]
Table: AS_PARTNER_LEAD_CONTACTS
Description: Stores the contact information for a lead in partner's OSO database.
[top of page]
OSM.AS_PARTNER_LEAD_CONTACTS does not reference any database object
OSM.AS_PARTNER_LEAD_CONTACTS is referenced by following:
APPS
SYNONYM - AS_PARTNER_LEAD_CONTACTS
[top of page]
Table: AS_PARTNER_LEAD_LINES
Description: Stores the contact information for a lead in partner's OSO database.
[top of page]
OSM.AS_PARTNER_LEAD_LINES does not reference any database object
OSM.AS_PARTNER_LEAD_LINES is referenced by following:
APPS
SYNONYM - AS_PARTNER_LEAD_LINES
[top of page]
Table: AS_PARTNER_LEAD_NOTES
Description: Stores the Notes information for a lead in partner's OSO database.
[top of page]
OSM.AS_PARTNER_LEAD_NOTES does not reference any database object
OSM.AS_PARTNER_LEAD_NOTES is referenced by following:
APPS
SYNONYM - AS_PARTNER_LEAD_NOTES
[top of page]
Table: AS_PARTNER_MAP
Primary Key: AS_PARTNER_MAP_PK
PARTNER_ID
[top of page]
OSM.AS_PARTNER_MAP does not reference any database object
OSM.AS_PARTNER_MAP is referenced by following:
APPS
SYNONYM - AS_PARTNER_MAP
[top of page]
Table: AS_PERIOD_DAYS
Description: simplifies gl_periods
[top of page]
OSM.AS_PERIOD_DAYS does not reference any database object
OSM.AS_PERIOD_DAYS is referenced by following:
APPS
MATERIALIZED VIEW - AS_FORECAST_MV
SYNONYM - AS_PERIOD_DAYS
[top of page]
Table: AS_PERIOD_RATES
Description: Holds currency conversion rates
Primary Key: AS_PERIOD_RATES_PK
PERIOD_RATE_ID
[top of page]
OSM.AS_PERIOD_RATES does not reference any database object
OSM.AS_PERIOD_RATES is referenced by following:
APPS
MATERIALIZED VIEW - AS_FORECAST_MV
SYNONYM - AS_PERIOD_RATES
[top of page]
Table: AS_PE_INT_CATEGORIES
Description: Mapping table between plan elements in osc and forecast
Primary Key: AS_PE_INT_CATEGORIES_PK
PE_INT_CATEGORY_ID
Foreign Keys from this table:
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
[top of page]
OSM.AS_PE_INT_CATEGORIES does not reference any database object
OSM.AS_PE_INT_CATEGORIES is referenced by following:
APPS
SYNONYM - AS_PE_INT_CATEGORIES
[top of page]
Table: AS_PHONE_FORMATS
Description: Defines valid phone formats for a particular country
Primary Key: AS_PHONE_FORMATS_PK
PHONE_FORMAT_ID
[top of page]
OSM.AS_PHONE_FORMATS does not reference any database object
OSM.AS_PHONE_FORMATS is referenced by following:
APPS
SYNONYM - AS_PHONE_FORMATS
[top of page]
Table: AS_PRICE_LISTS
Primary Key: AS_PRICE_LISTS_PK
PRICE_LIST_ID
GROUP_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_PRICE_LISTS.PRICE_LIST_ID
QP_LIST_HEADERS_B
AS_PRICE_LISTS.GROUP_ID
AS_PRICE_LIST_GROUPS
[top of page]
OSM.AS_PRICE_LISTS does not reference any database object
OSM.AS_PRICE_LISTS is referenced by following:
APPS
SYNONYM - AS_PRICE_LISTS
[top of page]
Table: AS_PRICE_LIST_GROUPS
Description: Price lists groups
Primary Key: AS_PRICE_LIST_GROUPS_PK
GROUP_ID
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AS_PRICE_LISTS.GROUP_ID
AS_PRICE_LIST_GROUPS
[top of page]
OSM.AS_PRICE_LIST_GROUPS does not reference any database object
OSM.AS_PRICE_LIST_GROUPS is referenced by following:
APPS
SYNONYM - AS_PRICE_LIST_GROUPS
[top of page]
Table: AS_PRODUCT_FILTERS
Primary Key: AS_PRDUCT_FILTERS_PK1
PRODUCT_FILTER_ID
[top of page]
OSM.AS_PRODUCT_FILTERS does not reference any database object
OSM.AS_PRODUCT_FILTERS is referenced by following:
APPS
SYNONYM - AS_PRODUCT_FILTERS
[top of page]
Table: AS_PROD_WORKSHEET_LINES
Description: Table to store the forecast information on all possible product categories for individual or sales group
Primary Key: AS_PROD_WORKSHEET_LINES_PK
PROD_WORKSHEET_LINE_ID
Foreign Keys from this table:
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
[top of page]
OSM.AS_PROD_WORKSHEET_LINES does not reference any database object
OSM.AS_PROD_WORKSHEET_LINES is referenced by following:
APPS
SYNONYM - AS_PROD_WORKSHEET_LINES
[top of page]
Table: AS_PROMOTIONS_ALL
Description: Defines promotions
Primary Key: AS_PROMOTIONS_PK
PROMOTION_ID
Primary Key: AS_PROMOTIONS_UK
CODE
Primary Key: AS_PROMOTIONS_UK2
TYPE
NAME
Foreign Keys from this table:
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
COLLATERAL_ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B
Foreign Keys to this table:
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
[top of page]
OSM.AS_PROMOTIONS_ALL does not reference any database object
OSM.AS_PROMOTIONS_ALL is referenced by following:
APPS
SYNONYM - AS_PROMOTIONS_ALL
[top of page]
Table: AS_PROMOTION_RELATIONSHIPS
Description: Defines promotion relationships
Primary Key: AS_PROM_RELATIONS_PK
PROMOTION_RELATIONSHIP_ID
Primary Key: AS_PROM_RELATIONS_UK
PARENT_PROMOTION_ID
CHILD_PROMOTION_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_PROMOTION_RELATIONSHIPS.PARENT_PROMOTION_ID
AS_PROMOTIONS_ALL
AS_PROMOTION_RELATIONSHIPS.CHILD_PROMOTION_ID
AS_PROMOTIONS_ALL
[top of page]
OSM.AS_PROMOTION_RELATIONSHIPS does not reference any database object
OSM.AS_PROMOTION_RELATIONSHIPS is referenced by following:
APPS
SYNONYM - AS_PROMOTION_RELATIONSHIPS
[top of page]
Table: AS_PROMOTION_SCRIPTS
Description: Holds scripts linked to promotions
Primary Key: AS_PROM_SCRIPTS_PK
SCRIPT_ID
PROMOTION_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_PROMOTION_SCRIPTS.SCRIPT_ID
AS_PROMOTIONS_ALL
AS_PROMOTION_SCRIPTS.PROMOTION_ID
AS_PROMOTIONS_ALL
[top of page]
OSM.AS_PROMOTION_SCRIPTS does not reference any database object
OSM.AS_PROMOTION_SCRIPTS is referenced by following:
APPS
SYNONYM - AS_PROMOTION_SCRIPTS
[top of page]
Table: AS_QUOTA_PROFILES
Primary Key: AS_QUOTA_PROFILES_PK
QUOTA_PROFILE_ID
Foreign Keys from this table:
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
%
[top of page]
OSM.AS_QUOTA_PROFILES does not reference any database object
OSM.AS_QUOTA_PROFILES is referenced by following:
APPS
SYNONYM - AS_QUOTA_PROFILES
[top of page]
Table: AS_QUOTES_ALL
Description: Defines quotations
Primary Key: AS_QUOTES_PK
QUOTE_ID
[top of page]
OSM.AS_QUOTES_ALL does not reference any database object
OSM.AS_QUOTES_ALL is referenced by following:
APPS
SYNONYM - AS_QUOTES_ALL
[top of page]
Table: AS_QUOTE_LINES_ALL
Description: Holds quotation lines information
Primary Key: AS_QUOTE_LINES_PK
QUOTE_LINE_ID
[top of page]
OSM.AS_QUOTE_LINES_ALL does not reference any database object
OSM.AS_QUOTE_LINES_ALL is referenced by following:
APPS
SYNONYM - AS_QUOTE_LINES_ALL
[top of page]
Table: AS_QUOTE_STATUS_LOG
Description: Tracks changes of quote status and quote version
[top of page]
OSM.AS_QUOTE_STATUS_LOG does not reference any database object
OSM.AS_QUOTE_STATUS_LOG is referenced by following:
APPS
SYNONYM - AS_QUOTE_STATUS_LOG
[top of page]
Table: AS_RELATIONSHIPS
Description: This table stores relationships between entities.
Primary Key: AS_RELATIONSHIPS_PK
RELATIONSHIP_ID
[top of page]
OSM.AS_RELATIONSHIPS does not reference any database object
OSM.AS_RELATIONSHIPS is referenced by following:
APPS
SYNONYM - AS_RELATIONSHIPS
[top of page]
Table: AS_REPORTING_MANAGERS
Description: Denormalized table derived from AS_SALESFORCE.
Primary Key: AS_REP_MANAGERS_PK
PERSON_ID
MANAGER_PERSON_ID
[top of page]
OSM.AS_REPORTING_MANAGERS does not reference any database object
OSM.AS_REPORTING_MANAGERS is referenced by following:
APPS
SYNONYM - AS_REPORTING_MANAGERS
[top of page]
Table: AS_ROLLING_CALENDARS
Description: Stores Rolling Calendars for Sales Forecasts
Primary Key: AS_ROLLING_CALENDAR_PK
FREEZE_PERIOD
[top of page]
OSM.AS_ROLLING_CALENDARS does not reference any database object
OSM.AS_ROLLING_CALENDARS is referenced by following:
APPS
SYNONYM - AS_ROLLING_CALENDARS
[top of page]
Table: AS_ROLLING_PERIODS
Description: Stores Rolling Periods within rolling calendars for Sales Forecasts
Primary Key: AS_ROLLING_PERIODS_PK
PERIOD_NAME
FREEZE_PERIOD
[top of page]
OSM.AS_ROLLING_PERIODS does not reference any database object
OSM.AS_ROLLING_PERIODS is referenced by following:
APPS
SYNONYM - AS_ROLLING_PERIODS
[top of page]
Table: AS_SALESFORCE
Description: Obsolete Defines the salesforce
Primary Key: AS_SALESFORCE_PK
SALESFORCE_ID
Foreign Keys from this table:
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 Keys to this table:
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
[top of page]
OSM.AS_SALESFORCE does not reference any database object
OSM.AS_SALESFORCE is referenced by following:
APPS
SYNONYM - AS_SALESFORCE
[top of page]
Table: AS_SALESREP_JOBS
Description: Defines sales representative jobs
Primary Key: AS_SALESREP_JOBS_PK
JOB_ID
[top of page]
OSM.AS_SALESREP_JOBS does not reference any database object
OSM.AS_SALESREP_JOBS is referenced by following:
APPS
SYNONYM - AS_SALESREP_JOBS
[top of page]
Table: AS_SALES_CREDITS
Description: Holds sales credits
Primary Key: AS_SALES_CREDITS_PK
SALES_CREDIT_ID
Foreign Keys from this table:
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 Keys to this table:
Foreign Key Column
Foreign Table
AS_SALES_CREDITS_DENORM.SALES_CREDIT_ID
AS_SALES_CREDITS
[top of page]
OSM.AS_SALES_CREDITS does not reference any database object
OSM.AS_SALES_CREDITS is referenced by following:
APPS
SYNONYM - AS_SALES_CREDITS
TRIGGER - AS_SALES_CREDITS_AFTER_BIUD
TRIGGER - AS_SALES_CREDITS_BIUD
[top of page]
Table: AS_SALES_CREDITS_DENORM
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
Primary Key: AS_SALES_CREDITS_DENORM_PK
SALES_CREDIT_ID
Foreign Keys from this table:
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 Keys to this table:
Foreign Key Column
Foreign Table
AS_MC_SALES_CREDITS_DEN.SALES_CREDIT_ID
AS_SALES_CREDITS_DENORM
[top of page]
OSM.AS_SALES_CREDITS_DENORM does not reference any database object
OSM.AS_SALES_CREDITS_DENORM is referenced by following:
APPS
MATERIALIZED VIEW - AS_FORECAST_MV
SYNONYM - AS_SALES_CREDITS_DENORM
[top of page]
Table: AS_SALES_CREDITS_LOG
Description: Holds sales credit change history
Primary Key: AS_SALES_CREDITS_LOG_PK
LOG_ID
[top of page]
OSM.AS_SALES_CREDITS_LOG does not reference any database object
OSM.AS_SALES_CREDITS_LOG is referenced by following:
APPS
SYNONYM - AS_SALES_CREDITS_LOG
[top of page]
Table: AS_SALES_CREDIT_ADJS
Description: Stores adjustments to sales credits.
Primary Key: AS_SALES_CREDIT_ADJS_PK
SALES_CREDIT_ADJUSTMENT_ID
[top of page]
OSM.AS_SALES_CREDIT_ADJS does not reference any database object
OSM.AS_SALES_CREDIT_ADJS is referenced by following:
APPS
SYNONYM - AS_SALES_CREDIT_ADJS
[top of page]
Table: AS_SALES_GROUPS
Description: Defines sales groups
Primary Key: AS_SALES_GROUPS_PK
SALES_GROUP_ID
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AS_SALESFORCE.SALES_GROUP_ID
AS_SALES_GROUPS
[top of page]
OSM.AS_SALES_GROUPS does not reference any database object
OSM.AS_SALES_GROUPS is referenced by following:
APPS
SYNONYM - AS_SALES_GROUPS
[top of page]
Table: AS_SALES_GROUPS_DENORM
Description: Denormalized table derived from AS_SALES_GROUPS
Primary Key: AS_SALES_GROUPS_DENORM_PK
SALES_GROUP_ID
PARENT_SALES_GROUP_ID
[top of page]
OSM.AS_SALES_GROUPS_DENORM does not reference any database object
OSM.AS_SALES_GROUPS_DENORM is referenced by following:
APPS
SYNONYM - AS_SALES_GROUPS_DENORM
[top of page]
Table: AS_SALES_GRP_ADMIN
Description: Defines administrators for sales groups
Primary Key: AS_SALES_GROUP_ADMINS_PK
SALES_GROUP_ID
[top of page]
OSM.AS_SALES_GRP_ADMIN does not reference any database object
OSM.AS_SALES_GRP_ADMIN is referenced by following:
APPS
SYNONYM - AS_SALES_GRP_ADMIN
[top of page]
Table: AS_SALES_LEADS
Description: Holds sales leads
Primary Key: AS_SALES_LEADS_PK
SALES_LEAD_ID
Foreign Keys from this table:
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 Keys to this table:
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
[top of page]
OSM.AS_SALES_LEADS does not reference any database object
OSM.AS_SALES_LEADS is referenced by following:
APPS
SYNONYM - AS_SALES_LEADS
TRIGGER - AS_SALES_LEADS_BIUD
[top of page]
Table: AS_SALES_LEADS_LOG
Description: Holds opportunity change history
Primary Key: AS_SALES_LEADS_LOG_PK
LOG_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_SALES_LEADS_LOG.SALES_LEAD_ID
AS_SALES_LEADS
[top of page]
OSM.AS_SALES_LEADS_LOG does not reference any database object
OSM.AS_SALES_LEADS_LOG is referenced by following:
APPS
SYNONYM - AS_SALES_LEADS_LOG
[top of page]
Table: AS_SALES_LEAD_CARD_RULES
Description: Holds the score and description information for a score card rule
Primary Key: AS_SALES_LEAD_CARD_RULES_PK
CARD_RULE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_SALES_LEAD_CARD_RULES.SCORECARD_ID
AS_SALES_LEAD_SCORECARDS
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AS_CARD_RULE_QUAL_VALUES.CARD_RULE_ID
AS_SALES_LEAD_CARD_RULES
[top of page]
OSM.AS_SALES_LEAD_CARD_RULES does not reference any database object
OSM.AS_SALES_LEAD_CARD_RULES is referenced by following:
APPS
SYNONYM - AS_SALES_LEAD_CARD_RULES
[top of page]
Table: AS_SALES_LEAD_CONTACTS
Description: Holds contact information for the Lead. Records can be deleted.
Primary Key: AS_SALES_LEAD_CONTACTS_PK
LEAD_CONTACT_ID
Primary Key: AS_SALES_LEAD_CONTACTS_UK
SALES_LEAD_ID
CONTACT_ID
Foreign Keys from this table:
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
[top of page]
OSM.AS_SALES_LEAD_CONTACTS does not reference any database object
OSM.AS_SALES_LEAD_CONTACTS is referenced by following:
APPS
SYNONYM - AS_SALES_LEAD_CONTACTS
[top of page]
Table: AS_SALES_LEAD_LINES
Description: Holds sales lead lines informaiton
Primary Key: AS_SALES_LEAD_LINES_PK
SALES_LEAD_LINE_ID
Foreign Keys from this table:
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
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 Keys to this table:
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
[top of page]
OSM.AS_SALES_LEAD_LINES does not reference any database object
OSM.AS_SALES_LEAD_LINES is referenced by following:
APPS
SYNONYM - AS_SALES_LEAD_LINES
TRIGGER - AS_SALES_LEAD_LINES_BIUD
[top of page]
Table: AS_SALES_LEAD_OPPORTUNITY
Description: Holds the linking information between sales leads and opportunity. Records can not be deleted.
Primary Key: AS_SALES_LEAD_OPPTY_U1
LEAD_OPPORTUNITY_ID
Primary Key: AS_SALES_LEAD_OPP_PK
LEAD_OPPORTUNITY_ID
Primary Key: AS_SALES_LEAD_OPP_U1
LEAD_OPPORTUNITY_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_SALES_LEAD_OPPORTUNITY.OPPORTUNITY_ID
AS_LEADS_ALL
AS_SALES_LEAD_OPPORTUNITY.SALES_LEAD_ID
AS_SALES_LEADS
[top of page]
OSM.AS_SALES_LEAD_OPPORTUNITY does not reference any database object
OSM.AS_SALES_LEAD_OPPORTUNITY is referenced by following:
APPS
SYNONYM - AS_SALES_LEAD_OPPORTUNITY
[top of page]
Table: AS_SALES_LEAD_OPP_LINES
Description: Holds the linking information between sales lead linesand opportunity lines
Primary Key: AS_SALES_LEAD_OPP_LINES_PK
LEAD_OPP_LINE_ID
Foreign Keys from this table:
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
[top of page]
OSM.AS_SALES_LEAD_OPP_LINES does not reference any database object
OSM.AS_SALES_LEAD_OPP_LINES is referenced by following:
APPS
SYNONYM - AS_SALES_LEAD_OPP_LINES
[top of page]
Table: AS_SALES_LEAD_OWNERS
Description: Holds lead owners information
Primary Key: AS_SALES_LEAD_OWNERS_PK
LEAD_OWNER_ID
[top of page]
OSM.AS_SALES_LEAD_OWNERS does not reference any database object
OSM.AS_SALES_LEAD_OWNERS is referenced by following:
APPS
SYNONYM - AS_SALES_LEAD_OWNERS
[top of page]
Table: AS_SALES_LEAD_QUALS_B
Description: Holds information about the columns which are used in scorecard rules
Primary Key: AS_SALES_LEAD_QUALS_B_PK
SEED_QUAL_ID
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AS_CARD_RULE_QUAL_VALUES.SEED_QUAL_ID
AS_SALES_LEAD_QUALS_B
[top of page]
OSM.AS_SALES_LEAD_QUALS_B does not reference any database object
OSM.AS_SALES_LEAD_QUALS_B is referenced by following:
APPS
SYNONYM - AS_SALES_LEAD_QUALS_B
[top of page]
Table: AS_SALES_LEAD_QUALS_TL
Description: Holds transalation information for multi lingual support
Primary Key: AS_SALES_LEAD_QUALS_TL_PK
LANGUAGE
SEED_QUAL_ID
[top of page]
OSM.AS_SALES_LEAD_QUALS_TL does not reference any database object
OSM.AS_SALES_LEAD_QUALS_TL is referenced by following:
APPS
SYNONYM - AS_SALES_LEAD_QUALS_TL
[top of page]
Table: AS_SALES_LEAD_RANKS_B
Description: Defines the various ranks a lead can have
Primary Key: AS_SALES_LEAD_RANKS_B_PK
RANK_ID
Foreign Keys to this table:
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
[top of page]
OSM.AS_SALES_LEAD_RANKS_B does not reference any database object
OSM.AS_SALES_LEAD_RANKS_B is referenced by following:
APPS
SYNONYM - AS_SALES_LEAD_RANKS_B
[top of page]
Table: AS_SALES_LEAD_RANKS_TL
Description: Holds transalation information for multi lingual support
Primary Key: AS_SALES_LEAD_RANKS_TL_PK
RANK_ID
LANGUAGE
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_SALES_LEAD_RANKS_TL.RANK_ID
AS_SALES_LEAD_RANKS_B
[top of page]
OSM.AS_SALES_LEAD_RANKS_TL does not reference any database object
OSM.AS_SALES_LEAD_RANKS_TL is referenced by following:
APPS
SYNONYM - AS_SALES_LEAD_RANKS_TL
MATERIALIZED VIEW - BIM_I_ATTR_NAME_MV
[top of page]
Table: AS_SALES_LEAD_SCORECARDS
Description: Holds the score card information
Primary Key: AS_SALES_LEAD_SCORECARDS_PK
SCORECARD_ID
Foreign Keys to this table:
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
[top of page]
OSM.AS_SALES_LEAD_SCORECARDS does not reference any database object
OSM.AS_SALES_LEAD_SCORECARDS is referenced by following:
APPS
SYNONYM - AS_SALES_LEAD_SCORECARDS
[top of page]
Table: AS_SALES_LEAD_SEED_QUAL_B
Description: Holds information about the columns which are used in scorecard rules
Primary Key: AS_SALES_LEAD_SEED_QUAL_B_PK
SEED_QUAL_ID
[top of page]
OSM.AS_SALES_LEAD_SEED_QUAL_B does not reference any database object
OSM.AS_SALES_LEAD_SEED_QUAL_B is referenced by following:
APPS
SYNONYM - AS_SALES_LEAD_SEED_QUAL_B
[top of page]
Table: AS_SALES_METHODOLOGY_B
Description: Define Sales Methodologies
Primary Key: AS_SALES_METHODOLOGY_B_PK
SALES_METHODOLOGY_ID
Foreign Keys to this table:
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
[top of page]
OSM.AS_SALES_METHODOLOGY_B does not reference any database object
OSM.AS_SALES_METHODOLOGY_B is referenced by following:
APPS
SYNONYM - AS_SALES_METHODOLOGY_B
[top of page]
Table: AS_SALES_METHODOLOGY_TL
Description: For MLS - Translated columns of AS_SALES_METHODOLOGY_B
Primary Key: AS_SALES_METHODOLOGY_TL_PK
LANGUAGE
SALES_METHODOLOGY_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_SALES_METHODOLOGY_TL.SALES_METHODOLOGY_ID
AS_SALES_METHODOLOGY_B
[top of page]
OSM.AS_SALES_METHODOLOGY_TL does not reference any database object
OSM.AS_SALES_METHODOLOGY_TL is referenced by following:
APPS
SYNONYM - AS_SALES_METHODOLOGY_TL
[top of page]
Table: AS_SALES_METH_STAGE_MAP
Description: Table for mapping Sales Stages with Task Template Groups
Primary Key: AS_SALES_METH_STAGE_MAP_PK
SALES_STAGE_ID
SALES_METHODOLOGY_ID
Foreign Keys from this table:
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
[top of page]
OSM.AS_SALES_METH_STAGE_MAP does not reference any database object
OSM.AS_SALES_METH_STAGE_MAP is referenced by following:
APPS
SYNONYM - AS_SALES_METH_STAGE_MAP
[top of page]
Table: AS_SALES_METH_TASK_MAP
Description: Stores information about task created automatically by the sales methodology
Primary Key: AS_SALES_METH_TASK_MAP_PK
OBJECT_ID
OBJECT_NAME
OBJECT_TYPE_CODE
SALES_METHODOLOGY_ID
TASK_ID
Foreign Keys from this table:
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
[top of page]
OSM.AS_SALES_METH_TASK_MAP does not reference any database object
OSM.AS_SALES_METH_TASK_MAP is referenced by following:
APPS
SYNONYM - AS_SALES_METH_TASK_MAP
[top of page]
Table: AS_SALES_QUOTAS
Description: Defines sales quotas
Primary Key: AS_SALES_QUOTAS_PK
SALES_QUOTA_ID
Foreign Keys from this table:
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 Keys to this table:
Foreign Key Column
Foreign Table
AS_PROD_WORKSHEET_LINES.SALES_QUOTA_ID
AS_SALES_QUOTAS
[top of page]
OSM.AS_SALES_QUOTAS does not reference any database object
OSM.AS_SALES_QUOTAS is referenced by following:
APPS
SYNONYM - AS_SALES_QUOTAS
[top of page]
Table: AS_SALES_STAGES_ALL_B
Description: Defines sales stages
Primary Key: AS_SALES_STAGES_ALL_B_PK
SALES_STAGE_ID
Foreign Keys from this table:
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 Keys to this table:
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
[top of page]
OSM.AS_SALES_STAGES_ALL_B does not reference any database object
OSM.AS_SALES_STAGES_ALL_B is referenced by following:
APPS
SYNONYM - AS_SALES_STAGES_ALL_B
[top of page]
Table: AS_SALES_STAGES_ALL_TL
Description: For MLS - Translated columns of AS_SALES_STAGES_ALL_B
Primary Key: AS_SALES_STAGES_ALL_TL_PK
SALES_STAGE_ID
LANGUAGE
Primary Key: AS_SALES_STAGES_ALL_TL_UK
LANGUAGE
NAME
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_SALES_STAGES_ALL_TL.SALES_STAGE_ID
AS_SALES_STAGES_ALL_B
[top of page]
OSM.AS_SALES_STAGES_ALL_TL does not reference any database object
OSM.AS_SALES_STAGES_ALL_TL is referenced by following:
APPS
SYNONYM - AS_SALES_STAGES_ALL_TL
[top of page]
Table: AS_SCRIPT_ACTUAL_ANSWERS
Description: Holds answers for script questions
Primary Key: AS_SCR_ACT_ANSWERS_PK
SCRIPT_ACTUAL_ANSWER_ID
Primary Key: AS_SCR_ACT_ANSWERS_UK
PRE_DEF_ANSWER_ID
QUESTION_ID
Foreign Keys from this table:
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
[top of page]
OSM.AS_SCRIPT_ACTUAL_ANSWERS does not reference any database object
OSM.AS_SCRIPT_ACTUAL_ANSWERS is referenced by following:
APPS
SYNONYM - AS_SCRIPT_ACTUAL_ANSWERS
[top of page]
Table: AS_SCRIPT_ANSWER_ACTIONS_ALL
Description: Holds actions resulting from script answers
Primary Key: AS_SCR_ANS_ACTIONS_PK
SCRIPT_ANSWER_ACTION_ID
Foreign Keys from this table:
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
ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B
[top of page]
OSM.AS_SCRIPT_ANSWER_ACTIONS_ALL does not reference any database object
OSM.AS_SCRIPT_ANSWER_ACTIONS_ALL is referenced by following:
APPS
SYNONYM - AS_SCRIPT_ANSWER_ACTIONS_ALL
[top of page]
Table: AS_SCRIPT_PRE_DEFINED_ANSWERS
Description: Defines answers to script questions
Primary Key: AS_SCR_PREDEF_ANSWERS_PK
SCRIPT_PRE_DEF_ANSWER_ID
Primary Key: AS_SCR_PREDEF_ANSWERS_UK
SCRIPT_ID
LABEL
Foreign Keys from this table:
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 Keys to this table:
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
[top of page]
OSM.AS_SCRIPT_PRE_DEFINED_ANSWERS does not reference any database object
OSM.AS_SCRIPT_PRE_DEFINED_ANSWERS is referenced by following:
APPS
SYNONYM - AS_SCRIPT_PRE_DEFINED_ANSWERS
[top of page]
Table: AS_SCRIPT_QUESTIONS
Description: Defines script questions
Primary Key: AS_SCRIPT_QUESTIONS_PK
SCRIPT_QUESTION_ID
Primary Key: AS_SCRIPT_QUESTIONS_UK
QUESTION_SEQ
SCRIPT_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_SCRIPT_QUESTIONS.SCRIPT_ID
AS_PROMOTIONS_ALL
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AS_SCRIPT_ACTUAL_ANSWERS.QUESTION_ID
AS_SCRIPT_QUESTIONS
AS_SCRIPT_PRE_DEFINED_ANSWERS.QUESTION_ID
AS_SCRIPT_QUESTIONS
[top of page]
OSM.AS_SCRIPT_QUESTIONS does not reference any database object
OSM.AS_SCRIPT_QUESTIONS is referenced by following:
APPS
SYNONYM - AS_SCRIPT_QUESTIONS
[top of page]
Table: AS_SERVERS
Primary Key: AS_SERVERS_PK
SERVER_ID
[top of page]
OSM.AS_SERVERS does not reference any database object
OSM.AS_SERVERS is referenced by following:
APPS
SYNONYM - AS_SERVERS
[top of page]
Table: AS_STATUSES_B
Description: Hold three types of status, opportunity, lead and quote
Primary Key: AS_STATUSES_B_PK
STATUS_CODE
Foreign Keys to this table:
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
[top of page]
OSM.AS_STATUSES_B does not reference any database object
OSM.AS_STATUSES_B is referenced by following:
APPS
SYNONYM - AS_STATUSES_B
MATERIALIZED VIEW - BIM_I_ATTR_NAME_MV
[top of page]
Table: AS_STATUSES_TL
Description: For MLS, Translated columns of AS_STATUSES_B
Primary Key: AS_STATUSES_TL_PK
LANGUAGE
Primary Key: AS_STATUSES_TL_UK
LANGUAGE
MEANING
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_STATUSES_TL.STATUS_CODE
AS_STATUSES_B
[top of page]
OSM.AS_STATUSES_TL does not reference any database object
OSM.AS_STATUSES_TL is referenced by following:
APPS
SYNONYM - AS_STATUSES_TL
MATERIALIZED VIEW - BIM_I_ATTR_NAME_MV
[top of page]
Table: AS_TAP_PURGE_WORKING
Description: The working table for TAP purge program
[top of page]
OSM.AS_TAP_PURGE_WORKING does not reference any database object
OSM.AS_TAP_PURGE_WORKING is referenced by following:
APPS
SYNONYM - AS_TAP_PURGE_WORKING
[top of page]
Table: AS_TERRITORIES_ALL
Description: Obsolete Sales out to JTF Terr Core -- Holds territory definitions
Primary Key: AS_TERRITORIES_PK
TERRITORY_ID
Foreign Keys from this table:
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 Keys to this table:
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
[top of page]
OSM.AS_TERRITORIES_ALL does not reference any database object
OSM.AS_TERRITORIES_ALL is referenced by following:
APPS
SYNONYM - AS_TERRITORIES_ALL
[top of page]
Table: AS_TERRITORY_ACCESSES
Description: Defines territory accesses
Primary Key: AS_TERRITORY_ACCESSES_PK
ACCESS_ID
TERRITORY_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_TERRITORY_ACCESSES.TERRITORY_ID
JTF_TERR_ALL
AS_TERRITORY_ACCESSES.ACCESS_ID
AS_ACCESSES_ALL_ALL
[top of page]
OSM.AS_TERRITORY_ACCESSES does not reference any database object
OSM.AS_TERRITORY_ACCESSES is referenced by following:
APPS
SYNONYM - AS_TERRITORY_ACCESSES
[top of page]
Table: AS_TERRITORY_ACC_PURGE_TEMP
[top of page]
OSM.AS_TERRITORY_ACC_PURGE_TEMP does not reference any database object
OSM.AS_TERRITORY_ACC_PURGE_TEMP is referenced by following:
APPS
SYNONYM - AS_TERRITORY_ACC_PURGE_TEMP
[top of page]
Table: AS_TERRITORY_GROUPS_ALL
Description: Obsolete Defines territory groups
Primary Key: AS_TERRITORY_GROUPS_PK
TERRITORY_GROUP_ID
Primary Key: AS_TERRITORY_GROUPS_UK
NAME
Foreign Keys to this table:
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
[top of page]
OSM.AS_TERRITORY_GROUPS_ALL does not reference any database object
OSM.AS_TERRITORY_GROUPS_ALL is referenced by following:
APPS
SYNONYM - AS_TERRITORY_GROUPS_ALL
[top of page]
Table: AS_TERRITORY_ROLLUPS
Description: Defines rollup territories
Primary Key: AS_TERRITORY_ROLLUPS_PK
TERRITORY_ID
ROLLUP_TERRITORY_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_TERRITORY_ROLLUPS.TERRITORY_ID
AS_TERRITORIES_ALL
AS_TERRITORY_ROLLUPS.ROLLUP_TERRITORY_ID
AS_TERRITORIES_ALL
[top of page]
OSM.AS_TERRITORY_ROLLUPS does not reference any database object
OSM.AS_TERRITORY_ROLLUPS is referenced by following:
APPS
SYNONYM - AS_TERRITORY_ROLLUPS
[top of page]
Table: AS_TERRITORY_TYPES_ALL
Description: Obsolete To JTF Terr Core Defines territory types
Primary Key: AS_TERRITORY_TYPES_ALL_PK
TERRITORY_TYPE_ID
Primary Key: AS_TERRITORY_TYPES_PK
TERRITORY_TYPE_ID
Primary Key: AS_TERRITORY_TYPES_UK
NAME
Foreign Keys from this table:
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 Keys to this table:
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
[top of page]
OSM.AS_TERRITORY_TYPES_ALL does not reference any database object
OSM.AS_TERRITORY_TYPES_ALL is referenced by following:
APPS
SYNONYM - AS_TERRITORY_TYPES_ALL
[top of page]
Table: AS_TERRITORY_VALUES_ALL
Description: Obsolete To JTF Terr Core Holds territory values
Primary Key: AS_TERRITORY_VALUES_ALL_PK
TERRITORY_VALUE_ID
Primary Key: AS_TERRITORY_VALUES_PK
TERRITORY_VALUE_ID
Primary Key: AS_TERRITORY_VALUES_UK
TERRITORY_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_TERRITORY_VALUES_ALL.INVENTORY_ITEM_ID
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
ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B
[top of page]
OSM.AS_TERRITORY_VALUES_ALL does not reference any database object
OSM.AS_TERRITORY_VALUES_ALL is referenced by following:
APPS
SYNONYM - AS_TERRITORY_VALUES_ALL
[top of page]
Table: AS_TERR_RESOURCES_TMP
Description: Hold territory assignment results.
Foreign Keys from this table:
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
[top of page]
OSM.AS_TERR_RESOURCES_TMP does not reference any database object
OSM.AS_TERR_RESOURCES_TMP is referenced by following:
APPS
SYNONYM - AS_TERR_RESOURCES_TMP
[top of page]
Table: AS_TERR_ROLLUPS_IMMEDIATE_TMP
Description: Temporary table used by the Territory program
[top of page]
OSM.AS_TERR_ROLLUPS_IMMEDIATE_TMP does not reference any database object
OSM.AS_TERR_ROLLUPS_IMMEDIATE_TMP is referenced by following:
APPS
SYNONYM - AS_TERR_ROLLUPS_IMMEDIATE_TMP
[top of page]
Table: AS_TERR_SEEDED_QUALIFIERS_ALL
Description: Defines qualifiers for territory definitions
Primary Key: AS_TERR_SEED_QUALIFIERS_B_PK
SEEDED_QUALIFIER_ID
ORG_ID
Primary Key: AS_TERR_SEED_QUALIFIERS_B_UK
NAME
ORG_ID
[top of page]
OSM.AS_TERR_SEEDED_QUALIFIERS_ALL does not reference any database object
OSM.AS_TERR_SEEDED_QUALIFIERS_ALL is referenced by following:
APPS
SYNONYM - AS_TERR_SEEDED_QUALIFIERS_ALL
[top of page]
Table: AS_TERR_TYPE_QUALIFIERS
Description: Holds territory type and qualifier combinations
Primary Key: AS_TERR_TYPE_QUALS_PK
TERR_TYPE_QUALIFIER_ID
Primary Key: AS_TERR_TYPE_QUALS_UK
SEEDED_QUALIFIER_ID
TERRITORY_TYPE_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
AS_TERR_TYPE_QUALIFIERS.TERRITORY_TYPE_ID
AS_TERRITORY_TYPES_ALL
[top of page]
OSM.AS_TERR_TYPE_QUALIFIERS does not reference any database object
OSM.AS_TERR_TYPE_QUALIFIERS is referenced by following:
APPS
SYNONYM - AS_TERR_TYPE_QUALIFIERS
[top of page]
Table: AS_TODO_LISTS_ALL
Description: Obsolete Holds activities for sales representatives
Primary Key: AS_TODO_LISTS_PK
TODO_ID
[top of page]
OSM.AS_TODO_LISTS_ALL does not reference any database object
OSM.AS_TODO_LISTS_ALL is referenced by following:
APPS
SYNONYM - AS_TODO_LISTS_ALL
[top of page]
Table: AS_TRANSFER_DETAILS
Description: For Lead Sharing use
Primary Key: AS_TRANSFER_DETAILS_PK
PARTNER_TRANSACTION_DETAIL_ID
[top of page]
OSM.AS_TRANSFER_DETAILS does not reference any database object
OSM.AS_TRANSFER_DETAILS is referenced by following:
APPS
SYNONYM - AS_TRANSFER_DETAILS
[top of page]
Table: AS_TRANSFER_QUES
Description: For Lead Sharing use
Primary Key: AS_TRANSFER_QUES_PK
PARTNER_TRANSACTION_ID
[top of page]
OSM.AS_TRANSFER_QUES does not reference any database object
OSM.AS_TRANSFER_QUES is referenced by following:
APPS
SYNONYM - AS_TRANSFER_QUES
[top of page]
Table: AS_WORD_REPLACEMENTS
Description: Defines word replacement rules for Fuzzy Find functionality
Primary Key: AS_WORD_REPLACEMENTS_PK
ORIGINAL_WORD
[top of page]
OSM.AS_WORD_REPLACEMENTS does not reference any database object
OSM.AS_WORD_REPLACEMENTS is referenced by following:
APPS
SYNONYM - AS_WORD_REPLACEMENTS
[top of page]
Table: HR_ALL_ORGANIZATION_UNITS
Description: - Retrofitted
[top of page]
HR.HR_ALL_ORGANIZATION_UNITS does not reference any database object
HR.HR_ALL_ORGANIZATION_UNITS is referenced by following:
APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
TRIGGER - HR_ALL_ORGANIZATION_UNITS_OVN
TRIGGER - HR_ALL_ORGANIZATION_UNITS_WHO
[top of page]
View: AS_ACCESSES
[top of page]
APPS.AS_ACCESSES references the following:
APPS
SYNONYM - AS_ACCESSES_ALL_ALL
APPS.AS_ACCESSES is referenced by following:
APPS
PACKAGE BODY - AS_ACCESS_PVT
PACKAGE BODY - AS_OPP_SALES_CREDIT_PVT
VIEW - AS_TERRITORY_ACCESSES_V
PACKAGE BODY - PV_MATCH_V2_PUB
[top of page]
View: AS_ACCESSES_ACTIVE_V
[top of page]
APPS.AS_ACCESSES_ACTIVE_V references the following:
APPS
VIEW - AS_ACCESSES_ALL
SYNONYM - AS_LEADS_ALL
VIEW - AS_LOOKUPS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
SYNONYM - JTF_RS_GROUPS_TL
SYNONYM - JTF_RS_RESOURCE_EXTNS
VIEW - PER_PEOPLE_X
APPS.AS_ACCESSES_ACTIVE_V is not referenced by any database object
[top of page]
View: AS_ACCESSES_ALL
[top of page]
APPS.AS_ACCESSES_ALL references the following:
APPS
SYNONYM - AS_ACCESSES_ALL_ALL
APPS.AS_ACCESSES_ALL is referenced by following:
APPS
PACKAGE BODY - AML_PURGE_SALES_LEADS
VIEW - AMS_DS_ACCESSES_ALL_V
VIEW - AMS_DS_GROUP_ACCESSES_ALL_V
PACKAGE BODY - ASL_EXCEL_UTIL_PVT
PACKAGE BODY - ASN_MIG_SALES_CREDITS_PVT
PACKAGE BODY - ASN_MIG_SALES_TEAM_PVT
PACKAGE BODY - ASO_OPP_QTE_PUB
PACKAGE BODY - ASO_VALIDATE_PVT
PACKAGE BODY - ASP_ALERTS_PUB
PACKAGE BODY - ASP_CONTACT_PREF_SECURITY_PUB
PACKAGE BODY - AST_ASN_INTEROP
VIEW - AST_LM_OPP_QUICK_SGRP_V
VIEW - AST_LM_OPP_QUICK_SREP_V
VIEW - AST_MYTEAM_SALESLEAD_UWQ_REF_V
VIEW - AST_MYTEAM_SALESLEAD_UWQ_S_V
VIEW - AST_MYTEAM_SALESLEAD_UWQ_V
VIEW - AST_MYTEAM_SALESOPP_CODE_UWQ_V
VIEW - AST_MYTEAM_SALESOPP_NAME_UWQ_V
VIEW - AST_MYTEAM_SALESOPP_UWQ_REF_V
VIEW - AST_MYTEAM_SALESOPP_UWQ_R_S_V
VIEW - AST_MYTEAM_SALESOPP_UWQ_V
PACKAGE BODY - AST_ROUTING_PUB
VIEW - AST_SALESOPP_CODE_UWQ_V
VIEW - AST_SALESOPP_NAME_UWQ_V
VIEW - AST_SALESOPP_UWQ_REF_SUB_V
VIEW - AST_SALESOPP_UWQ_REF_V
VIEW - AST_SALESOPP_UWQ_V
VIEW - AST_SALES_OPP_UWQ_V
VIEW - AST_SALES_TEAM_EMP_V
VIEW - AST_SALES_TEAM_PTR_V
PACKAGE BODY - AST_UWQ_OLIST_WORK_ACTION
VIEW - AS_ACCESSES_ACTIVE_V
VIEW - AS_ACCESSES_ALL_DFV
PACKAGE BODY - AS_ACCESSES_PKG
PACKAGE BODY - AS_ACCESS_PVT
PACKAGE BODY - AS_GAR_LEADS_PUB
PACKAGE BODY - AS_GAR_OPPTYS_PUB
PACKAGE BODY - AS_JTF_RS_GROUP_MEM_TRG
PACKAGE BODY - AS_LEAD_ROUTING_WF
PACKAGE BODY - AS_LEAD_ROUTING_WF_CUHK
PACKAGE BODY - AS_OPPORTUNITY_PUB
PACKAGE BODY - AS_OPP_COPY_PVT
PACKAGE BODY - AS_OPP_HEADER_PVT
PACKAGE BODY - AS_PIPELINE_MOVE_PUB
PACKAGE BODY - AS_RESOURCE_MERGE_PUB
PACKAGE BODY - AS_RTTAP_ACCOUNT
PACKAGE BODY - AS_RTTAP_OPPTY
PACKAGE BODY - AS_SALES_LEADS_PUB
PACKAGE BODY - AS_SALES_LEADS_PVT
PACKAGE BODY - AS_SALES_LEAD_ASSIGN_PVT
PACKAGE BODY - AS_SALES_LEAD_ENGINE_PVT
PACKAGE BODY - AS_SALES_LEAD_OPP_PVT
PACKAGE BODY - AS_SALES_LEAD_RANKS_PVT
PACKAGE BODY - AS_SALES_LEAD_REFERRAL
VIEW - AS_SALES_OPP_UWQ_V
VIEW - AS_SALES_TEAM_DISTINCT_V
VIEW - AS_SALES_TEAM_EMP_V
VIEW - AS_SALES_TEAM_PTR_V
VIEW - AS_SALES_TEAM_V
PACKAGE BODY - AS_STATUSES_PKG
PACKAGE BODY - AS_TAP_MERGE_PKG
PACKAGE BODY - HZ_PURGE_GEN
PACKAGE BODY - JTF_TTY_CATCHALL_WORKFLOW
PACKAGE BODY - JTF_TTY_POP_TERR_ADMIN_BIN_PVT
VIEW - PA_PROJ_REQUEST_DIRECTORY_V
PACKAGE BODY - PV_ASSIGNMENT_PUB
PACKAGE BODY - PV_ASSIGNMENT_PVT
PACKAGE BODY - PV_ASSIGN_UTIL_PVT
PACKAGE BODY - PV_AS_ACCESS_VHUK
PACKAGE BODY - PV_BENFT_STATUS_CHANGE
PACKAGE BODY - PV_OPPORTUNITY_VHUK
VIEW - PV_PRTNR_SALES_TEAM_V
PACKAGE BODY - PV_REFERRAL_GENERAL_PUB
PACKAGE BODY - PV_SLSTEAM_MIGRTN_PVT
[top of page]
View: AS_ACCESS_TERRITORIES_SUM_V
[top of page]
APPS.AS_ACCESS_TERRITORIES_SUM_V references the following:
APPS
VIEW - AS_LOOKUPS
SYNONYM - AS_TERRITORY_ACCESSES
SYNONYM - JTF_TERR
APPS.AS_ACCESS_TERRITORIES_SUM_V is not referenced by any database object
[top of page]
View: AS_CHANGED_ACCOUNTS
[top of page]
APPS.AS_CHANGED_ACCOUNTS references the following:
APPS
SYNONYM - AS_CHANGED_ACCOUNTS_ALL
APPS.AS_CHANGED_ACCOUNTS is referenced by following:
APPS
PACKAGE BODY - AS_ATA_NEW_PUB
[top of page]
View: AS_COLLATERAL_CAT
[top of page]
APPS.AS_COLLATERAL_CAT references the following:
APPS
SYNONYM - AS_COLLATERAL_CAT_ALL
APPS.AS_COLLATERAL_CAT is not referenced by any database object
[top of page]
View: AS_COLLATERAL_KITS
[top of page]
APPS.AS_COLLATERAL_KITS references the following:
APPS
SYNONYM - AS_COLLATERAL_KITS_ALL
APPS.AS_COLLATERAL_KITS is not referenced by any database object
[top of page]
View: AS_COLLATERAL_REQ
[top of page]
APPS.AS_COLLATERAL_REQ references the following:
APPS
SYNONYM - AS_COLLATERAL_REQ_ALL
APPS.AS_COLLATERAL_REQ is not referenced by any database object
[top of page]
View: AS_CURRENT_ENVIRONMENT_V
[top of page]
APPS.AS_CURRENT_ENVIRONMENT_V references the following:
APPS
SYNONYM - AS_CURRENT_ENVIRONMENT
VIEW - AS_INTEREST_CODES_V
VIEW - AS_INTEREST_TYPES_VL
VIEW - AS_LOOKUPS
APPS.AS_CURRENT_ENVIRONMENT_V is not referenced by any database object
[top of page]
View: AS_EVENT_FACILITIES
[top of page]
APPS.AS_EVENT_FACILITIES references the following:
APPS
SYNONYM - AS_EVENT_FACILITIES_ALL
APPS.AS_EVENT_FACILITIES is referenced by following:
APPS
VIEW - ICX_AS_EVENT_FACILITIES_V
[top of page]
View: AS_EVENT_LETTERS
[top of page]
APPS.AS_EVENT_LETTERS references the following:
APPS
SYNONYM - AS_EVENT_LETTERS_ALL
APPS.AS_EVENT_LETTERS is not referenced by any database object
[top of page]
View: AS_EVENT_NAMES
[top of page]
APPS.AS_EVENT_NAMES references the following:
APPS
SYNONYM - AS_EVENT_NAMES_ALL
APPS.AS_EVENT_NAMES is not referenced by any database object
[top of page]
View: AS_EXCHANGES_VL
[top of page]
APPS.AS_EXCHANGES_VL references the following:
APPS
SYNONYM - AS_EXCHANGES_B
SYNONYM - AS_EXCHANGES_TL
APPS.AS_EXCHANGES_VL is not referenced by any database object
[top of page]
View: AS_FC_SALESFORCE_V
[top of page]
APPS.AS_FC_SALESFORCE_V references the following:
APPS
SYNONYM - JTF_RS_GROUP_MEMBERS
SYNONYM - JTF_RS_RESOURCE_EXTNS
SYNONYM - JTF_RS_ROLES_B
SYNONYM - JTF_RS_ROLES_TL
SYNONYM - JTF_RS_ROLE_RELATIONS
APPS.AS_FC_SALESFORCE_V is referenced by following:
APPS
PACKAGE BODY - ASL_EXCEL_UTIL_PVT
PACKAGE BODY - AS_OPP_LINE_PVT
PACKAGE BODY - AS_SALES_ORG_MANAGER_PVT
[top of page]
View: AS_FC_SALES_GROUPS_V
[top of page]
APPS.AS_FC_SALES_GROUPS_V references the following:
APPS
SYNONYM - JTF_RS_GROUPS_B
SYNONYM - JTF_RS_GROUPS_TL
SYNONYM - JTF_RS_GROUP_MEMBERS
SYNONYM - JTF_RS_GROUP_USAGES
SYNONYM - JTF_RS_GRP_RELATIONS
SYNONYM - JTF_RS_ROLES_B
SYNONYM - JTF_RS_ROLE_RELATIONS
APPS.AS_FC_SALES_GROUPS_V is not referenced by any database object
[top of page]
View: AS_FORECAST_CATEGORIES_VL
[top of page]
APPS.AS_FORECAST_CATEGORIES_VL references the following:
APPS
SYNONYM - AS_FORECAST_CATEGORIES_B
SYNONYM - AS_FORECAST_CATEGORIES_TL
APPS.AS_FORECAST_CATEGORIES_VL is referenced by following:
APPS
SYNONYM - AS_FORECAST_CATEGORIES
[top of page]
View: AS_FORECAST_PROB
[top of page]
APPS.AS_FORECAST_PROB references the following:
APPS
SYNONYM - AS_FORECAST_PROB_ALL_B
APPS.AS_FORECAST_PROB is referenced by following:
APPS
PACKAGE BODY - AST_OFL_PIPELINE_BUCKETS_PARAM
PACKAGE BODY - AS_OPP_HEADER_PVT
[top of page]
View: AS_FORECAST_PROB_ALL_VL
[top of page]
APPS.AS_FORECAST_PROB_ALL_VL references the following:
APPS
SYNONYM - AS_FORECAST_PROB_ALL_B
SYNONYM - AS_FORECAST_PROB_ALL_TL
APPS.AS_FORECAST_PROB_ALL_VL is referenced by following:
APPS
VIEW - AMS_LOOKUP_SALES_V
VIEW - PA_AS_PROBABILITIES_V
PACKAGE BODY - PA_PROJECT_REQUEST_PVT
[top of page]
View: AS_FORECAST_PROB_VL
[top of page]
APPS.AS_FORECAST_PROB_VL references the following:
APPS
SYNONYM - AS_FORECAST_PROB_ALL_B
SYNONYM - AS_FORECAST_PROB_ALL_TL
APPS.AS_FORECAST_PROB_VL is not referenced by any database object
[top of page]
View: AS_FST_SALES_CATEGORIES_V
[top of page]
APPS.AS_FST_SALES_CATEGORIES_V references the following:
APPS
SYNONYM - AS_FORECAST_CATEGORIES
SYNONYM - AS_FST_SALES_CATEGORIES
SYNONYM - AS_INTEREST_TYPES_TL
APPS.AS_FST_SALES_CATEGORIES_V is not referenced by any database object
[top of page]
View: AS_FUNDS_VL
[top of page]
APPS.AS_FUNDS_VL references the following:
APPS
SYNONYM - AS_FUNDS_B
SYNONYM - AS_FUNDS_TL
APPS.AS_FUNDS_VL is not referenced by any database object
[top of page]
View: AS_FUND_CONTACTS_V
[top of page]
APPS.AS_FUND_CONTACTS_V references the following:
APPS
SYNONYM - AS_FUNDS_B
SYNONYM - AS_FUNDS_TL
SYNONYM - AS_FUND_CONTACTS
SYNONYM - HZ_PARTIES
APPS.AS_FUND_CONTACTS_V is not referenced by any database object
[top of page]
View: AS_FUND_DETAILS_V
[top of page]
APPS.AS_FUND_DETAILS_V references the following:
APPS
SYNONYM - AS_FUNDS_B
SYNONYM - AS_FUNDS_TL
SYNONYM - AS_ISSUES_B
SYNONYM - AS_ISSUES_TL
SYNONYM - AS_ISSUE_GROUPS_TL
SYNONYM - HZ_PARTIES
APPS.AS_FUND_DETAILS_V is not referenced by any database object
[top of page]
View: AS_FUND_ISSUES_V
[top of page]
APPS.AS_FUND_ISSUES_V references the following:
APPS
SYNONYM - AS_FUNDS_B
SYNONYM - AS_FUNDS_TL
SYNONYM - AS_GROUP_ISSUE_MAP
SYNONYM - AS_ISSUES_B
SYNONYM - AS_ISSUES_TL
SYNONYM - AS_ISSUE_GROUPS_B
SYNONYM - AS_ISSUE_GROUPS_TL
APPS.AS_FUND_ISSUES_V is not referenced by any database object
[top of page]
View: AS_IMP_SL_V
[top of page]
APPS.AS_IMP_SL_V references the following:
APPS
SYNONYM - AS_IMPORT_INTERFACE
APPS.AS_IMP_SL_V is not referenced by any database object
[top of page]
View: AS_INTERESTS
[top of page]
APPS.AS_INTERESTS references the following:
APPS
SYNONYM - AS_INTERESTS_ALL
APPS.AS_INTERESTS is referenced by following:
APPS
VIEW - AST_CONTACT_CLASSIFICATION_V
PACKAGE BODY - AS_INTERESTS_PKG
VIEW - AS_INTERESTS_V
PACKAGE BODY - AS_INTEREST_PVT
VIEW - AS_OPP_CLASSIFICATION_V
VIEW - AS_SITE_CLASSIFICATION_V
[top of page]
View: AS_INTERESTS_V
[top of page]
APPS.AS_INTERESTS_V references the following:
APPS
VIEW - AS_INTERESTS
VIEW - AS_INTEREST_CODES_V
VIEW - AS_INTEREST_TYPES_VL
VIEW - AS_LOOKUPS
APPS.AS_INTERESTS_V is not referenced by any database object
[top of page]
View: AS_INTEREST_CATEGORY_SETS
[top of page]
APPS.AS_INTEREST_CATEGORY_SETS references the following:
APPS
SYNONYM - AS_INTEREST_CATEGORY_SETS_ALL
APPS.AS_INTEREST_CATEGORY_SETS is referenced by following:
APPS
PACKAGE BODY - AS_INTEREST_CATEGORY_SETS_PKG
VIEW - AS_INTEREST_CATEGORY_SETS_V
[top of page]
View: AS_INTEREST_CATEGORY_SETS_V
[top of page]
APPS.AS_INTEREST_CATEGORY_SETS_V references the following:
APPS
VIEW - AS_INTEREST_CATEGORY_SETS
VIEW - AS_INTEREST_TYPES_VL
VIEW - MTL_CATEGORY_SETS_VL
APPS.AS_INTEREST_CATEGORY_SETS_V is not referenced by any database object
[top of page]
View: AS_INTEREST_CODES_MC_V
[top of page]
APPS.AS_INTEREST_CODES_MC_V references the following:
APPS
SYNONYM - AS_INTEREST_CODES_MC
VIEW - AS_INTEREST_CODES_V
APPS.AS_INTEREST_CODES_MC_V is not referenced by any database object
[top of page]
View: AS_INTEREST_CODES_V
[top of page]
APPS.AS_INTEREST_CODES_V references the following:
APPS
SYNONYM - AS_INTEREST_CODES_B
SYNONYM - AS_INTEREST_CODES_TL
APPS.AS_INTEREST_CODES_V is referenced by following:
APPS
VIEW - AST_CONTACT_CLASSIFICATION_V
VIEW - AS_CURRENT_ENVIRONMENT_V
VIEW - AS_INTERESTS_V
VIEW - AS_INTEREST_CODES_MC_V
PACKAGE BODY - AS_INTEREST_PUB
VIEW - AS_PRIMARY_INTERESTS_ACTIVE_V
VIEW - AS_SECOND_INTERESTS_ACTIVE_V
VIEW - AS_SITE_CLASSIFICATION_V
PACKAGE BODY - EDW_ITEMS_M_SIZE
VIEW - EDW_ITEM_PROD_CATG_LCV
VIEW - EDW_ITEM_PROD_GRP_LCV
VIEW - PA_LEAD_CLASSIFICATIONS_V
[top of page]
View: AS_INTEREST_CODES_VL
[top of page]
APPS.AS_INTEREST_CODES_VL references the following:
APPS
SYNONYM - AS_INTEREST_CODES_B
SYNONYM - AS_INTEREST_CODES_TL
APPS.AS_INTEREST_CODES_VL is referenced by following:
APPS
PACKAGE BODY - AML_CATEGORY_MIGRATION
VIEW - AMS_ACCT_INTEREST_V
VIEW - AMS_LEAD_ACCOUNTS_V
VIEW - AST_PURCH_LINES_V
PACKAGE BODY - AS_INTEREST_CODES_PUB
VIEW - AS_OPP_CLASSIFICATION_V
PACKAGE BODY - PV_CATEGORY_MIGRATION
[top of page]
View: AS_INTEREST_STATUSES_ACTIVE_V
[top of page]
APPS.AS_INTEREST_STATUSES_ACTIVE_V references the following:
APPS
SYNONYM - AS_INTEREST_STATUSES
VIEW - AS_LOOKUPS
APPS.AS_INTEREST_STATUSES_ACTIVE_V is not referenced by any database object
[top of page]
View: AS_INTEREST_STATUSES_V
[top of page]
APPS.AS_INTEREST_STATUSES_V references the following:
APPS
SYNONYM - AS_INTEREST_STATUSES
VIEW - AS_LOOKUPS
APPS.AS_INTEREST_STATUSES_V is not referenced by any database object
[top of page]
View: AS_INTEREST_TYPES
[top of page]
APPS.AS_INTEREST_TYPES references the following:
APPS
SYNONYM - AS_INTEREST_TYPES_ALL
APPS.AS_INTEREST_TYPES is not referenced by any database object
[top of page]
View: AS_INTEREST_TYPES_V
[top of page]
APPS.AS_INTEREST_TYPES_V references the following:
APPS
SYNONYM - AS_INTEREST_TYPES_B
SYNONYM - AS_INTEREST_TYPES_TL
APPS.AS_INTEREST_TYPES_V is referenced by following:
APPS
VIEW - BIS_INTEREST_TYPES_V
PACKAGE BODY - EDW_ITEMS_M_SIZE
VIEW - EDW_ITEM_PROD_CATG_LCV
VIEW - EDW_ITEM_PROD_GRP_LCV
VIEW - EDW_ITEM_PROD_LINE_LCV
VIEW - PA_LEAD_CLASSIFICATIONS_V
[top of page]
View: AS_INTEREST_TYPES_VL
[top of page]
APPS.AS_INTEREST_TYPES_VL references the following:
APPS
SYNONYM - AS_INTEREST_TYPES_B
SYNONYM - AS_INTEREST_TYPES_TL
APPS.AS_INTEREST_TYPES_VL is referenced by following:
APPS
PACKAGE BODY - AML_CATEGORY_MIGRATION
VIEW - AMS_ACCT_INTEREST_V
VIEW - AMS_LEAD_ACCOUNTS_V
VIEW - AST_CONTACT_CLASSIFICATION_V
VIEW - AST_PURCH_LINES_V
VIEW - AS_CURRENT_ENVIRONMENT_V
VIEW - AS_INTERESTS_V
VIEW - AS_INTEREST_CATEGORY_SETS_V
PACKAGE BODY - AS_INTEREST_CODES_PUB
PACKAGE BODY - AS_INTEREST_PUB
PACKAGE BODY - AS_INTEREST_TYPES_PUB
VIEW - AS_OPP_CLASSIFICATION_V
VIEW - AS_PRIMARY_INTERESTS_ACTIVE_V
VIEW - AS_SECOND_INTERESTS_ACTIVE_V
VIEW - AS_SITE_CLASSIFICATION_V
PACKAGE BODY - PV_CATEGORY_MIGRATION
[top of page]
View: AS_INV_ITEM_LOV_V
[top of page]
APPS.AS_INV_ITEM_LOV_V references the following:
APPS
SYNONYM - AS_INTEREST_CODES_B
SYNONYM - AS_INTEREST_TYPES_B
SYNONYM - FND_ID_FLEX_STRUCTURES
SYNONYM - MTL_CATEGORIES_B
SYNONYM - MTL_ITEM_CATEGORIES
VIEW - MTL_SYSTEM_ITEMS_VL
APPS.AS_INV_ITEM_LOV_V is referenced by following:
APPS
PACKAGE BODY - AS_OPP_LINE_PVT
VIEW - BIL_DIMV_SLSPROD_HIER
[top of page]
View: AS_INV_UOM_V
[top of page]
APPS.AS_INV_UOM_V references the following:
APPS
SYNONYM - MTL_SYSTEM_ITEMS_B
VIEW - MTL_UNITS_OF_MEASURE_VL
APPS.AS_INV_UOM_V is not referenced by any database object
[top of page]
View: AS_ISSUES_VL
[top of page]
APPS.AS_ISSUES_VL references the following:
APPS
SYNONYM - AS_ISSUES_B
SYNONYM - AS_ISSUES_TL
APPS.AS_ISSUES_VL is not referenced by any database object
[top of page]
View: AS_ISSUE_GROUPS_VL
[top of page]
APPS.AS_ISSUE_GROUPS_VL references the following:
APPS
SYNONYM - AS_ISSUE_GROUPS_B
SYNONYM - AS_ISSUE_GROUPS_TL
APPS.AS_ISSUE_GROUPS_VL is not referenced by any database object
[top of page]
View: AS_ISSUE_GROUP_DETAILS_V
[top of page]
APPS.AS_ISSUE_GROUP_DETAILS_V references the following:
APPS
SYNONYM - AS_ISSUE_GROUPS_B
SYNONYM - AS_ISSUE_GROUPS_TL
SYNONYM - AS_ISSUE_GROUP_IDFR
SYNONYM - AS_ISSUE_GROUP_TYPES
APPS.AS_ISSUE_GROUP_DETAILS_V is not referenced by any database object
[top of page]
View: AS_ISSUE_GROUP_ISSUES_V
[top of page]
APPS.AS_ISSUE_GROUP_ISSUES_V references the following:
APPS
SYNONYM - AS_GROUP_ISSUE_MAP
SYNONYM - AS_ISSUES_B
SYNONYM - AS_ISSUES_TL
SYNONYM - AS_ISSUE_GROUPS_B
SYNONYM - AS_ISSUE_GROUPS_TL
APPS.AS_ISSUE_GROUP_ISSUES_V is not referenced by any database object
[top of page]
View: AS_ISSUE_GROUP_PARTIES_V
[top of page]
APPS.AS_ISSUE_GROUP_PARTIES_V references the following:
APPS
SYNONYM - AS_GROUP_PARTY_MAP
SYNONYM - AS_ISSUE_GROUPS_B
SYNONYM - AS_ISSUE_GROUPS_TL
SYNONYM - HZ_PARTIES
APPS.AS_ISSUE_GROUP_PARTIES_V is not referenced by any database object
[top of page]
View: AS_ISSUE_LISTING_VL
[top of page]
APPS.AS_ISSUE_LISTING_VL references the following:
APPS
SYNONYM - AS_ISSUE_LISTING_B
SYNONYM - AS_ISSUE_LISTING_TL
APPS.AS_ISSUE_LISTING_VL is not referenced by any database object
[top of page]
View: AS_LANGUAGES_ACTIVE_V
[top of page]
APPS.AS_LANGUAGES_ACTIVE_V references the following:
APPS
VIEW - AS_LOOKUPS
APPS.AS_LANGUAGES_ACTIVE_V is not referenced by any database object
[top of page]
View: AS_LEADS
[top of page]
APPS.AS_LEADS references the following:
APPS
SYNONYM - AS_LEADS_ALL
APPS.AS_LEADS is referenced by following:
APPS
PACKAGE BODY - AS_ACCESS_PVT
PACKAGE BODY - AS_COMPETITOR_PROD_PVT
PACKAGE BODY - AS_OPP_CONTACT_PVT
PACKAGE BODY - AS_OPP_HEADER_PVT
PACKAGE BODY - AS_OPP_LINE_PVT
PACKAGE BODY - AS_OPP_SALES_CREDIT_PVT
VIEW - AS_TERRITORY_ACCESSES_V
PACKAGE BODY - PA_PROJECT_REQUEST_PVT
[top of page]
View: AS_LEAD_CONTACTS
[top of page]
APPS.AS_LEAD_CONTACTS references the following:
APPS
SYNONYM - AS_LEAD_CONTACTS_ALL
APPS.AS_LEAD_CONTACTS is referenced by following:
APPS
PACKAGE BODY - AST_UWQ_WRAPPER_PKG
PACKAGE BODY - AS_ACCESS_PUB
PACKAGE BODY - AS_LEAD_CONTACTS_PKG
PACKAGE BODY - AS_OPP_CONTACT_PVT
PACKAGE BODY - AS_OPP_COPY_PVT
PACKAGE BODY - PV_ASSIGNMENT_PUB
[top of page]
View: AS_LEAD_LINES
[top of page]
APPS.AS_LEAD_LINES references the following:
APPS
SYNONYM - AS_LEAD_LINES_ALL
APPS.AS_LEAD_LINES is referenced by following:
APPS
PACKAGE BODY - ASN_MIG_SALES_CREDITS_PVT
VIEW - AST_PURCH_LINES_V
PACKAGE BODY - AS_BUSINESS_EVENT_PVT
PACKAGE BODY - AS_COMPETITOR_PROD_PVT
PACKAGE BODY - AS_DECISION_FACTOR_PVT
PACKAGE BODY - AS_LEAD_LINES_PKG
PACKAGE BODY - AS_OPP_LINE_PVT
PACKAGE BODY - AS_OPP_SALES_CREDIT_PVT
PACKAGE BODY - AS_SC_DENORM_TRG
PACKAGE BODY - PV_OPPORTUNITY_VHUK
[top of page]
View: AS_LISTS
[top of page]
APPS.AS_LISTS references the following:
APPS
SYNONYM - AS_LISTS_ALL
APPS.AS_LISTS is not referenced by any database object
[top of page]
View: AS_LOOKUPS
[top of page]
APPS.AS_LOOKUPS references the following:
APPS
SYNONYM - FND_LOOKUP_VALUES
APPS.AS_LOOKUPS is referenced by following:
APPS
PACKAGE BODY - AML_MONITOR_WF
PACKAGE BODY - AML_TIMEFRAME_PVT
VIEW - AMS_DS_SALES_LEADS_V
VIEW - AMS_LOOKUP_SALES_V
VIEW - AST_CONTACT_CLASSIFICATION_V
VIEW - AST_CONT_CLASSIFICATION_INT_V
VIEW - AST_LM_LEADS_QUICK_CAMPAIGN_V
VIEW - AST_LM_LEADS_QUICK_GROUP_V
VIEW - AST_LM_LEADS_QUICK_INTEREST_V
VIEW - AST_LM_LEADS_QUICK_INT_PC_V
VIEW - AST_LM_LEADS_QUICK_V
VIEW - AST_LS_SALES_LEADS_BSC_V
VIEW - AST_LS_SALES_LEADS_CONTACT_V
VIEW - AST_LS_SALES_LEADS_V
VIEW - AST_MYTEAM_SALESLEAD_UWQ_V
VIEW - AST_MYTEAM_SALESOPP_CODE_UWQ_V
VIEW - AST_MYTEAM_SALESOPP_NAME_UWQ_V
VIEW - AST_MYTEAM_SALESOPP_UWQ_V
VIEW - AST_PLIST_OPP_UWQ_V
VIEW - AST_SALESLEAD_UWQ_V
VIEW - AST_SALESOPP_CODE_UWQ_V
VIEW - AST_SALESOPP_NAME_UWQ_V
VIEW - AST_SALESOPP_UWQ_V
VIEW - AST_SALES_LEADS_BALI_V
VIEW - AST_SALES_LEADS_EBC_V
VIEW - AST_SALES_LEADS_REL_BALI_V
VIEW - AST_SALES_LEADS_V
VIEW - AST_SALES_LEAD_CONTACTS_V
VIEW - AST_SALES_TEAM_EMP_V
VIEW - AST_SALES_TEAM_PTR_V
VIEW - AS_ACCESSES_ACTIVE_V
VIEW - AS_ACCESS_TERRITORIES_SUM_V
PACKAGE BODY - AS_COMPETITOR_PROD_PVT
VIEW - AS_CURRENT_ENVIRONMENT_V
PACKAGE BODY - AS_DECISION_FACTOR_PVT
PACKAGE BODY - AS_FOUNDATION_PVT
PACKAGE BODY - AS_IMPORT_SL_PVT
VIEW - AS_INTERESTS_V
PACKAGE BODY - AS_INTEREST_PUB
VIEW - AS_INTEREST_STATUSES_ACTIVE_V
VIEW - AS_INTEREST_STATUSES_V
VIEW - AS_LANGUAGES_ACTIVE_V
VIEW - AS_OPPORTUNITY_DETAILS_V
VIEW - AS_OPPORTUNITY_OBSTACLES_V
VIEW - AS_OPP_CLASSIFICATION_V
PACKAGE BODY - AS_OPP_CONTACT_PVT
PACKAGE BODY - AS_OPP_HEADER_PVT
PACKAGE BODY - AS_OPP_OBSTACLE_PVT
PACKAGE BODY - AS_SALES_LEADS_PVT
VIEW - AS_SALES_LEADS_V
PACKAGE BODY - AS_SALES_LEAD_CONTACTS_PVT
VIEW - AS_SALES_LEAD_CONTACTS_V
PACKAGE BODY - AS_SALES_LEAD_REFERRAL
VIEW - AS_SALES_OPP_UWQ_V
VIEW - AS_SALES_TEAM_DISTINCT_V
VIEW - AS_SALES_TEAM_EMP_V
VIEW - AS_SALES_TEAM_PTR_V
VIEW - AS_SALES_TEAM_V
PACKAGE BODY - AS_SC_DENORM
PACKAGE BODY - AS_SC_DENORM_TRG
VIEW - AS_SITE_CLASSIFICATION_V
VIEW - AS_TERRITORY_ACCESSES_V
PACKAGE BODY - AS_VALIDATE_SETUP
VIEW - ICX_AS_EVENT_FACILITIES_V
VIEW - PA_AS_PERSON_ROLES_V
VIEW - PA_PROJ_REQUEST_DIRECTORY_V
PACKAGE BODY - PV_SQL_UTILITY
[top of page]
View: AS_LOOKUP_TYPES
[top of page]
APPS.AS_LOOKUP_TYPES references the following:
APPS
PACKAGE - FND_GLOBAL
SYNONYM - FND_LOOKUP_TYPES
VIEW - FND_LOOKUP_TYPES_VL
APPS.AS_LOOKUP_TYPES is not referenced by any database object
[top of page]
View: AS_L_SITES_ACTIVE_V
[top of page]
APPS.AS_L_SITES_ACTIVE_V references the following:
APPS
VIEW - AS_PARTY_ADDRESSES_V
VIEW - AS_PARTY_CUSTOMERS_V
SYNONYM - FND_TERRITORIES_TL
APPS.AS_L_SITES_ACTIVE_V is not referenced by any database object
[top of page]
View: AS_MC_TYPE_MAPPINGS_V
[top of page]
APPS.AS_MC_TYPE_MAPPINGS_V references the following:
APPS
SYNONYM - AS_MC_TYPE_MAPPINGS
SYNONYM - GL_DAILY_CONVERSION_TYPES
SYNONYM - GL_PERIOD_TYPES
APPS.AS_MC_TYPE_MAPPINGS_V is not referenced by any database object
[top of page]
View: AS_OPPORTUNITIES_V
[top of page]
APPS.AS_OPPORTUNITIES_V references the following:
APPS
SYNONYM - AS_LEADS_ALL
SYNONYM - HZ_PARTIES
APPS.AS_OPPORTUNITIES_V is referenced by following:
APPS
PACKAGE BODY - AS_OPP_LINE_PVT
[top of page]
View: AS_OPPORTUNITY_COMPETITORS_V
[top of page]
APPS.AS_OPPORTUNITY_COMPETITORS_V references the following:
APPS
SYNONYM - AS_LEAD_COMPETITORS
SYNONYM - HZ_PARTIES
APPS.AS_OPPORTUNITY_COMPETITORS_V is not referenced by any database object
[top of page]
View: AS_OPPORTUNITY_CONTACTS
[top of page]
APPS.AS_OPPORTUNITY_CONTACTS references the following:
APPS
SYNONYM - AS_LEAD_CONTACTS_ALL
APPS.AS_OPPORTUNITY_CONTACTS is not referenced by any database object
[top of page]
View: AS_OPPORTUNITY_CONTACTS_V
[top of page]
APPS.AS_OPPORTUNITY_CONTACTS_V references the following:
APPS
VIEW - AR_LOOKUPS
SYNONYM - AS_LEAD_CONTACTS_ALL
SYNONYM - HZ_CONTACT_POINTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS
SYNONYM - HZ_RELATIONSHIP_TYPES
APPS.AS_OPPORTUNITY_CONTACTS_V is referenced by following:
APPS
PACKAGE BODY - AST_UWQ_OLIST_WORK_ACTION
PACKAGE BODY - PV_WORKFLOW_PUB
[top of page]
View: AS_OPPORTUNITY_DETAILS_V
[top of page]
APPS.AS_OPPORTUNITY_DETAILS_V references the following:
APPS
VIEW - AMS_P_SOURCE_CODES_V
SYNONYM - AS_LEADS_ALL
VIEW - AS_LOOKUPS
SYNONYM - AS_SALES_STAGES_ALL_B
SYNONYM - AS_SALES_STAGES_ALL_TL
SYNONYM - AS_STATUSES_TL
SYNONYM - HZ_PARTIES
VIEW - OE_LOOKUPS
APPS.AS_OPPORTUNITY_DETAILS_V is not referenced by any database object
[top of page]
View: AS_OPPORTUNITY_LINES_V
[top of page]
APPS.AS_OPPORTUNITY_LINES_V references the following:
APPS
VIEW - AMS_P_SOURCE_CODES_V
SYNONYM - AS_LEAD_LINES_ALL
VIEW - ENI_PROD_DEN_HRCHY_PARENTS_V
VIEW - MTL_SYSTEM_ITEMS_B_KFV
SYNONYM - MTL_UNITS_OF_MEASURE_TL
APPS.AS_OPPORTUNITY_LINES_V is not referenced by any database object
[top of page]
View: AS_OPPORTUNITY_OBSTACLES_V
[top of page]
APPS.AS_OPPORTUNITY_OBSTACLES_V references the following:
APPS
SYNONYM - AS_LEAD_OBSTACLES
VIEW - AS_LOOKUPS
APPS.AS_OPPORTUNITY_OBSTACLES_V is not referenced by any database object
[top of page]
View: AS_OPPORTUNITY_ORDERS_V
[top of page]
APPS.AS_OPPORTUNITY_ORDERS_V references the following:
APPS
SYNONYM - AS_LEAD_ORDERS
SYNONYM - OE_ORDER_HEADERS_ALL
APPS.AS_OPPORTUNITY_ORDERS_V is not referenced by any database object
[top of page]
View: AS_OPP_CLASSIFICATION_V
[top of page]
APPS.AS_OPP_CLASSIFICATION_V references the following:
APPS
VIEW - AS_INTERESTS
VIEW - AS_INTEREST_CODES_VL
VIEW - AS_INTEREST_TYPES_VL
VIEW - AS_LOOKUPS
APPS.AS_OPP_CLASSIFICATION_V is not referenced by any database object
[top of page]
View: AS_PARTY_ADDRESSES_V
[top of page]
APPS.AS_PARTY_ADDRESSES_V references the following:
APPS
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTY_SITES
APPS.AS_PARTY_ADDRESSES_V is referenced by following:
APPS
VIEW - AST_SALES_LEADS_V
PACKAGE BODY - AS_ACCESS_PVT
VIEW - AS_L_SITES_ACTIVE_V
PACKAGE BODY - AS_OPP_CONTACT_PVT
PACKAGE BODY - AS_OSI_LEAD_PUB
PACKAGE BODY - AS_RTTAP_ACCOUNT
VIEW - AS_SALES_TEAM_DISTINCT_V
VIEW - AS_SALES_TEAM_V
PACKAGE BODY - AS_TCA_PVT
VIEW - AS_TERRITORY_ACCESSES_V
PACKAGE BODY - PV_OPPORTUNITY_VHUK
[top of page]
View: AS_PARTY_CONTACTS_V
[top of page]
APPS.AS_PARTY_CONTACTS_V references the following:
APPS
SYNONYM - HZ_PARTIES
APPS.AS_PARTY_CONTACTS_V is referenced by following:
APPS
VIEW - AST_L_CONTACT_POINTS_V
[top of page]
View: AS_PARTY_CUSTOMERS_V
[top of page]
APPS.AS_PARTY_CUSTOMERS_V references the following:
APPS
SYNONYM - HZ_PARTIES
APPS.AS_PARTY_CUSTOMERS_V is referenced by following:
APPS
VIEW - AST_L_CONTACT_ADDR_V
VIEW - AS_L_SITES_ACTIVE_V
PACKAGE BODY - AS_OPP_CONTACT_PVT
VIEW - AS_SALES_TEAM_DISTINCT_V
VIEW - AS_SALES_TEAM_V
PACKAGE BODY - AS_SC_DENORM_TRG
PACKAGE BODY - AS_TCA_PVT
VIEW - AS_TERRITORY_ACCESSES_V
[top of page]
View: AS_PARTY_ORG_CONTACTS_V
[top of page]
APPS.AS_PARTY_ORG_CONTACTS_V references the following:
APPS
SYNONYM - HZ_CONTACT_POINTS
SYNONYM - HZ_ORG_CONTACTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS
APPS.AS_PARTY_ORG_CONTACTS_V is referenced by following:
APPS
PACKAGE BODY - AS_OPP_CONTACT_PVT
PACKAGE BODY - AS_TCA_PVT
[top of page]
View: AS_PARTY_PHONES_V
[top of page]
APPS.AS_PARTY_PHONES_V references the following:
APPS
VIEW - AR_LOOKUPS
SYNONYM - HZ_CONTACT_POINTS
APPS.AS_PARTY_PHONES_V is referenced by following:
APPS
PACKAGE BODY - AS_OPP_CONTACT_PVT
PACKAGE BODY - AS_TCA_PVT
[top of page]
View: AS_PARTY_RELATIONSHIPS_V
[top of page]
APPS.AS_PARTY_RELATIONSHIPS_V references the following:
APPS
SYNONYM - HZ_RELATIONSHIPS
APPS.AS_PARTY_RELATIONSHIPS_V is not referenced by any database object
[top of page]
View: AS_PERIOD_RATES_V
[top of page]
APPS.AS_PERIOD_RATES_V references the following:
APPS
SYNONYM - AS_MC_TYPE_MAPPINGS
SYNONYM - GL_DAILY_RATES
SYNONYM - GL_PERIODS
APPS.AS_PERIOD_RATES_V is not referenced by any database object
[top of page]
View: AS_PERSONS_ACTIVE_V
[top of page]
APPS.AS_PERSONS_ACTIVE_V references the following:
APPS
PACKAGE - FND_GLOBAL
PACKAGE - HR_API
VIEW - HR_LOOKUPS
SYNONYM - PER_ALL_ASSIGNMENTS_F
SYNONYM - PER_ALL_PEOPLE_F
SYNONYM - PER_JOBS
APPS.AS_PERSONS_ACTIVE_V is not referenced by any database object
[top of page]
View: AS_PE_INT_CATEGORIES_V
[top of page]
APPS.AS_PE_INT_CATEGORIES_V references the following:
APPS
SYNONYM - AS_PE_INT_CATEGORIES
APPS.AS_PE_INT_CATEGORIES_V is not referenced by any database object
[top of page]
View: AS_PRICE_LISTS_V
[top of page]
APPS.AS_PRICE_LISTS_V references the following:
APPS
SYNONYM - AS_PRICE_LISTS
SYNONYM - AS_PRICE_LIST_GROUPS
VIEW - SO_PRICE_LISTS_VL
APPS.AS_PRICE_LISTS_V is not referenced by any database object
[top of page]
View: AS_PRIMARY_INTERESTS_ACTIVE_V
[top of page]
APPS.AS_PRIMARY_INTERESTS_ACTIVE_V references the following:
APPS
VIEW - AS_INTEREST_CODES_V
VIEW - AS_INTEREST_TYPES_VL
APPS.AS_PRIMARY_INTERESTS_ACTIVE_V is not referenced by any database object
[top of page]
View: AS_RPT_ADMINS_V
[top of page]
APPS.AS_RPT_ADMINS_V references the following:
APPS
SYNONYM - JTF_RS_GROUPS_DENORM
SYNONYM - JTF_RS_GROUP_MEMBERS
SYNONYM - JTF_RS_RESOURCE_EXTNS
SYNONYM - JTF_RS_ROLES_B
SYNONYM - JTF_RS_ROLE_RELATIONS
APPS.AS_RPT_ADMINS_V is referenced by following:
APPS
PACKAGE BODY - AS_ACCESS_PVT
[top of page]
View: AS_RPT_MANAGERS_V
[top of page]
APPS.AS_RPT_MANAGERS_V references the following:
APPS
SYNONYM - JTF_RS_GROUP_USAGES
SYNONYM - JTF_RS_REP_MANAGERS
APPS.AS_RPT_MANAGERS_V is referenced by following:
APPS
PACKAGE BODY - AS_ACCESS_PVT
[top of page]
View: AS_SALESFORCE_SUB_V
[top of page]
APPS.AS_SALESFORCE_SUB_V references the following:
APPS
SYNONYM - JTF_RS_GROUP_MEMBERS
SYNONYM - JTF_RS_RESOURCE_EXTNS
SYNONYM - JTF_RS_ROLES_B
SYNONYM - JTF_RS_ROLE_RELATIONS
APPS.AS_SALESFORCE_SUB_V is not referenced by any database object
[top of page]
View: AS_SALESFORCE_V
[top of page]
APPS.AS_SALESFORCE_V references the following:
APPS
SYNONYM - JTF_RS_RESOURCE_EXTNS
SYNONYM - JTF_RS_ROLES_B
SYNONYM - JTF_RS_ROLES_TL
SYNONYM - JTF_RS_ROLE_RELATIONS
APPS.AS_SALESFORCE_V is referenced by following:
APPS
PACKAGE BODY - ASN_MIG_SALES_CREDITS_PVT
PACKAGE BODY - AS_ACCESS_PVT
PACKAGE BODY - AS_AUTOCREATE_OPP
PACKAGE BODY - AS_OPP_HEADER_PVT
PACKAGE BODY - AS_OPP_SALES_CREDIT_PVT
PACKAGE BODY - AS_SALES_MEMBER_PUB
PACKAGE BODY - AS_SALES_ORG_MANAGER_PVT
PACKAGE BODY - PV_BG_PARTNER_MATCHING_PUB
[top of page]
View: AS_SALESGROUP_SUB_V
[top of page]
APPS.AS_SALESGROUP_SUB_V references the following:
APPS
SYNONYM - JTF_RS_GROUPS_DENORM
SYNONYM - JTF_RS_GROUPS_TL
SYNONYM - JTF_RS_GROUP_USAGES
APPS.AS_SALESGROUP_SUB_V is not referenced by any database object
[top of page]
View: AS_SALES_CREDITS_V
[top of page]
APPS.AS_SALES_CREDITS_V references the following:
APPS
SYNONYM - AS_SALES_CREDITS
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
SYNONYM - JTF_RS_GROUPS_TL
SYNONYM - JTF_RS_RESOURCE_EXTNS
SYNONYM - OE_SALES_CREDIT_TYPES
APPS.AS_SALES_CREDITS_V is not referenced by any database object
[top of page]
View: AS_SALES_FORECAST_UWQ_V
[top of page]
APPS.AS_SALES_FORECAST_UWQ_V references the following:
APPS
SYNONYM - AS_INTERNAL_FORECASTS
SYNONYM - JTF_RS_RESOURCE_EXTNS
APPS.AS_SALES_FORECAST_UWQ_V is referenced by following:
APPS
VIEW - AST_FORECAST_UWQ_V
[top of page]
View: AS_SALES_GROUPS_V
[top of page]
APPS.AS_SALES_GROUPS_V references the following:
APPS
SYNONYM - JTF_RS_GROUPS_B
SYNONYM - JTF_RS_GROUPS_TL
SYNONYM - JTF_RS_GROUP_MEMBERS
SYNONYM - JTF_RS_GROUP_USAGES
SYNONYM - JTF_RS_GRP_RELATIONS
SYNONYM - JTF_RS_ROLES_B
SYNONYM - JTF_RS_ROLE_RELATIONS
APPS.AS_SALES_GROUPS_V is referenced by following:
APPS
PACKAGE BODY - AS_OPP_SALES_CREDIT_PVT
PACKAGE BODY - AS_SCN_FORECAST_PVT
[top of page]
View: AS_SALES_GRP_DENORM_V
[top of page]
APPS.AS_SALES_GRP_DENORM_V references the following:
APPS
SYNONYM - JTF_RS_GROUPS_DENORM
SYNONYM - JTF_RS_GROUP_USAGES
APPS.AS_SALES_GRP_DENORM_V is not referenced by any database object
[top of page]
View: AS_SALES_LEADS_V
[top of page]
APPS.AS_SALES_LEADS_V references the following:
APPS
VIEW - AMS_P_SOURCE_CODES_V
VIEW - ASO_I_SALES_CHANNELS_V
VIEW - AS_LOOKUPS
SYNONYM - AS_SALES_LEADS
SYNONYM - AS_SALES_LEAD_RANKS_TL
SYNONYM - AS_STATUSES_B
SYNONYM - AS_STATUSES_TL
SYNONYM - HZ_CONTACT_POINTS
SYNONYM - HZ_PARTIES
SYNONYM - JTF_RS_RESOURCE_EXTNS
APPS.AS_SALES_LEADS_V is referenced by following:
APPS
VIEW - IGR_I_APPL
VIEW - IGR_I_A_ITYPE_V
VIEW - IGR_I_A_PKGITM_V
[top of page]
View: AS_SALES_LEAD_CONTACTS_V
[top of page]
APPS.AS_SALES_LEAD_CONTACTS_V references the following:
APPS
VIEW - AR_LOOKUPS
VIEW - AS_LOOKUPS
SYNONYM - AS_SALES_LEAD_CONTACTS
SYNONYM - HZ_CONTACT_POINTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS
APPS.AS_SALES_LEAD_CONTACTS_V is not referenced by any database object
[top of page]
View: AS_SALES_LEAD_LINES_V
[top of page]
APPS.AS_SALES_LEAD_LINES_V references the following:
APPS
VIEW - AMS_P_SOURCE_CODES_V
SYNONYM - AS_INTEREST_CODES_TL
SYNONYM - AS_INTEREST_TYPES_TL
SYNONYM - AS_SALES_LEAD_LINES
VIEW - MTL_SYSTEM_ITEMS_B_KFV
SYNONYM - MTL_UNITS_OF_MEASURE_TL
APPS.AS_SALES_LEAD_LINES_V is not referenced by any database object
[top of page]
View: AS_SALES_LEAD_QUALS_VL
[top of page]
APPS.AS_SALES_LEAD_QUALS_VL references the following:
APPS
SYNONYM - AS_SALES_LEAD_QUALS_B
SYNONYM - AS_SALES_LEAD_QUALS_TL
APPS.AS_SALES_LEAD_QUALS_VL is referenced by following:
APPS
PACKAGE BODY - AS_SCORECARD_RULES_PVT
[top of page]
View: AS_SALES_LEAD_RANKS_VL
[top of page]
APPS.AS_SALES_LEAD_RANKS_VL references the following:
APPS
SYNONYM - AS_SALES_LEAD_RANKS_B
SYNONYM - AS_SALES_LEAD_RANKS_TL
APPS.AS_SALES_LEAD_RANKS_VL is referenced by following:
APPS
VIEW - AML_LEAD_PROCESSING_STAGES_V
PACKAGE BODY - AMS_R_CODE_DEFINITIONS_PKG
PACKAGE BODY - BIM_PMV_DBI_UTL_PKG
PACKAGE BODY - PV_SQL_UTILITY
[top of page]
View: AS_SALES_LEAD_UWQ_V
[top of page]
APPS.AS_SALES_LEAD_UWQ_V references the following:
APPS
SYNONYM - AS_SALES_LEADS
SYNONYM - AS_STATUSES_B
SYNONYM - AS_STATUSES_TL
SYNONYM - HZ_PARTIES
SYNONYM - JTF_RS_RESOURCE_EXTNS
APPS.AS_SALES_LEAD_UWQ_V is not referenced by any database object
[top of page]
View: AS_SALES_METHODOLOGY_VL
[top of page]
APPS.AS_SALES_METHODOLOGY_VL references the following:
APPS
SYNONYM - AS_SALES_METHODOLOGY_B
SYNONYM - AS_SALES_METHODOLOGY_TL
APPS.AS_SALES_METHODOLOGY_VL is referenced by following:
APPS
PACKAGE BODY - PV_SQL_UTILITY
[top of page]
View: AS_SALES_OPP_UWQ_V
[top of page]
APPS.AS_SALES_OPP_UWQ_V references the following:
APPS
VIEW - ASO_I_SALES_CHANNELS_V
VIEW - AS_ACCESSES_ALL
SYNONYM - AS_FORECAST_PROB_ALL_TL
SYNONYM - AS_LEADS_ALL
VIEW - AS_LOOKUPS
SYNONYM - AS_SALES_STAGES_ALL_TL
SYNONYM - AS_STATUSES_B
SYNONYM - AS_STATUSES_TL
SYNONYM - HZ_PARTIES
SYNONYM - JTF_RS_RESOURCE_EXTNS
APPS.AS_SALES_OPP_UWQ_V is not referenced by any database object
[top of page]
View: AS_SALES_STAGES
[top of page]
APPS.AS_SALES_STAGES references the following:
APPS
SYNONYM - AS_SALES_STAGES_ALL_B
APPS.AS_SALES_STAGES is referenced by following:
APPS
PACKAGE BODY - AS_SC_DENORM_TRG
[top of page]
View: AS_SALES_STAGES_ALL_VL
[top of page]
APPS.AS_SALES_STAGES_ALL_VL references the following:
APPS
SYNONYM - AS_SALES_STAGES_ALL_B
SYNONYM - AS_SALES_STAGES_ALL_TL
APPS.AS_SALES_STAGES_ALL_VL is referenced by following:
APPS
VIEW - AMS_LEAD_ACCOUNTS_V
VIEW - AMS_LOOKUP_SALES_V
PACKAGE BODY - AST_ASN_INTEROP
PACKAGE BODY - AS_OPP_HEADER_PVT
PACKAGE BODY - AS_SALES_LEAD_OPP_PVT
VIEW - BIL_OBI_OPDTL_V
PACKAGE BODY - PV_SQL_UTILITY
[top of page]
View: AS_SALES_STAGES_VL
[top of page]
APPS.AS_SALES_STAGES_VL references the following:
APPS
SYNONYM - AS_SALES_STAGES_ALL_B
SYNONYM - AS_SALES_STAGES_ALL_TL
APPS.AS_SALES_STAGES_VL is not referenced by any database object
[top of page]
View: AS_SALES_TEAM_DISTINCT_V
[top of page]
APPS.AS_SALES_TEAM_DISTINCT_V references the following:
APPS
VIEW - AS_ACCESSES_ALL
VIEW - AS_LOOKUPS
VIEW - AS_PARTY_ADDRESSES_V
VIEW - AS_PARTY_CUSTOMERS_V
SYNONYM - JTF_RS_GROUPS_TL
SYNONYM - JTF_RS_GROUP_MEMBERS
SYNONYM - JTF_RS_RESOURCE_EXTNS
SYNONYM - PER_ALL_PEOPLE_F
APPS.AS_SALES_TEAM_DISTINCT_V is not referenced by any database object
[top of page]
View: AS_SALES_TEAM_EMP_V
[top of page]
APPS.AS_SALES_TEAM_EMP_V references the following:
APPS
VIEW - AS_ACCESSES_ALL
VIEW - AS_LOOKUPS
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTY_SITES
SYNONYM - JTF_RS_GROUPS_TL
SYNONYM - JTF_RS_RESOURCE_EXTNS
APPS.AS_SALES_TEAM_EMP_V is referenced by following:
APPS
PACKAGE BODY - AS_BUSINESS_EVENT_PVT
[top of page]
View: AS_SALES_TEAM_PTR_V
[top of page]
APPS.AS_SALES_TEAM_PTR_V references the following:
APPS
VIEW - AS_ACCESSES_ALL
VIEW - AS_LOOKUPS
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
APPS.AS_SALES_TEAM_PTR_V is not referenced by any database object
[top of page]
View: AS_SALES_TEAM_V
[top of page]
APPS.AS_SALES_TEAM_V references the following:
APPS
VIEW - AS_ACCESSES_ALL
VIEW - AS_LOOKUPS
VIEW - AS_PARTY_ADDRESSES_V
VIEW - AS_PARTY_CUSTOMERS_V
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - JTF_RS_GROUPS_TL
SYNONYM - JTF_RS_GROUP_MEMBERS
SYNONYM - JTF_RS_RESOURCE_EXTNS
VIEW - PER_PEOPLE_F
APPS.AS_SALES_TEAM_V is not referenced by any database object
[top of page]
View: AS_SCORECARD_RULES_V
[top of page]
APPS.AS_SCORECARD_RULES_V references the following:
APPS
SYNONYM - AS_CARD_RULE_QUAL_VALUES
SYNONYM - AS_SALES_LEAD_QUALS_B
SYNONYM - AS_SALES_LEAD_QUALS_TL
APPS.AS_SCORECARD_RULES_V is not referenced by any database object
[top of page]
View: AS_SECOND_INTERESTS_ACTIVE_V
[top of page]
APPS.AS_SECOND_INTERESTS_ACTIVE_V references the following:
APPS
VIEW - AS_INTEREST_CODES_V
VIEW - AS_INTEREST_TYPES_VL
APPS.AS_SECOND_INTERESTS_ACTIVE_V is not referenced by any database object
[top of page]
View: AS_SF_PTR_V
[top of page]
APPS.AS_SF_PTR_V references the following:
APPS
SYNONYM - HZ_ORGANIZATION_PROFILES
SYNONYM - JTF_RS_RESOURCE_EXTNS
SYNONYM - JTF_RS_ROLES_B
SYNONYM - JTF_RS_ROLES_TL
SYNONYM - JTF_RS_ROLE_RELATIONS
APPS.AS_SF_PTR_V is referenced by following:
APPS
PACKAGE BODY - AS_OPP_HEADER_PVT
PACKAGE BODY - AS_SALES_LEADS_PVT
[top of page]
View: AS_SG_ACTIVE_MGR_V
[top of page]
APPS.AS_SG_ACTIVE_MGR_V references the following:
APPS
SYNONYM - JTF_RS_GROUPS_B
SYNONYM - JTF_RS_GROUPS_TL
SYNONYM - JTF_RS_GROUP_MEMBERS
SYNONYM - JTF_RS_GROUP_USAGES
SYNONYM - JTF_RS_GRP_RELATIONS
SYNONYM - JTF_RS_ROLES_B
SYNONYM - JTF_RS_ROLE_RELATIONS
APPS.AS_SG_ACTIVE_MGR_V is not referenced by any database object
[top of page]
View: AS_SITE_CLASSIFICATION_V
[top of page]
APPS.AS_SITE_CLASSIFICATION_V references the following:
APPS
VIEW - AS_INTERESTS
VIEW - AS_INTEREST_CODES_V
VIEW - AS_INTEREST_TYPES_VL
VIEW - AS_LOOKUPS
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTY_SITES
APPS.AS_SITE_CLASSIFICATION_V is not referenced by any database object
[top of page]
View: AS_STATUSES_VL
[top of page]
APPS.AS_STATUSES_VL references the following:
APPS
SYNONYM - AS_STATUSES_B
SYNONYM - AS_STATUSES_TL
APPS.AS_STATUSES_VL is referenced by following:
APPS
VIEW - AML_LEAD_PROCESS_REPT_V
PACKAGE BODY - AML_MONITOR_WF
PACKAGE BODY - ASN_MIG_SALES_CREDITS_PVT
VIEW - AST_MYTEAM_SALESLEAD_UWQ_V
VIEW - AST_OPPORTUNITY_V
VIEW - AST_SALES_LEADS_BALI_V
VIEW - AST_SALES_LEADS_EBC_V
VIEW - AST_SALES_LEADS_REL_BALI_V
VIEW - AST_SALES_LEADS_V
PACKAGE BODY - AST_UWQ_LEADS_ENUMS_PVT
PACKAGE BODY - AST_UWQ_OPP_ENUMS_PVT
PACKAGE BODY - AS_OPP_HEADER_PVT
PACKAGE BODY - AS_OPP_LINE_PVT
PACKAGE BODY - AS_OPP_SALES_CREDIT_PVT
PACKAGE BODY - AS_SC_DENORM
PACKAGE BODY - AS_SC_DENORM_TRG
PACKAGE BODY - AS_STATUS_PUB
VIEW - BIL_OBI_OPDTL_V
PACKAGE BODY - BIM_EDW_LEAD_STATUS_M_SIZE
PACKAGE BODY - BIM_EDW_OPP_STATUS_M_SIZE
PACKAGE BODY - BIX_DM_AGENT_CALL_SUMMARY_PKG
PACKAGE BODY - IGR_GEN_001
VIEW - IGR_I_APPL_V
PACKAGE BODY - IGR_I_STATUS_PKG
VIEW - IGR_I_STATUS_V
PACKAGE BODY - PV_OPPORTUNITY_VHUK
[top of page]
View: AS_TAP_ACCOUNTS_V
[top of page]
APPS.AS_TAP_ACCOUNTS_V references the following:
APPS
SYNONYM - HZ_CONTACT_POINTS
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_ORGANIZATION_PROFILES
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
APPS.AS_TAP_ACCOUNTS_V is not referenced by any database object
[top of page]
View: AS_TAP_LEADS_V
[top of page]
APPS.AS_TAP_LEADS_V references the following:
APPS
SYNONYM - AS_SALES_LEADS
SYNONYM - AS_STATUSES_B
SYNONYM - JTF_TAE_1001_ACCOUNT_TRANS
APPS.AS_TAP_LEADS_V is not referenced by any database object
[top of page]
View: AS_TAP_OPPORTUNITIES_V
[top of page]
APPS.AS_TAP_OPPORTUNITIES_V references the following:
APPS
SYNONYM - AS_LEADS_ALL
SYNONYM - AS_STATUSES_B
SYNONYM - JTF_TAE_1001_ACCOUNT_TRANS
APPS.AS_TAP_OPPORTUNITIES_V is not referenced by any database object
[top of page]
View: AS_TERRITORIES
[top of page]
APPS.AS_TERRITORIES references the following:
APPS
SYNONYM - AS_TERRITORIES_ALL
APPS.AS_TERRITORIES is referenced by following:
APPS
PACKAGE BODY - JTF_TERR_DEFINITION_REPORT_PVT
[top of page]
View: AS_TERRITORIES_V
[top of page]
APPS.AS_TERRITORIES_V references the following:
APPS
PACKAGE - FND_GLOBAL
VIEW - JTF_QUAL_TYPES
VIEW - JTF_QUAL_TYPE_USGS
SYNONYM - JTF_TERR
SYNONYM - JTF_TERR_QTYPE_USGS
APPS.AS_TERRITORIES_V is not referenced by any database object
[top of page]
View: AS_TERRITORY_ACCESSES_V
[top of page]
APPS.AS_TERRITORY_ACCESSES_V references the following:
APPS
VIEW - AS_ACCESSES
VIEW - AS_LEADS
VIEW - AS_LOOKUPS
VIEW - AS_PARTY_ADDRESSES_V
VIEW - AS_PARTY_CUSTOMERS_V
SYNONYM - AS_TERRITORY_ACCESSES
SYNONYM - PER_ALL_PEOPLE_F
APPS.AS_TERRITORY_ACCESSES_V is not referenced by any database object
[top of page]
View: AS_TODO_LISTS
[top of page]
APPS.AS_TODO_LISTS references the following:
APPS
SYNONYM - AS_TODO_LISTS_ALL
APPS.AS_TODO_LISTS is referenced by following:
APPS
TRIGGER - AS_LEADS_BIUD
[top of page]