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

TABLE - ASG.ASG_APPLICATIONS_B
TABLE - ASG.ASG_APPLICATIONS_TL
TABLE - ASG.ASG_COLUMN_GROUPS
TABLE - ASG.ASG_CONF_RESOLUTION
TABLE - ASG.ASG_DEPT
TABLE - ASG.ASG_DEVICE_USERS
TABLE - ASG.ASG_EMP
TABLE - ASG.ASG_ERROR
TABLE - ASG.ASG_FLASH_MESSAGES
TABLE - ASG.ASG_FLASH_RECIPIENTS
TABLE - ASG.ASG_INCIDENT_ACC
TABLE - ASG.ASG_ITEM_INDEX
TABLE - ASG.ASG_LOCATION_ACC
TABLE - ASG.ASG_MAP_PUB_ITEMS
TABLE - ASG.ASG_MDG_INDEXES
TABLE - ASG.ASG_MDG_SNAPSHOTS
TABLE - ASG.ASG_MOBILE_ACCESSES
TABLE - ASG.ASG_PARENT_HINT
TABLE - ASG.ASG_PARTY_ACC
TABLE - ASG.ASG_PARTY_SITE_ACC
TABLE - ASG.ASG_PRIMARY_KEY_HINT
TABLE - ASG.ASG_PUBLICATIONS
TABLE - ASG.ASG_PUBLICATION_ITEMS
TABLE - ASG.ASG_SEQUENCES
TABLE - ASG.ASG_SERVER_PUBS
TABLE - ASG.ASG_SERVER_RESOURCES
TABLE - ASG.ASG_SNAPSHOT_LOGS
TABLE - ASG.ASG_SUBSCRIPTION_PARAMS
TABLE - ASG.ASG_SYNCH_SERVER
TABLE - ASG.ASG_SYSTEM_LOGS
TABLE - ASG.ASG_SYSTEM_LOG_TEXT
TABLE - ASG.ASG_SYSTEM_PKGS
TABLE - ASG.ASG_SYSTEM_QUEUES
TABLE - ASG.ASG_TASK_ACC
TABLE - ASG.ASG_WIRELESS_PARAMETERS
VIEW - APPS.ASG_APPLICATION_VL
VIEW - APPS.ASG_USER_VERSIONS

Table: ASG_APPLICATIONS_B

Description: Stores all the various mobile application supported
Primary Key: ASG_APPLICATIONS_B_PK
  1. MOBILE_APPLICATION_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
ASG_DEVICE_USERS.MOBILE_APPLICATION_ID ASG_APPLICATIONS_B

[top of page]

ASG.ASG_APPLICATIONS_B does not reference any database object

ASG.ASG_APPLICATIONS_B is referenced by following:

ASG
VIEW - ASG_APPLICATIONS_B#

[top of page]

Table: ASG_APPLICATIONS_TL

Description: Stores mobile application names in various languages. Seeded table
Primary Key: ASG_APPLICATIONS_TL_PK
  1. MOBILE_APPLICATION_ID
  2. LANGUAGE

[top of page]

ASG.ASG_APPLICATIONS_TL does not reference any database object

ASG.ASG_APPLICATIONS_TL is referenced by following:

ASG
VIEW - ASG_APPLICATIONS_TL#

[top of page]

Table: ASG_COLUMN_GROUPS

Description:
Primary Key: ASG_COLUMN_GROUPS_PK
  1. COLUMN_GROUP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ASG_COLUMN_GROUPS.SNAPSHOT_LOG_ID ASG_SNAPSHOT_LOGS
Foreign Keys to this table:
Foreign Key Column Foreign Table
ASG_CONF_RESOLUTION.COLUMN_GROUP_ID ASG_COLUMN_GROUPS

[top of page]

ASG.ASG_COLUMN_GROUPS does not reference any database object

ASG.ASG_COLUMN_GROUPS is referenced by following:

ASG
VIEW - ASG_COLUMN_GROUPS#

[top of page]

Table: ASG_CONF_RESOLUTION

Description:
Primary Key: ASG_CONF_RESOLUTION_PK
  1. CONF_RESOLUTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ASG_CONF_RESOLUTION.SNAPSHOT_LOG_ID ASG_SNAPSHOT_LOGS
ASG_CONF_RESOLUTION.COLUMN_GROUP_ID ASG_COLUMN_GROUPS

[top of page]

ASG.ASG_CONF_RESOLUTION does not reference any database object

ASG.ASG_CONF_RESOLUTION is referenced by following:

ASG
VIEW - ASG_CONF_RESOLUTION#

[top of page]

Table: ASG_DEPT

Description: sample table
Primary Key: ASG_DEPT_PK
  1. DEPTNO
Foreign Keys to this table:
Foreign Key Column Foreign Table
ASG_EMP.DEPTNO ASG_DEPT

[top of page]

ASG.ASG_DEPT does not reference any database object

ASG.ASG_DEPT is referenced by following:

ASG
VIEW - ASG_DEPT#

[top of page]

Table: ASG_DEVICE_USERS

Description: Stores information of a resource, such as a service engineer or a salesman, related to a mobile application
Primary Key: ASG_DEVICE_USERS_PK
  1. DEVICE_USER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ASG_DEVICE_USERS.USER_ID FND_USER
ASG_DEVICE_USERS.RESOURCE_ID JTF_RS_RESOURCE_EXTNS
ASG_DEVICE_USERS.MOBILE_APPLICATION_ID ASG_APPLICATIONS_B
ASG_DEVICE_USERS.SERVER_ID ASG_SYNCH_SERVER
Foreign Keys to this table:
Foreign Key Column Foreign Table
ASG_ERROR.DEVICE_USER_ID ASG_DEVICE_USERS
ASG_FLASH_RECIPIENTS.DEVICE_USER_ID ASG_DEVICE_USERS

[top of page]

ASG.ASG_DEVICE_USERS does not reference any database object

ASG.ASG_DEVICE_USERS is referenced by following:

ASG
VIEW - ASG_DEVICE_USERS#

[top of page]

Table: ASG_EMP

Description: sample table
Primary Key: ASG_EMP_PK
  1. EMPNO
Foreign Keys from this table:
Foreign Key Column Foreign Table
ASG_EMP.DEPTNO ASG_DEPT

[top of page]

ASG.ASG_EMP does not reference any database object

ASG.ASG_EMP is referenced by following:

ASG
VIEW - ASG_EMP#

[top of page]

Table: ASG_ERROR

Description: Stores information of error logs.
Primary Key: ASG_ERROR_PK
  1. MOBILE_ERROR_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ASG_ERROR.DEVICE_USER_ID ASG_DEVICE_USERS

[top of page]

ASG.ASG_ERROR does not reference any database object

ASG.ASG_ERROR is referenced by following:

ASG
VIEW - ASG_ERROR#

[top of page]

Table: ASG_FLASH_MESSAGES

Description: Stores all flash messages
Primary Key: ASG_FLASH_MESSAGES_PK
  1. FLASH_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
ASG_FLASH_RECIPIENTS.FLASH_ID ASG_FLASH_MESSAGES

[top of page]

ASG.ASG_FLASH_MESSAGES does not reference any database object

ASG.ASG_FLASH_MESSAGES is referenced by following:

ASG
VIEW - ASG_FLASH_MESSAGES#

[top of page]

Table: ASG_FLASH_RECIPIENTS

Description: Stores all recepients for all the flash messages
Primary Key: ASG_FLASH_RECIPIENTS_PK
  1. MOBILE_FLASH_SUBS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ASG_FLASH_RECIPIENTS.DEVICE_USER_ID ASG_DEVICE_USERS
ASG_FLASH_RECIPIENTS.FLASH_ID ASG_FLASH_MESSAGES

[top of page]

ASG.ASG_FLASH_RECIPIENTS does not reference any database object

ASG.ASG_FLASH_RECIPIENTS is referenced by following:

ASG
VIEW - ASG_FLASH_RECIPIENTS#

[top of page]

Table: ASG_INCIDENT_ACC

Description: Stores information that indicates whether the gateway server can access a service request.
Primary Key: ASG_INCIDENT_ACC_PK
  1. INCIDENT_ID
  2. SERVER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ASG_INCIDENT_ACC.SERVER_ID ASG_SYNCH_SERVER

[top of page]

ASG.ASG_INCIDENT_ACC does not reference any database object

ASG.ASG_INCIDENT_ACC is referenced by following:

ASG
VIEW - ASG_INCIDENT_ACC#

[top of page]

Table: ASG_ITEM_INDEX

Description: Indexes related to a publication item
Primary Key: ASG_ITEM_INDEX_PK
  1. ITEM_ID
  2. INDEX_ID
Primary Key: ASG_ITEM_INDEX_UK1
  1. INDEX_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ASG_ITEM_INDEX.ITEM_ID ASG_PUBLICATION_ITEMS

[top of page]

ASG.ASG_ITEM_INDEX does not reference any database object

ASG.ASG_ITEM_INDEX is referenced by following:

ASG
VIEW - ASG_ITEM_INDEX#

[top of page]

Table: ASG_LOCATION_ACC

Description: Stores information that indicates whether the gateway server can access a location.
Primary Key: ASG_LOCATION_ACC_PK
  1. LOCATION_ID
  2. SERVER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ASG_LOCATION_ACC.SERVER_ID ASG_SYNCH_SERVER

[top of page]

ASG.ASG_LOCATION_ACC does not reference any database object

ASG.ASG_LOCATION_ACC is referenced by following:

ASG
VIEW - ASG_LOCATION_ACC#

[top of page]

Table: ASG_MAP_PUB_ITEMS

Description: Defines relationship between publication and items
Primary Key: ASG_MAP_PUB_ITEMS_PK
  1. MAP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ASG_MAP_PUB_ITEMS.ITEM_ID ASG_PUBLICATION_ITEMS
ASG_MAP_PUB_ITEMS.PUBLICATION_ID ASG_PUBLICATIONS

[top of page]

ASG.ASG_MAP_PUB_ITEMS does not reference any database object

ASG.ASG_MAP_PUB_ITEMS is referenced by following:

ASG
VIEW - ASG_MAP_PUB_ITEMS#

[top of page]

Table: ASG_MDG_INDEXES

Description:
Primary Key: ASG_MDG_INDEXES_PK
  1. MDG_INDEX_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ASG_MDG_INDEXES.MDG_SNAPSHOT_ID ASG_MDG_SNAPSHOTS

[top of page]

ASG.ASG_MDG_INDEXES does not reference any database object

ASG.ASG_MDG_INDEXES is referenced by following:

ASG
VIEW - ASG_MDG_INDEXES#

[top of page]

Table: ASG_MDG_SNAPSHOTS

Description:
Primary Key: ASG_MDG_SNAPSHOTS_PK
  1. MDG_SNAPSHOT_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
ASG_MDG_INDEXES.MDG_SNAPSHOT_ID ASG_MDG_SNAPSHOTS

[top of page]

ASG.ASG_MDG_SNAPSHOTS does not reference any database object

ASG.ASG_MDG_SNAPSHOTS is referenced by following:

ASG
VIEW - ASG_MDG_SNAPSHOTS#

[top of page]

Table: ASG_MOBILE_ACCESSES

Description:
Primary Key: ASG_MOBILE_ACCESSES_PK
  1. MOBILE_ACCESS_ID

[top of page]

ASG.ASG_MOBILE_ACCESSES does not reference any database object

ASG.ASG_MOBILE_ACCESSES is referenced by following:

ASG
VIEW - ASG_MOBILE_ACCESSES#

[top of page]

Table: ASG_PARENT_HINT

Description: Parent hints for Publication items
Primary Key: ASG_PARENT_HINT_PK
  1. PARENT_HINT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ASG_PARENT_HINT.ITEM_ID ASG_PUBLICATION_ITEMS

[top of page]

ASG.ASG_PARENT_HINT does not reference any database object

ASG.ASG_PARENT_HINT is referenced by following:

ASG
VIEW - ASG_PARENT_HINT#

[top of page]

Table: ASG_PARTY_ACC

Description: Stores information that indicates whether the gateway server can access a party.
Primary Key: ASG_PARTY_ACC_PK
  1. SERVER_ID
  2. PARTY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ASG_PARTY_ACC.SERVER_ID ASG_SYNCH_SERVER

[top of page]

ASG.ASG_PARTY_ACC does not reference any database object

ASG.ASG_PARTY_ACC is referenced by following:

ASG
VIEW - ASG_PARTY_ACC#

[top of page]

Table: ASG_PARTY_SITE_ACC

Description: Stores information that indicates whether the gateway server can access a party site.
Primary Key: ASG_PARTY_SITE_ACC_PK
  1. SERVER_ID
  2. PARTY_SITE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ASG_PARTY_SITE_ACC.SERVER_ID ASG_SYNCH_SERVER

[top of page]

ASG.ASG_PARTY_SITE_ACC does not reference any database object

ASG.ASG_PARTY_SITE_ACC is referenced by following:

ASG
VIEW - ASG_PARTY_SITE_ACC#

[top of page]

Table: ASG_PRIMARY_KEY_HINT

Description: Stores the Primary Key hints for publication items
Primary Key: ASG_PRIMARY_KEY_HINT_PK
  1. PRIMARY_HINT_ID
Primary Key: ASG_PRIMARY_KEY_HINT_UK1
  1. ITEM_ID
  2. KEY_COLUMN
Foreign Keys from this table:
Foreign Key Column Foreign Table
ASG_PRIMARY_KEY_HINT.ITEM_ID ASG_PUBLICATION_ITEMS

[top of page]

ASG.ASG_PRIMARY_KEY_HINT does not reference any database object

ASG.ASG_PRIMARY_KEY_HINT is referenced by following:

ASG
VIEW - ASG_PRIMARY_KEY_HINT#

[top of page]

Table: ASG_PUBLICATIONS

Description: Stores all I-Connect publication names
Primary Key: ASG_PUBLICATIONS_PK
  1. PUBLICATION_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
ASG_MAP_PUB_ITEMS.PUBLICATION_ID ASG_PUBLICATIONS
ASG_SEQUENCES.PUBLICATION_ID ASG_PUBLICATIONS
ASG_SUBSCRIPTION_PARAMS.PUBLICATION_ID ASG_PUBLICATIONS
ASG_SERVER_PUBS.PUBLICATION_ID ASG_PUBLICATIONS

[top of page]

ASG.ASG_PUBLICATIONS does not reference any database object

ASG.ASG_PUBLICATIONS is referenced by following:

ASG
VIEW - ASG_PUBLICATIONS#

[top of page]

Table: ASG_PUBLICATION_ITEMS

Description: Stores all I-Connect publication items.
Primary Key: ASG_PUBLICATION_ITEMS_PK
  1. ITEM_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
ASG_ITEM_INDEX.ITEM_ID ASG_PUBLICATION_ITEMS
ASG_MAP_PUB_ITEMS.ITEM_ID ASG_PUBLICATION_ITEMS
ASG_PARENT_HINT.ITEM_ID ASG_PUBLICATION_ITEMS
ASG_PRIMARY_KEY_HINT.ITEM_ID ASG_PUBLICATION_ITEMS

[top of page]

ASG.ASG_PUBLICATION_ITEMS does not reference any database object

ASG.ASG_PUBLICATION_ITEMS is referenced by following:

ASG
VIEW - ASG_PUBLICATION_ITEMS#

[top of page]

Table: ASG_SEQUENCES

Description: Sequences on Mobile Device
Primary Key: ASG_SEQUENCES_PK
  1. SEQUENCE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ASG_SEQUENCES.PUBLICATION_ID ASG_PUBLICATIONS

[top of page]

ASG.ASG_SEQUENCES does not reference any database object

ASG.ASG_SEQUENCES is referenced by following:

ASG
VIEW - ASG_SEQUENCES#

[top of page]

Table: ASG_SERVER_PUBS

Description:
Primary Key: SERVER_PUBS_ID_PK
  1. SERVER_PUBS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ASG_SERVER_PUBS.PUBLICATION_ID ASG_PUBLICATIONS
ASG_SERVER_PUBS.SERVER_ID ASG_SYNCH_SERVER

[top of page]

ASG.ASG_SERVER_PUBS does not reference any database object

ASG.ASG_SERVER_PUBS is referenced by following:

ASG
VIEW - ASG_SERVER_PUBS#

[top of page]

Table: ASG_SERVER_RESOURCES

Description: Stores all users(resources) using a particular middle-tier
Primary Key: ASG_SERVER_RESOURCES_PK
  1. RESOURCE_ID
  2. SERVER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ASG_SERVER_RESOURCES.SERVER_ID ASG_SYNCH_SERVER

[top of page]

ASG.ASG_SERVER_RESOURCES does not reference any database object

ASG.ASG_SERVER_RESOURCES is referenced by following:

ASG
VIEW - ASG_SERVER_RESOURCES#

[top of page]

Table: ASG_SNAPSHOT_LOGS

Description:
Primary Key: SNAPSHOT_LOG_ID_PK
  1. SNAPSHOT_LOG_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
ASG_CONF_RESOLUTION.SNAPSHOT_LOG_ID ASG_SNAPSHOT_LOGS
ASG_COLUMN_GROUPS.SNAPSHOT_LOG_ID ASG_SNAPSHOT_LOGS

[top of page]

ASG.ASG_SNAPSHOT_LOGS does not reference any database object

ASG.ASG_SNAPSHOT_LOGS is referenced by following:

ASG
VIEW - ASG_SNAPSHOT_LOGS#

[top of page]

Table: ASG_SUBSCRIPTION_PARAMS

Description: subscription parametres
Foreign Keys from this table:
Foreign Key Column Foreign Table
ASG_SUBSCRIPTION_PARAMS.PUBLICATION_ID ASG_PUBLICATIONS

[top of page]

ASG.ASG_SUBSCRIPTION_PARAMS does not reference any database object

ASG.ASG_SUBSCRIPTION_PARAMS is referenced by following:

ASG
VIEW - ASG_SUBSCRIPTION_PARAMS#

[top of page]

Table: ASG_SYNCH_SERVER

Description: Informating about all the Mobile Device Gateway
Primary Key: ASG_SYNCH_SERVER_PK
  1. SERVER_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
ASG_DEVICE_USERS.SERVER_ID ASG_SYNCH_SERVER
ASG_INCIDENT_ACC.SERVER_ID ASG_SYNCH_SERVER
ASG_LOCATION_ACC.SERVER_ID ASG_SYNCH_SERVER
ASG_PARTY_ACC.SERVER_ID ASG_SYNCH_SERVER
ASG_PARTY_SITE_ACC.SERVER_ID ASG_SYNCH_SERVER
ASG_SERVER_RESOURCES.SERVER_ID ASG_SYNCH_SERVER
ASG_TASK_ACC.SERVER_ID ASG_SYNCH_SERVER
ASG_WIRELESS_PARAMETERS.SERVER_ID ASG_SYNCH_SERVER
ASG_SERVER_PUBS.SERVER_ID ASG_SYNCH_SERVER

[top of page]

ASG.ASG_SYNCH_SERVER does not reference any database object

ASG.ASG_SYNCH_SERVER is referenced by following:

ASG
VIEW - ASG_SYNCH_SERVER#

[top of page]

Table: ASG_SYSTEM_LOGS

Description:
Primary Key: ASG_SYSTEM_LOGS_PK
  1. SYSTEM_LOG_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
ASG_SYSTEM_LOG_TEXT.SYSTEM_LOG_ID ASG_SYSTEM_LOGS

[top of page]

ASG.ASG_SYSTEM_LOGS does not reference any database object

ASG.ASG_SYSTEM_LOGS is referenced by following:

ASG
VIEW - ASG_SYSTEM_LOGS#

[top of page]

Table: ASG_SYSTEM_LOG_TEXT

Description:
Primary Key: ASG_SYSTEM_LOG_TEXT_PK
  1. SYSTEM_LOG_ID
  2. LINE_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
ASG_SYSTEM_LOG_TEXT.SYSTEM_LOG_ID ASG_SYSTEM_LOGS

[top of page]

ASG.ASG_SYSTEM_LOG_TEXT does not reference any database object

ASG.ASG_SYSTEM_LOG_TEXT is referenced by following:

ASG
VIEW - ASG_SYSTEM_LOG_TEXT#

[top of page]

Table: ASG_SYSTEM_PKGS

Description:
Primary Key: ASG_SYSTEM_PKGS_PK
  1. SYSTEM_PKG_ID

[top of page]

ASG.ASG_SYSTEM_PKGS does not reference any database object

ASG.ASG_SYSTEM_PKGS is referenced by following:

ASG
VIEW - ASG_SYSTEM_PKGS#

[top of page]

Table: ASG_SYSTEM_QUEUES

Description:
Primary Key: ASG_SYSTEM_QUEUES_PK
  1. SYSTEM_QUEUE_ID

[top of page]

ASG.ASG_SYSTEM_QUEUES does not reference any database object

ASG.ASG_SYSTEM_QUEUES is referenced by following:

ASG
VIEW - ASG_SYSTEM_QUEUES#

[top of page]

Table: ASG_TASK_ACC

Description: Stores information that indicates whether the gateway server can access a task.
Primary Key: ASG_TASK_ACC_PK
  1. SERVER_ID
  2. TASK_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ASG_TASK_ACC.SERVER_ID ASG_SYNCH_SERVER

[top of page]

ASG.ASG_TASK_ACC does not reference any database object

ASG.ASG_TASK_ACC is referenced by following:

ASG
VIEW - ASG_TASK_ACC#

[top of page]

Table: ASG_WIRELESS_PARAMETERS

Description: profile values for wireless
Primary Key: ASG_WIRELESS_PARAMETERS_PK
  1. WIRELESS_PARAMETERS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
ASG_WIRELESS_PARAMETERS.SERVER_ID ASG_SYNCH_SERVER

[top of page]

ASG.ASG_WIRELESS_PARAMETERS does not reference any database object

ASG.ASG_WIRELESS_PARAMETERS is referenced by following:

ASG
VIEW - ASG_WIRELESS_PARAMETERS#

[top of page]

View: ASG_APPLICATION_VL

[top of page]

APPS.ASG_APPLICATION_VL references the following:

APPS
SYNONYM - ASG_APPLICATIONS_B
SYNONYM - ASG_APPLICATIONS_TL

APPS.ASG_APPLICATION_VL is not referenced by any database object

[top of page]

View: ASG_USER_VERSIONS

[top of page]

APPS.ASG_USER_VERSIONS references the following:

APPS
SYNONYM - ASG_APPLICATIONS_B
SYNONYM - ASG_DEVICE_USERS
SYNONYM - ASG_PUBLICATIONS
SYNONYM - ASG_SERVER_PUBS
SYNONYM - ASG_SYNCH_SERVER

APPS.ASG_USER_VERSIONS is not referenced by any database object

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