Oracle eBusiness Suite Technical Reference

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

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - 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_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_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

Primary Key: AS_ACCESSES_ALL_PK

1. ACCESS_ID

Primary Key: AS_ACCESSES_PK

1. ACCESS_ID

Primary Key: AS_ACCESSES_UK

1. PERSON_ID
2. CUSTOMER_ID
3. ADDRESS_ID
4. LEAD_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

AS_ACCESSES_ALL stores information that indicates whether an employee
can access an customer, a sales lead or an opportunity.
.
Each record in AS_ACCESSES_ALL includes values that identify an
employee for which the access applies and the customer, sales lead or opportunity
to which access is granted.
.
A TEAM_LEADER_FLAG of 'Y' means that the employee can update all
information on the record to which he has access.
.
A TEAM_LEADER_FLAG of 'N' for an account access record means that the
employee only can update the relationship column and contacts for the
account.
.
A TEAM_LEADER_FLAG of 'N' for an opportunity access record means that
the employee only can update the obstacles and competitor information
for the opportunity.
.
A FREEZE_FLAG of 'Y' means that the employees access to the specified
account or opportunity record has been frozen. The row will not be
affected by changes made to the territory or to subsequent runs of the
Territory Assignment program.
.
.

Indexes

Columns

[top of page]

OSM.AS_ACCESSES_ALL_ALL does not reference any database object

OSM.AS_ACCESSES_ALL_ALL is referenced by following:

OSM

VIEW - AS_ACCESSES_ALL_ALL#

[top of page]

Table: AS_ACCESSES_PURGE_TEMP

Comments

Columns

[top of page]

OSM.AS_ACCESSES_PURGE_TEMP does not reference any database object

OSM.AS_ACCESSES_PURGE_TEMP is referenced by following:

OSM

VIEW - AS_ACCESSES_PURGE_TEMP#

[top of page]

Table: AS_ACCOUNT_QUAL_VALUES_ALL

Comments

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns

[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:

OSM

VIEW - AS_ACCOUNT_QUAL_VALUES_ALL#

[top of page]

Table: AS_AP_ACCOUNT_PLANS

Primary Key: AS_AP_ACCOUNT_PLANS_PK

1. ACCOUNT_PLAN_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

This is the header table that will hold account plans for various customers.

Indexes

Columns

[top of page]

OSM.AS_AP_ACCOUNT_PLANS does not reference any database object

OSM.AS_AP_ACCOUNT_PLANS is referenced by following:

OSM

VIEW - AS_AP_ACCOUNT_PLANS#

[top of page]

Table: AS_AP_BUSINESS_DRIVERS

Primary Key: AS_AP_BUSINESS_DRIVERS_PK

1. BUSINESS_DRIVER_ID

Foreign Keys from this table:

Comments

This table will hold all the business drivers for each of the account plans.

Indexes

Columns

[top of page]

OSM.AS_AP_BUSINESS_DRIVERS does not reference any database object

OSM.AS_AP_BUSINESS_DRIVERS is referenced by following:

OSM

VIEW - AS_AP_BUSINESS_DRIVERS#

[top of page]

Table: AS_AP_STRTGC_OBJECTIVES

Primary Key: AS_AP_STRTGC_OBJECTIVES_PK

1. STRATEGIC_OBJECTIVE_ID

Foreign Keys from this table:

Comments

This table will hold all the strategic objectives for each of the account plans.

Indexes

Columns

[top of page]

OSM.AS_AP_STRTGC_OBJECTIVES does not reference any database object

OSM.AS_AP_STRTGC_OBJECTIVES is referenced by following:

OSM

VIEW - AS_AP_STRTGC_OBJECTIVES#

[top of page]

Table: AS_AP_TRACKING_OBJECTIVES

Primary Key: AS_AP_TRACKING_OBJECTIVE_PK

1. TRACKING_OBJECTIVE_ID

Foreign Keys from this table:

Comments

This table will hold all the revenue objectives for each of the account plans.

Indexes

Columns

[top of page]

OSM.AS_AP_TRACKING_OBJECTIVES does not reference any database object

OSM.AS_AP_TRACKING_OBJECTIVES is referenced by following:

OSM

VIEW - AS_AP_TRACKING_OBJECTIVES#

[top of page]

Table: AS_CARD_RULE_QUAL_VALUES

Primary Key: AS_CARD_RULE_QUAL_VALUES_PK

1. QUAL_VALUE_ID

Foreign Keys from this table:

Comments

AS_SCORECARD_RULE_QUALIFIERS holds the information about various parameters used in building a rule. eg. The qualifier name ,the values stored in there.

Indexes

Columns

[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:

OSM

VIEW - AS_CARD_RULE_QUAL_VALUES#

[top of page]

Table: AS_CATEGORIES_ALL

Primary Key: AS_CATEGORIES_PK

1. CATEGORY_ID

Foreign Keys to this table:

Comments

Indexes

Columns

[top of page]

OSM.AS_CATEGORIES_ALL does not reference any database object

OSM.AS_CATEGORIES_ALL is referenced by following:

OSM

VIEW - AS_CATEGORIES_ALL#

[top of page]

Table: AS_CHANGED_ACCOUNTS_ALL

Primary Key: AS_CHANGED_ACCOUNTS_PK

1. ADDRESS_ID
2. LEAD_ID

Foreign Keys from this table:

Comments

AS_CHANGED_ACCOUNTS_ALL stores the accounts and leads that have
either changed or are somehow affected by a change in the territory
definition.
.
These accounts and leads will then be processed by the Assign
Territory Accesses Program and reassigned to employees.
.
.

Indexes

Columns

[top of page]

OSM.AS_CHANGED_ACCOUNTS_ALL does not reference any database object

OSM.AS_CHANGED_ACCOUNTS_ALL is referenced by following:

OSM

VIEW - AS_CHANGED_ACCOUNTS_ALL#

[top of page]

Table: AS_CHANGED_TERRITORIES_ALL

Primary Key: AS_CHANGED_TERRITORIES_PK

1. TERRITORY_ID

Foreign Keys from this table:

Comments

Indexes

Columns

[top of page]

OSM.AS_CHANGED_TERRITORIES_ALL does not reference any database object

OSM.AS_CHANGED_TERRITORIES_ALL is referenced by following:

OSM

VIEW - AS_CHANGED_TERRITORIES_ALL#

[top of page]

Table: AS_COLLATERAL_CAT_ALL

Primary Key: AS_COLLATERAL_CATEGORIES_PK

1. PROMOTION_ID

Foreign Keys from this table:

Comments

Indexes

Columns

[top of page]

OSM.AS_COLLATERAL_CAT_ALL does not reference any database object

OSM.AS_COLLATERAL_CAT_ALL is referenced by following:

OSM

VIEW - AS_COLLATERAL_CAT_ALL#

[top of page]

Table: AS_COLLATERAL_KITS_ALL

Primary Key: AS_COLLATERAL_KITS_PK

1. PARENT_COLLATERAL_ID
2. CHILD_COLLATERAL_ID

Foreign Keys from this table:

Comments

Indexes

Columns

[top of page]

OSM.AS_COLLATERAL_KITS_ALL does not reference any database object

OSM.AS_COLLATERAL_KITS_ALL is referenced by following:

OSM

VIEW - AS_COLLATERAL_KITS_ALL#

[top of page]

Table: AS_COLLATERAL_REQ_ALL

Primary Key: AS_COLLATERAL_REQUESTS_PK

1. COLLATERAL_REQUEST_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

Indexes

Columns

[top of page]

OSM.AS_COLLATERAL_REQ_ALL does not reference any database object

OSM.AS_COLLATERAL_REQ_ALL is referenced by following:

OSM

VIEW - AS_COLLATERAL_REQ_ALL#

[top of page]

Table: AS_COLLATERAL_REQ_ITEMS

Primary Key: AS_COLL_REQ_ITEMS_PK

1. COLLATERAL_REQ_ITEM_ID

Foreign Keys from this table:

Comments

Indexes

Columns

[top of page]

OSM.AS_COLLATERAL_REQ_ITEMS does not reference any database object

OSM.AS_COLLATERAL_REQ_ITEMS is referenced by following:

OSM

VIEW - AS_COLLATERAL_REQ_ITEMS#

[top of page]

Table: AS_CONC_REQUEST_MESSAGES

Primary Key: AS_CONC_REQUEST_MESSAGES_PK

1. CONC_REQUEST_MESSAGE_ID

Comments

AS_CONC_REQUEST_MESSAGES stores messages generated by the
Oracle Sales and Marketing concurrent programs.
.
.

Indexes

Columns

[top of page]

OSM.AS_CONC_REQUEST_MESSAGES does not reference any database object

OSM.AS_CONC_REQUEST_MESSAGES is referenced by following:

OSM

VIEW - AS_CONC_REQUEST_MESSAGES#

[top of page]

Table: AS_CONTACT_EDUCATION

Primary Key: AS_CONTACT_EDUCATION_PK

1. EDUCATION_ID

Comments

Indexes

Columns

[top of page]

OSM.AS_CONTACT_EDUCATION does not reference any database object

OSM.AS_CONTACT_EDUCATION is referenced by following:

OSM

VIEW - AS_CONTACT_EDUCATION#

[top of page]

Table: AS_CONTACT_ENTER

Primary Key: AS_CONTACT_ENTERTAINMENT_PK

1. ENTERTAINMENT_ID

Comments

Indexes

Columns

[top of page]

OSM.AS_CONTACT_ENTER does not reference any database object

OSM.AS_CONTACT_ENTER is referenced by following:

OSM

VIEW - AS_CONTACT_ENTER#

[top of page]

Table: AS_CONTACT_FAMILY

Primary Key: AS_CONTACT_FAMILY_MATTERS_PK

1. FAMILY_ID

Primary Key: AS_CONTACT_FAMILY_PK

1. FAMILY_ID

Comments

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes

Columns

[top of page]

OSM.AS_CONTACT_FAMILY does not reference any database object

OSM.AS_CONTACT_FAMILY is referenced by following:

OSM

VIEW - AS_CONTACT_FAMILY#

[top of page]

Table: AS_CONTACT_HOBBIES

Primary Key: AS_CONTACT_HOBBIES_PK

1. HOBBY_ID

Comments

Indexes

Columns

[top of page]

OSM.AS_CONTACT_HOBBIES does not reference any database object

OSM.AS_CONTACT_HOBBIES is referenced by following:

OSM

VIEW - AS_CONTACT_HOBBIES#

[top of page]

Table: AS_CONTACT_JOB_HISTORY

Primary Key: AS_CONTACT_JOB_HISTORY_PK

1. JOB_HISTORY_ID

Comments

Indexes

Columns

[top of page]

OSM.AS_CONTACT_JOB_HISTORY does not reference any database object

OSM.AS_CONTACT_JOB_HISTORY is referenced by following:

OSM

VIEW - AS_CONTACT_JOB_HISTORY#

[top of page]

Table: AS_CONTACT_MILITARY

Primary Key: AS_CONTACT_MILITARY_PK

1. MILITARY_ID

Comments

Indexes

Columns

[top of page]

OSM.AS_CONTACT_MILITARY does not reference any database object

OSM.AS_CONTACT_MILITARY is referenced by following:

OSM

VIEW - AS_CONTACT_MILITARY#

[top of page]

Table: AS_CONTACT_PREFERENCES

Primary Key: AS_CONTACT_PREFERENCES_PK

1. PREFERENCE_ID

Comments

Indexes

Columns

[top of page]

OSM.AS_CONTACT_PREFERENCES does not reference any database object

OSM.AS_CONTACT_PREFERENCES is referenced by following:

OSM

VIEW - AS_CONTACT_PREFERENCES#

[top of page]

Table: AS_CONTACT_SPORTS

Primary Key: AS_CONTACT_SPORTS_PK

1. SPORTS_ID

Comments

Indexes

Columns

[top of page]

OSM.AS_CONTACT_SPORTS does not reference any database object

OSM.AS_CONTACT_SPORTS is referenced by following:

OSM

VIEW - AS_CONTACT_SPORTS#

[top of page]

Table: AS_CONTACT_TRAITS

Primary Key: AS_CONTACT_TRAITS_PK

1. TRAIT_ID

Comments

Indexes

Columns

[top of page]

OSM.AS_CONTACT_TRAITS does not reference any database object

OSM.AS_CONTACT_TRAITS is referenced by following:

OSM

VIEW - AS_CONTACT_TRAITS#

[top of page]

Table: AS_COUNTRY_PHONES

Primary Key: AS_COUNTRY_PHONES_PK

1. COUNTRY_CODE

Comments

Indexes

Columns

[top of page]

OSM.AS_COUNTRY_PHONES does not reference any database object

OSM.AS_COUNTRY_PHONES is referenced by following:

OSM

VIEW - AS_COUNTRY_PHONES#

[top of page]

Table: AS_CURRENT_ENVIRONMENT

Primary Key: AS_CURRENT_ENVIRONMENT_PK

1. CURRENT_ENVIRONMENT_ID

Foreign Keys from this table:

Comments

This table stores information about the current environment of the
customers.

Indexes

Columns

[top of page]

OSM.AS_CURRENT_ENVIRONMENT does not reference any database object

OSM.AS_CURRENT_ENVIRONMENT is referenced by following:

OSM

VIEW - AS_CURRENT_ENVIRONMENT#

[top of page]

Table: AS_CUST_PROFILES

Primary Key: AS_CUST_PROFILES_PK

1. CUSTOMER_ID
2. ADDRESS_ID

Comments

Columns

[top of page]

OSM.AS_CUST_PROFILES does not reference any database object

OSM.AS_CUST_PROFILES is referenced by following:

OSM

VIEW - AS_CUST_PROFILES#

[top of page]

Table: AS_DEFAULT_PURCHASES_ALL

Foreign Keys from this table:

Comments

Columns

[top of page]

OSM.AS_DEFAULT_PURCHASES_ALL does not reference any database object

OSM.AS_DEFAULT_PURCHASES_ALL is referenced by following:

OSM

VIEW - AS_DEFAULT_PURCHASES_ALL#

[top of page]

Table: AS_EVENT_DATA

Primary Key: AS_EVENT_DATA_PK

1. EVENT_DATA_ID

Comments

AS_EVENT_DATA is a table for temporarily storing old and new event data for use by event subscription functions to business events raised by Oracle Sales applications

Indexes

Columns