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 - AMV Tables and Views

TABLE - AMV.AMV_C_AUTHORS

TABLE - AMV.AMV_C_CATEGORIES_B

TABLE - AMV.AMV_C_CATEGORIES_TL

TABLE - AMV.AMV_C_CHANNELS_B

TABLE - AMV.AMV_C_CHANNELS_TL

TABLE - AMV.AMV_C_CHL_ITEM_MATCH

TABLE - AMV.AMV_C_CHL_PERSPECTIVES

TABLE - AMV.AMV_C_CONTENT_TYPES

TABLE - AMV.AMV_C_ITEM_TYPES

TABLE - AMV.AMV_C_KEYWORDS

TABLE - AMV.AMV_D_ATTRIB_OPERATORS

TABLE - AMV.AMV_D_COMPL_RULE_ITEMS

TABLE - AMV.AMV_D_ENTITIES_B

TABLE - AMV.AMV_D_ENTITIES_TL

TABLE - AMV.AMV_D_ENT_ATTRIBUTES_B

TABLE - AMV.AMV_D_ENT_ATTRIBUTES_TL

TABLE - AMV.AMV_D_RULE_CONDITIONS

TABLE - AMV.AMV_D_SIMPLE_RULE_ITEMS

TABLE - AMV.AMV_I_CONTENT_TYPES_B

TABLE - AMV.AMV_I_CONTENT_TYPES_TL

TABLE - AMV.AMV_I_ITEM_PERSPECTIVES

TABLE - AMV.AMV_I_PERSPECTIVES_B

TABLE - AMV.AMV_I_PERSPECTIVES_TL

TABLE - AMV.AMV_NEWS

TABLE - AMV.AMV_STOCKS

TABLE - AMV.AMV_STOCK_PRICE

TABLE - APPS.AMV_TEMP_IDS

TABLE - APPS.AMV_TEMP_NUMBERS

TABLE - AMV.AMV_USER_TICKER

TABLE - AMV.AMV_U_ACCESS

TABLE - AMV.AMV_U_EXT_SUBSCRIPTIONS

TABLE - AMV.AMV_U_MY_CHANNELS

TABLE - AMV.AMV_VENDOR_KEYS

VIEW - APPS.AMV_C_CATEGORIES_VL

VIEW - APPS.AMV_C_CHANNELS_VL

VIEW - APPS.AMV_D_ENTITIES_VL

VIEW - APPS.AMV_D_ENT_ATTRIBUTES_VL

VIEW - APPS.AMV_I_CONTENT_TYPES_VL

VIEW - APPS.AMV_RS_ALL_RES_EXTNS_VL

Table: AMV_C_AUTHORS

Primary Key: AMV_C_AUTHORS_PK

1. CHANNEL_AUTHOR_ID

Primary Key: AMV_C_AUTHORS_UK1

1. CHANNEL_ID
2. AUTHOR

Foreign Keys from this table:

Comments

AMV_C_AUTHORS stores one to many authors for a specific channel. These authors could later on be part of a matching criteria, to decide if certain items should be published to the channel or not.

Indexes

Columns

[top of page]

AMV.AMV_C_AUTHORS does not reference any database object

AMV.AMV_C_AUTHORS is referenced by following:

APPS

SYNONYM - AMV_C_AUTHORS

[top of page]

Table: AMV_C_CATEGORIES_B

Primary Key: AMV_C_CATEGORIES_B_PK

1. CHANNEL_CATEGORY_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

AMV_C_CATEGORIES_B categorizes one to many channels. There can be a hierarchy of Categories. The sub-categories in a category hierarchy can have channels connected to it.

Indexes

Columns

[top of page]

AMV.AMV_C_CATEGORIES_B does not reference any database object

AMV.AMV_C_CATEGORIES_B is referenced by following:

APPS

SYNONYM - AMV_C_CATEGORIES_B

[top of page]

Table: AMV_C_CATEGORIES_TL

Primary Key: AMV_C_CATEGORIES_TL_PK

1. CHANNEL_CATEGORY_ID
2. LANGUAGE

Foreign Keys from this table:

Comments

AMV_C_CATEGORIES_TL stores all the translated attributes for a category.

Indexes

Columns

[top of page]

AMV.AMV_C_CATEGORIES_TL does not reference any database object

AMV.AMV_C_CATEGORIES_TL is referenced by following:

APPS

SYNONYM - AMV_C_CATEGORIES_TL

[top of page]

Table: AMV_C_CHANNELS_B

Primary Key: AMV_C_CHANNELS_B_PK

1. CHANNEL_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

AMV_C_CHANNELS_B stores all Channels that exist in the system. A Channel is place to which information (e.g. items/urls/files/messages) can be published. A channel can be of two types, 'content' or 'group'. A content channel is a channel the end user can subscribe to. A group channel is a one-to-one relationship with a user group and is used to push information to a certain user group.
Channels are a means to classify items and ultimately deliver information. Channels are categorized and defined by attributes. The outcome is channel properties, which determine what content items may exist in a given channel.

Indexes

Columns

[top of page]

AMV.AMV_C_CHANNELS_B does not reference any database object

AMV.AMV_C_CHANNELS_B is referenced by following:

APPS

SYNONYM - AMV_C_CHANNELS_B

[top of page]

Table: AMV_C_CHANNELS_TL

Primary Key: AMV_C_CHANNELS_TL_PK

1. CHANNEL_ID
2. LANGUAGE

Foreign Keys from this table:

Comments

AMV_C_CHANNELS_TL stores all translated attributes for a channel.

Primary Key: CH_TL_PK

1. CHANNEL_ID
2. LANGUAGE

Indexes

Columns

[top of page]

AMV.AMV_C_CHANNELS_TL does not reference any database object

AMV.AMV_C_CHANNELS_TL is referenced by following:

APPS

SYNONYM - AMV_C_CHANNELS_TL

[top of page]

Table: AMV_C_CHL_ITEM_MATCH

Primary Key: AMV_C_CHL_ITEM_MATCH_PK

1. CHANNEL_ITEM_ID

Primary Key: AMV_C_CHL_ITEM_MATCH_UK1

1. TABLE_NAME_CODE
2. ITEM_ID
3. CHANNEL_ID

Foreign Keys from this table:

Comments

AMV_C_CHL_ITEMS_MATCH stores channels that an item is published to. The column published_due_to_type specifies if the item was pushed or pulled (matched).
Pushed means that the person creating the item really want to make sure the channel (and people subscribing to it) will get the item.
Pulled/Matched mean that the matching engine, using matching criteria, decided that the item should be published to the channel.

Indexes

Columns

[top of page]

AMV.AMV_C_CHL_ITEM_MATCH does not reference any database object

AMV.AMV_C_CHL_ITEM_MATCH is referenced by following:

APPS

SYNONYM - AMV_C_CHL_ITEM_MATCH

[top of page]

Table: AMV_C_CHL_PERSPECTIVES

Primary Key: AMV_C_CHL_PERSPECTIVES_PK

1. CHANNEL_PERSPECTIVE_ID

Primary Key: AMV_C_CHL_PERSPECTIVES_UK1

1. CHANNEL_ID
2. PERSPECTIVE_ID

Foreign Keys from this table:

Comments

AMV_C_CHL_PERSPECTIVES stores all perspectives associated with a specific channel. If perspectives are set up for a channel they can be used as part of a matching criteria to decide if information should be published to this channel.

Indexes

Columns

[top of page]

AMV.AMV_C_CHL_PERSPECTIVES does not reference any database object

AMV.AMV_C_CHL_PERSPECTIVES is referenced by following:

APPS

SYNONYM - AMV_C_CHL_PERSPECTIVES

[top of page]

Table: AMV_C_CONTENT_TYPES

Primary Key: AMV_C_CONTENT_TYPES_PK

1. CHANNEL_CONTENT_TYPE_ID

Primary Key: AMV_C_CONTENT_TYPES_UK1

1. CHANNEL_ID
2. CONTENT_TYPE_ID

Foreign Keys from this table:

Comments

AMV_C_CONTENT_TYPES stores all content types associated with a specific channel. If content types are set up for a channel they can be used as part of a matching criteria to decide if information should be published to this channel.
Examples could be 'white paper', 'sales presentation', 'internal documents'.

Indexes

Columns

[top of page]

AMV.AMV_C_CONTENT_TYPES does not reference any database object

AMV.AMV_C_CONTENT_TYPES is referenced by following:

APPS

SYNONYM - AMV_C_CONTENT_TYPES

[top of page]

Table: AMV_C_ITEM_TYPES

Primary Key: AMV_C_ITEM_TYPES_PK

1. CHANNEL_ITEM_TYPE_ID

Primary Key: AMV_C_ITEM_TYPES_UK1

1. CHANNEL_ID
2. ITEM_TYPE

Foreign Keys from this table:

Comments

AMV_C_ITEM_TYPES stores all item types associated with a specific channel. If item types are set up for a channel they can be used as part of a matching criteria to decide if information should be published to this channel.

Indexes

Columns

[top of page]

AMV.AMV_C_ITEM_TYPES does not reference any database object

AMV.AMV_C_ITEM_TYPES is referenced by following:

APPS

SYNONYM - AMV_C_ITEM_TYPES

[top of page]

Table: AMV_C_KEYWORDS

Primary Key: AMV_C_KEYWORDS_PK

1. CHANNEL_KEYWORD_ID

Primary Key: AMV_C_KEYWORDS_UK1

1. CHANNEL_ID
2. KEYWORD

Foreign Keys from this table:

Comments

AMV_C_KEYWORDS stores all keywords associated with a specific channel. If key words are set up for a channel they can be used as part of a matching criteria to decide if information should be published to this channel.

Indexes

Columns

[top of page]

AMV.AMV_C_KEYWORDS does not reference any database object

AMV.AMV_C_KEYWORDS is referenced by following:

APPS

SYNONYM - AMV_C_KEYWORDS

[top of page]

Table: AMV_D_ATTRIB_OPERATORS

Primary Key: AMV_D_ATTRIB_OPERATORS_PK

1. ATTRIBUTE_OPERATOR_ID

Primary Key: AMV_D_ATTRIB_OPERATORS_UK1

1. ATTRIBUTE_ID
2. OPERATOR_TYPE

Foreign Keys from this table:

Foreign Keys to this table:

Comments

AMV_D_ATTRIB_OPERATORS stores what operators can be applied to a certain attribute within an entity. Operators could be <=, =>, = and between. This is set up/reference data and is later on used as part of defining a distribution rule.

Indexes

Columns

[top of page]

AMV.AMV_D_ATTRIB_OPERATORS does not reference any database object

AMV.AMV_D_ATTRIB_OPERATORS is referenced by following:

APPS

SYNONYM - AMV_D_ATTRIB_OPERATORS

[top of page]

Table: AMV_D_COMPL_RULE_ITEMS

Primary Key: AMV_D_COMPL_RULE_ITEMS_PK

1. COMPLEX_RULE_ITEM_ID

Foreign Keys from this table:

Comments

AMV_D_COMPL_RULE_ITEMS stores what rule conditions together build up a complex distribution rule.
Example of two rule conditions:
Customer.Revenue 'BETWEEN 100 and 200'
Customer.Profile = 'Fortune 500 Company'
So, this table documents the fact that this item should only be published to the calling application (e.g. Deal Maker from OFS) if both of the conditions above are met. ('Met' means that the parameters passed in by the calling application contain these values). Basically this table can be seen as grouping rule conditions together with an 'AND' condition.

Indexes

Columns

[top of page]

AMV.AMV_D_COMPL_RULE_ITEMS does not reference any database object

AMV.AMV_D_COMPL_RULE_ITEMS is referenced by following:

APPS

SYNONYM - AMV_D_COMPL_RULE_ITEMS

[top of page]

Table: AMV_D_ENTITIES_B

Primary Key: AMV_D_ENTITIES_B_PK

1. ENTITY_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

AMV_D_ENTITIES_B stores all tables that could be part of a rule condition. An entity always belong to a certain application. Examples of entities could be Customer, Contact, Quote, Search Engine.

Indexes

Columns

[top of page]

AMV.AMV_D_ENTITIES_B does not reference any database object

AMV.AMV_D_ENTITIES_B is referenced by following:

APPS

SYNONYM - AMV_D_ENTITIES_B

[top of page]

Table: AMV_D_ENTITIES_TL

Primary Key: AMV_D_ENTITIES_TL_PK

1. ENTITY_ID
2. LANGUAGE

Foreign Keys from this table:

Comments

AMV_D_ENTITIES_TL stores all translations of tables that could be part of a rule condition.

Indexes

Columns

[top of page]

AMV.AMV_D_ENTITIES_TL does not reference any database object

AMV.AMV_D_ENTITIES_TL is referenced by following:

APPS

SYNONYM - AMV_D_ENTITIES_TL

[top of page]

Table: AMV_D_ENT_ATTRIBUTES_B

Primary Key: AMV_D_ENT_ATTRIBUTES_B_PK

1. ATTRIBUTE_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

AMV_D_ENT_ATTRIBUTES_B stores all attributes within an entity that can be part of a rule condition.
Examples could be:
Entity.Attribute
Customer.Revenue
Customer.Profile

Indexes

Columns

[top of page]

AMV.AMV_D_ENT_ATTRIBUTES_B does not reference any database object

AMV.AMV_D_ENT_ATTRIBUTES_B is referenced by following:

APPS

SYNONYM - AMV_D_ENT_ATTRIBUTES_B

[top of page]

Table: AMV_D_ENT_ATTRIBUTES_TL

Primary Key: AMV_D_ENT_ATTRIBUTES_TL_PK

1. LANGUAGE
2. ATTRIBUTE_ID

Foreign Keys from this table:

Comments

AMV_D_ENT_ATTRIBUTES_TL stores all translated attributes within an entity that can be part of a rule condition.

Indexes

Columns

[top of page]

AMV.AMV_D_ENT_ATTRIBUTES_TL does not reference any database object

AMV.AMV_D_ENT_ATTRIBUTES_TL is referenced by following:

APPS

SYNONYM - AMV_D_ENT_ATTRIBUTES_TL

[top of page]

Table: AMV_D_RULE_CONDITIONS

Primary Key: AMV_D_RULE_CONDITIONS_PK

1. RULE_CONDITION_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

AMV_D_RULE_CONDITIONS stores all rule conditions within MES.
Example of two rule conditions:
Customer.Revenue 'BETWEEN 100 and 200'
Customer.Profile = 'Fortune 500 Company'

Indexes

Columns

[top of page]

AMV.AMV_D_RULE_CONDITIONS does not reference any database object

AMV.AMV_D_RULE_CONDITIONS is referenced by following:

APPS

SYNONYM - AMV_D_RULE_CONDITIONS

[top of page]

Table: AMV_D_SIMPLE_RULE_ITEMS

Primary Key: AMV_D_SIMPLE_RULE_ITEMS_PK

1. SIMPLE_RULE_ITEM_ID

Foreign Keys from this table:

Comments

AMV_D_SIMPLE_RULE_ITEMS stores what items have been associated with a rule condition. This is an intersection table between ITEM and DISTRIBUTION RULES.

Indexes

Columns

[top of page]

AMV.AMV_D_SIMPLE_RULE_ITEMS does not reference any database object

AMV.AMV_D_SIMPLE_RULE_ITEMS is referenced by following:

APPS

SYNONYM - AMV_D_SIMPLE_RULE_ITEMS

[top of page]

Table: AMV_I_CONTENT_TYPES_B

Primary Key: AMV_I_CONTENT_TYPES_B_PK

1. CONTENT_TYPE_ID

Foreign Keys to this table:

Comments

AMV_I_CONTENT_TYPES_B stores all content types which can be used by an item or a channel.

Indexes

Columns

[top of page]

AMV.AMV_I_CONTENT_TYPES_B does not reference any database object

AMV.AMV_I_CONTENT_TYPES_B is referenced by following:

APPS

SYNONYM - AMV_I_CONTENT_TYPES_B

[top of page]

Table: AMV_I_CONTENT_TYPES_TL

Primary Key: AMV_I_CONTENT_TYPES_TL_PK

1. CONTENT_TYPE_ID
2. LANGUAGE

Foreign Keys from this table:

Comments

AMV_I_CONTENT_TYPES_TL stores all translatable portion of content types

Indexes

Columns

[top of page]

AMV.AMV_I_CONTENT_TYPES_TL does not reference any database object

AMV.AMV_I_CONTENT_TYPES_TL is referenced by following:

APPS

SYNONYM - AMV_I_CONTENT_TYPES_TL

[top of page]

Table: AMV_I_ITEM_PERSPECTIVES

Primary Key: AMV_I_ITEM_PERSPECTIVES_PK

1. ITEM_PERSPECTIVE_ID

Primary Key: AMV_I_ITEM_PERSPECTIVES_UK1

1. ITEM_ID
2. PERSPECTIVE_ID

Foreign Keys from this table:

Comments

AMV_I_ITEM_PERSPECTIVES stores all perspective attributes for an item. They are used in the matching process to decide if an item should be published to a channel.

Indexes

Columns

[top of page]

AMV.AMV_I_ITEM_PERSPECTIVES does not reference any database object

AMV.AMV_I_ITEM_PERSPECTIVES is referenced by following:

APPS

SYNONYM - AMV_I_ITEM_PERSPECTIVES

[top of page]

Table: AMV_I_PERSPECTIVES_B

Primary Key: AMV_I_PERSPECTIVES_B_PK

1. PERSPECTIVE_ID

Comments

AMV_I_PERSPECTIVES_B stores perspective attributes that can be used by a channel or item.

Indexes

Columns

[top of page]

AMV.AMV_I_PERSPECTIVES_B does not reference any database object

AMV.AMV_I_PERSPECTIVES_B is referenced by following:

APPS

SYNONYM - AMV_I_PERSPECTIVES_B

[top of page]

Table: AMV_I_PERSPECTIVES_TL

Primary Key: AMV_I_PERSPECTIVES_TL_PK

1. PERSPECTIVE_ID
2. LANGUAGE

Foreign Keys from this table:

Comments

Store the translatable portion of perspectives.

Indexes

Columns

[top of page]

AMV.AMV_I_PERSPECTIVES_TL does not reference any database object

AMV.AMV_I_PERSPECTIVES_TL is referenced by following:

APPS

SYNONYM - AMV_I_PERSPECTIVES_TL

[top of page]

Table: AMV_NEWS

Primary Key: AMV_NEWS_PK

1. NEWS_ID

Foreign Keys from this table:

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]

AMV.AMV_NEWS does not reference any database object

AMV.AMV_NEWS is referenced by following:

APPS

SYNONYM - AMV_NEWS

[top of page]

Table: AMV_STOCKS

Primary Key: AMV_STOCKS_PK

1. STOCK_ID

Primary Key: AMV_STOCKS_UK1

1. STOCK_RIC

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]

AMV.AMV_STOCKS does not reference any database object

AMV.AMV_STOCKS is referenced by following:

APPS

SYNONYM - AMV_STOCKS

[top of page]

Table: AMV_STOCK_PRICE

Primary Key: AMV_STOCK_PRICE_PK

1. STOCK_PRICE_ID

Foreign Keys from this table:

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]

AMV.AMV_STOCK_PRICE does not reference any database object

AMV.AMV_STOCK_PRICE is referenced by following:

APPS

SYNONYM - AMV_STOCK_PRICE

[top of page]

Table: AMV_TEMP_IDS

Comments

Columns

[top of page]

APPS.AMV_TEMP_IDS does not reference any database object

APPS.AMV_TEMP_IDS is referenced by following:

APPS

PACKAGE BODY - AMV_SEARCH_PVT

[top of page]

Table: AMV_TEMP_NUMBERS

Comments

Columns

[top of page]

APPS.AMV_TEMP_NUMBERS does not reference any database object

APPS.AMV_TEMP_NUMBERS is referenced by following:

APPS

PACKAGE BODY - AMV_SEARCH_PVT

[top of page]

Table: AMV_USER_TICKER

Primary Key: AMV_USER_TICKER_PK

1. USER_TICKER_ID

Foreign Keys from this table:

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]

AMV.AMV_USER_TICKER does not reference any database object

AMV.AMV_USER_TICKER is referenced by following:

APPS

SYNONYM - AMV_USER_TICKER

[top of page]

Table: AMV_U_ACCESS

Primary Key: AMV_U_ACCESS_PK

1. ACCESS_ID

Primary Key: AMV_U_ACCESS_UK1

1. ACCESS_TO_TABLE_RECORD_ID
2. USER_OR_GROUP_TYPE
3. ACCESS_TO_TABLE_CODE
4. USER_OR_GROUP_ID

Foreign Keys from this table:

Comments

AMV_U_ACCESS stores what user or group have access to a channel or an application or an item and what kind of access they have.

Indexes

Columns

[top of page]

AMV.AMV_U_ACCESS does not reference any database object

AMV.AMV_U_ACCESS is referenced by following:

APPS

SYNONYM - AMV_U_ACCESS

[top of page]

Table: AMV_U_EXT_SUBSCRIPTIONS

Primary Key: AMV_U_EXT_SUBSCRIPTIONS_PK

1. SUBSCRIPTION_ID

Foreign Keys from this table:

Comments

AMV_U_EXT_SUBSCRIPTIONS stores the external user (Internet) subscription information.

Indexes

Columns

[top of page]

AMV.AMV_U_EXT_SUBSCRIPTIONS does not reference any database object

AMV.AMV_U_EXT_SUBSCRIPTIONS is referenced by following:

APPS

SYNONYM - AMV_U_EXT_SUBSCRIPTIONS

[top of page]

Table: AMV_U_MY_CHANNELS

Primary Key: AMV_U_MY_CHANNELS_PK

1. MY_CHANNEL_ID

Primary Key: AMV_U_MY_CHANNELS_UK1

1. SUBSCRIBING_TO_ID
2. SUBSCRIBING_TO_TYPE
3. USER_OR_GROUP_ID

Foreign Keys from this table:

Comments

AMV_U_MY_CHANNELS stores all channels a user is subscribing to. My channel consist of:
- Subscribed Channels (can be a group or content channel or a channel category)
- Private Channels (created by the user)
- Group Channels (if it has been set as required)

Indexes

Columns

[top of page]

AMV.AMV_U_MY_CHANNELS does not reference any database object

AMV.AMV_U_MY_CHANNELS is referenced by following:

APPS

SYNONYM - AMV_U_MY_CHANNELS

[top of page]

Table: AMV_VENDOR_KEYS

Primary Key: AMV_VENDOR_KEYS_PK

1. VENDOR_KEY_ID

Foreign Keys from this table:

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]

AMV.AMV_VENDOR_KEYS does not reference any database object

AMV.AMV_VENDOR_KEYS is referenced by following:

APPS

SYNONYM - AMV_VENDOR_KEYS

[top of page]

View: AMV_C_CATEGORIES_VL

Comments

View Type

MultiLingual view (a language resolved view of the data.)

AMV_C_CATEGORIES_VL is a view on the base and translation tables that contains the translated label based on the current language.

Columns

[top of page]

APPS

SYNONYM - AMV_C_CATEGORIES_B

SYNONYM - AMV_C_CATEGORIES_TL

APPS

PACKAGE BODY - AMV_CATEGORY_PVT

PACKAGE BODY - AMV_SEARCH_PVT

PACKAGE BODY - IBU_MES_BIN

PACKAGE BODY - IEM_AMV_PVT

PACKAGE - IEM_AMV_PVT

[top of page]

View: AMV_C_CHANNELS_VL

Comments

View Type

MultiLingual view (a language resolved view of the data.)

AMV_C_CHANNELS_VL is a view on the base and translation tables that contains the translated label based on the current language.

Columns

[top of page]

APPS

SYNONYM - AMV_C_CHANNELS_B

SYNONYM - AMV_C_CHANNELS_TL

APPS

PACKAGE BODY - AMV_CATEGORY_PVT

PACKAGE BODY - AMV_ITEM_PUB

PACKAGE BODY - AMV_MYCHANNEL_PVT

PACKAGE BODY - AMV_SEARCH_PVT

PACKAGE BODY - AMV_USER_PVT

PACKAGE BODY - AMV_WFAPPROVAL_PVT

PACKAGE BODY - IBU_DYN_USER_GROUPS_PKG

[top of page]

View: AMV_D_ENTITIES_VL

Comments

View Type

MultiLingual view (a language resolved view of the data.)

AMV_D_ENTITIES_VL is a view on the base and translation tables that contains the translated label based on the current language.

Columns

[top of page]

APPS

SYNONYM - AMV_D_ENTITIES_B

SYNONYM - AMV_D_ENTITIES_TL

APPS.AMV_D_ENTITIES_VL is not referenced by any database object

[top of page]

View: AMV_D_ENT_ATTRIBUTES_VL

Comments

View Type

MultiLingual view (a language resolved view of the data.)

AMV_D_ENT_ATTRIBUTES_VL is a view on the base and translation tables that contains the translated label based on the current language.

Columns

[top of page]

APPS

SYNONYM - AMV_D_ENT_ATTRIBUTES_B

SYNONYM - AMV_D_ENT_ATTRIBUTES_TL

APPS.AMV_D_ENT_ATTRIBUTES_VL is not referenced by any database object

[top of page]

View: AMV_I_CONTENT_TYPES_VL

Comments

View Type

MultiLingual view (a language resolved view of the data.)

AMV_I_CONTENT_TYPES_VL is a view on the base and translation tables that contains the translated label based on the current language.

Columns

[top of page]

APPS

SYNONYM - AMV_I_CONTENT_TYPES_B

SYNONYM - AMV_I_CONTENT_TYPES_TL

APPS.AMV_I_CONTENT_TYPES_VL is not referenced by any database object

[top of page]

View: AMV_RS_ALL_RES_EXTNS_VL

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.

View Type

MultiLingual view (a language resolved view of the data.)

View based on jtf_rs_resource_extns

Columns

[top of page]

APPS

SYNONYM - JTF_RS_RESOURCE_EXTNS

APPS

PACKAGE BODY - AMV_MATCH_PVT

PACKAGE BODY - AMV_MYCHANNEL_PVT

PACKAGE BODY - AMV_USER_PVT

[top of page]