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
Comments

Stores all the various mobile applications supported

Indexes
Index Type Tablespace Column
ASG_APPLICATIONS_B_U1 UNIQUE APPS_TS_ARCHIVE MOBILE_APPLICATION_ID
Columns
Name Datatype Length Mandatory Comments
MOBILE_APPLICATION_ID NUMBER
Y Mobile application identifier. Primary key
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
DEVICE_TYPE VARCHAR2 (30)
Mobile device type such as 'PALM' 'WINCE' LAPTOP'.
APP_VERSION VARCHAR2 (30)
Version of mobile application
STATUS VARCHAR2 (1)
Status flag
FLASH_MESSAGE_LENGTH NUMBER

If the application supports flash messages, the max length of messages
APPLICATION_CODE VARCHAR2 (60) Y application code
SYNCHRONIZATION_FLAG VARCHAR2 (1)
Synchronization flag. 'Y' if the application supports synchronization
SMS VARCHAR2 (1)
SMS flag. 'Y' if the application supports SMS
EMAIL VARCHAR2 (1)
Email flag. 'Y' if the application supports email
SECURITY_GROUP_ID NUMBER

Used in hosted environments

[top of page]

ASG.ASG_APPLICATIONS_B does not reference any database object

ASG.ASG_APPLICATIONS_B is referenced by following:

APPS
SYNONYM - 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
Comments

Stores mobile application names in vatious languages. Seeded table

Indexes
Index Type Tablespace Column
ASG_APPLICATIONS_TL_U1 UNIQUE APPS_TS_ARCHIVE LANGUAGE
MOBILE_APPLICATION_ID
SOURCE_LANG
Columns
Name Datatype Length Mandatory Comments
MOBILE_APPLICATION_ID NUMBER
Y Mobile application identifier.
LANGUAGE VARCHAR2 (4) Y Specific language in which mobile application name is stored.
SOURCE_LANG VARCHAR2 (4) Y Base language in which mobile application name is stored
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
MOBILE_APPLICATION_NAME VARCHAR2 (240)
Name of mobile application in the language specified
SECURITY_GROUP_ID NUMBER

Used in hosted environments

[top of page]

ASG.ASG_APPLICATIONS_TL does not reference any database object

ASG.ASG_APPLICATIONS_TL is referenced by following:

APPS
SYNONYM - 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
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
Name Datatype Length Mandatory Comments
COLUMN_GROUP_ID NUMBER
Y
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
SNAPSHOT_LOG_ID NUMBER
Y
COLUMN_GROUP VARCHAR2 (60) Y
LIST_OF_COLUMNS VARCHAR2 (1024)
STATUS VARCHAR2 (5)
SECURITY_GROUP_ID NUMBER

RELEASE_VERSION NUMBER

[top of page]

ASG.ASG_COLUMN_GROUPS does not reference any database object

ASG.ASG_COLUMN_GROUPS is referenced by following:

APPS
SYNONYM - 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
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
Name Datatype Length Mandatory Comments
CONF_RESOLUTION_ID NUMBER
Y
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
SNAPSHOT_LOG_ID NUMBER
Y
COLUMN_GROUP_ID NUMBER

CONFLICT_TYPE VARCHAR2 (30)
SEQUENCE_NO NUMBER

METHOD VARCHAR2 (30)
PARAMETER_COLUMN_NAME VARCHAR2 (240)
FUNCTION_NAME VARCHAR2 (240)
CONF_RESOLUTION_COMMENT VARCHAR2 (240)
STATUS VARCHAR2 (5)
SECURITY_GROUP_ID NUMBER

RELEASE_VERSION NUMBER

[top of page]

ASG.ASG_CONF_RESOLUTION does not reference any database object

ASG.ASG_CONF_RESOLUTION is referenced by following:

APPS
SYNONYM - 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
Comments

sample table

Indexes
Index Type Tablespace Column
ASG_DEPT_U1 UNIQUE APPS_TS_ARCHIVE DEPTNO
Columns
Name Datatype Length Mandatory Comments
DEPTNO NUMBER
Y pk of table
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
DNAME VARCHAR2 (30)
department name
LOC VARCHAR2 (30)
location

[top of page]

ASG.ASG_DEPT does not reference any database object

ASG.ASG_DEPT is referenced by following:

APPS
SYNONYM - 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
Comments

Stores information of a resource, such as salesman or service engineer, related to a mobile application

Indexes
Index Type Tablespace Column
ASG_DEVICE_USERS_U1 UNIQUE APPS_TS_ARCHIVE DEVICE_USER_ID
ASG_DEVICE_USERS_U2 UNIQUE APPS_TS_ARCHIVE RESOURCE_ID
MOBILE_APPLICATION_ID
ASG_DEVICE_USERS_U3 UNIQUE APPS_TS_ARCHIVE CLIENT_NUMBER
ASG_DEVICE_USERS_U4 UNIQUE APPS_TS_ARCHIVE REMOTE_DEVICE_NAME
ASG_DEVICE_USERS_U5 UNIQUE APPS_TS_ARCHIVE CLIENT_NAME
Columns
Name Datatype Length Mandatory Comments
DEVICE_USER_ID NUMBER
Y Primay key
RESOURCE_ID NUMBER
Y Resource identifier.
MOBILE_APPLICATION_ID NUMBER
Y Mobile Application ID. Foreign key to ASG_APPLICATIONS_B
CLIENT_NUMBER NUMBER
Y Used by sequences
CLIENT_NAME VARCHAR2 (30) Y Mobile client name - Referenced to I-Connect Client ID
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
ORG_ID NUMBER

Organization identifier
DEVICE_TAG VARCHAR2 (30)
Device tag
USER_ID NUMBER
Y User id (FND_USER) of device user
SERVER_ID NUMBER
Y FK to ASG_SYNCH_SERVER
LAST_SYNCH_MODE NUMBER

Last time synchronization mode. 0 for 'Fast Synch', 1 for 'Complete Synch'
ENABLED VARCHAR2 (1)
Enabled status.
UPGRADE NUMBER

Force a complete synch the next time
REMOTE_DEVICE_NAME VARCHAR2 (60)
remote device name
ADDRESS_DEVICE_TYPE VARCHAR2 (30)
'EMAIL', 'PHONE','MAN', 'IP','EXCHANGE'
ADDRESS_DEVICE_NAME VARCHAR2 (240)
Address of remote PC e.g MAN
ONAIR_FLAG VARCHAR2 (1)
Flag to indicate if the device can be contacted.
LAST_SYNC_DATE DATE

last time user synched
LAST_WIRELESS_CONTACT_DATE DATE

last wireless contact with device
RETRY_DATE DATE

next retry date
BYTES_SENT_WIRELESS NUMBER

bytes sent wireless
BYTES_RECEIVED_WIRELESS NUMBER

bytes received wireless
DEVICE_LOCKED VARCHAR2 (1)
Flag to indicate if the device is locked.
ACCESS_CODE VARCHAR2 (240)
email/Phoe number access code in case of flash message
LANGUAGE VARCHAR2 (4)
Preferred language of mobile user
FLASH_MESSAGE_FLAG VARCHAR2 (1)
Flash message flag. 'Y if user is interested in getting flash message
COOKIE VARCHAR2 (240)
Cookie of the wireless client
ORGANIZATION_ID NUMBER

Organization Identifier
NEW_DATA_FLAG VARCHAR2 (1)
New data flag
NEW_DATA_DATE DATE

New data date
SECURITY_GROUP_ID NUMBER

Used in hosted environments

[top of page]

ASG.ASG_DEVICE_USERS does not reference any database object

ASG.ASG_DEVICE_USERS is referenced by following:

APPS
SYNONYM - 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
Comments

sample table

Indexes
Index Type Tablespace Column
ASG_EMP_U1 UNIQUE APPS_TS_ARCHIVE EMPNO
ASG_EMP_N1 NONUNIQUE APPS_TS_ARCHIVE DEPTNO
Columns
Name Datatype Length Mandatory Comments
EMPNO NUMBER
Y Pk of the table.
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
ENAME VARCHAR2 (30)
Employee name.
JOB VARCHAR2 (30)
Job title.
MGR NUMBER

Manager number.
HIREDATE DATE

Hiredate.
SAL NUMBER

Salary.
COMM NUMBER

Comment.
DEPTNO NUMBER
Y Department Identifier.

[top of page]

ASG.ASG_EMP does not reference any database object

ASG.ASG_EMP is referenced by following:

APPS
SYNONYM - 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
Comments

Stores information of error logs.

Indexes
Index Type Tablespace Column
ASG_ERROR_U1 UNIQUE APPS_TS_ARCHIVE MOBILE_ERROR_ID
Columns
Name Datatype Length Mandatory Comments
MOBILE_ERROR_ID NUMBER
Y PK column
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
DEVICE_USER_ID NUMBER

FK to ASG_DEVICE_USERS
TYPE VARCHAR2 (30)
Type. 'E' Error, 'N' Notification
PRIORITY NUMBER

Severity.
STATUS VARCHAR2 (1)
Status.'A' = Active, 'I' = InActive
APPLICATION_ID NUMBER

Associated application
RESPONSIBILITY_ID NUMBER

responsibility id
SYNCHRONOUS_EVENT VARCHAR2 (1)
Flag to indicate if the event is synchronous.
ERROR_DAYS_DEFAULT NUMBER

default error days
ERROR_TIME_DEFAULT VARCHAR2 (6)
default error time
ERROR_DESCRIPTION VARCHAR2 (2048)
error description
SECURITY_GROUP_ID NUMBER

Used in hosted environments

[top of page]

ASG.ASG_ERROR does not reference any database object

ASG.ASG_ERROR is referenced by following:

APPS
SYNONYM - 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
Comments

Stores all flash messages

Indexes
Index Type Tablespace Column
ASG_FLASH_MESSAGES_U1 UNIQUE APPS_TS_ARCHIVE FLASH_ID
Columns
Name Datatype Length Mandatory Comments
FLASH_ID NUMBER
Y Primary Key
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
ACTIVE VARCHAR2 (1)
Active flag.
MESSAGE_LENGTH NUMBER

length of message
CONFIRM_REQUIRED_FLAG VARCHAR2 (1)
Confirmed flag. 'Y send email if recipient did not receive flash message
MESSAGE VARCHAR2 (240)
message text
MESSAGE_TYPE VARCHAR2 (1)
Message type.
SECURITY_GROUP_ID NUMBER

Used in hosted environments

[top of page]

ASG.ASG_FLASH_MESSAGES does not reference any database object

ASG.ASG_FLASH_MESSAGES is referenced by following:

APPS
SYNONYM - 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
Comments

Stores all recepients for all the flash messages

Indexes
Index Type Tablespace Column
ASG_FLASH_RECIPIENTS_U1 UNIQUE APPS_TS_ARCHIVE MOBILE_FLASH_SUBS_ID
ASG_FLASH_RECIPIENTS_U2 UNIQUE APPS_TS_ARCHIVE DEVICE_USER_ID
FLASH_ID
Columns
Name Datatype Length Mandatory Comments
MOBILE_FLASH_SUBS_ID NUMBER
Y Primary Key
FLASH_ID NUMBER
Y FK to ASG_FLASH_MESSAGES
DEVICE_USER_ID NUMBER
Y FK to ASG_DEVICE_USERS
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CONFIRM_FLAG VARCHAR2 (1)
Confirmed flag.
SECURITY_GROUP_ID NUMBER

Used in hosted environments

[top of page]

ASG.ASG_FLASH_RECIPIENTS does not reference any database object

ASG.ASG_FLASH_RECIPIENTS is referenced by following:

APPS
SYNONYM - 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
Comments

Stores information that indicates whether the gateway server can access a service request.

Indexes
Index Type Tablespace Column
ASG_INCIDENT_ACC_U1 UNIQUE APPS_TS_ARCHIVE INCIDENT_ID
SERVER_ID
Columns
Name Datatype Length Mandatory Comments
INCIDENT_ID NUMBER
Y Incident identifier
SERVER_ID NUMBER
Y Gateway server identifier
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
COUNTER NUMBER

Number of mobile client can access the record.
SECURITY_GROUP_ID NUMBER

Used in hosted environments

[top of page]

ASG.ASG_INCIDENT_ACC does not reference any database object

ASG.ASG_INCIDENT_ACC is referenced by following:

APPS
SYNONYM - 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
Comments

Indexes related to a publication item

Columns
Name Datatype Length Mandatory Comments
INDEX_ID NUMBER
Y Primary Key
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
ITEM_ID NUMBER
Y FK to ASG_PUBLICATION_ITEMS
INDEX_NAME VARCHAR2 (60) Y Index name
PMODE VARCHAR2 (1) Y Type of index
COLUMNS VARCHAR2 (4000) Y Columns of index
SECURITY_GROUP_ID NUMBER

Used in hosted environments
RELEASE_VERSION NUMBER

Release Version

[top of page]

ASG.ASG_ITEM_INDEX does not reference any database object

ASG.ASG_ITEM_INDEX is referenced by following:

APPS
SYNONYM - 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
Comments

Stores information that indicates whether the gateway server can access a location.

Indexes
Index Type Tablespace Column
ASG_LOCATION_ACC_U1 UNIQUE APPS_TS_ARCHIVE LOCATION_ID
SERVER_ID
Columns
Name Datatype Length Mandatory Comments
LOCATION_ID NUMBER
Y Location identifier.
SERVER_ID NUMBER
Y Gateway server identifier.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
COUNTER NUMBER
Y Number of mobile client can access the record.
SECURITY_GROUP_ID NUMBER

Used in hosted environments

[top of page]

ASG.ASG_LOCATION_ACC does not reference any database object

ASG.ASG_LOCATION_ACC is referenced by following:

APPS
SYNONYM - 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
Comments

Defines relationship between publication and items

Indexes
Index Type Tablespace Column
ASG_MAP_PUB_ITEMS_U1 UNIQUE APPS_TS_ARCHIVE MAP_ID
ASG_MAP_PUB_ITEMS_U2 UNIQUE APPS_TS_ARCHIVE PUBLICATION_ID
ITEM_ID
Columns
Name Datatype Length Mandatory Comments
MAP_ID NUMBER
Y Primary Key
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
PUBLICATION_ID NUMBER
Y FK to ASG_PUBLICATIONS
ITEM_ID NUMBER
Y FK to ASG_PUBLICATION_ITEMS
COLUMNS VARCHAR2 (240)
New names for columns
DISABLED_DML VARCHAR2 (30)
Updateable/Readonly
CONFLICT_RULE VARCHAR2 (1) Y 'S' if server wins in a conflict
RESTRICATING_PREDICATE VARCHAR2 (2000)
High priority query
TABLE_WEIGHT VARCHAR2 (30)
order of refresh
SECURITY_GROUP_ID NUMBER

Used in hosted environments
RELEASE_VERSION NUMBER

Release Version

[top of page]

ASG.ASG_MAP_PUB_ITEMS does not reference any database object

ASG.ASG_MAP_PUB_ITEMS is referenced by following:

APPS
SYNONYM - 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
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
Index Type Tablespace Column
ASG_MDG_INDEXES_U1 UNIQUE APPS_TS_ARCHIVE MDG_INDEX_ID
ASG_MDG_INDEXES_N1 NONUNIQUE APPS_TS_ARCHIVE MDG_SNAPSHOT_ID
Columns
Name Datatype Length Mandatory Comments
MDG_INDEX_ID NUMBER
Y
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
MDG_SNAPSHOT_ID NUMBER
Y
NAME VARCHAR2 (30) Y
INDEX_TYPE VARCHAR2 (9)
UNIQUENESS VARCHAR2 (9)
INDEX_COLUMNS VARCHAR2 (1024) Y
STATUS VARCHAR2 (1)
SECURITY_GROUP_ID NUMBER

RELEASE_VERSION NUMBER

[top of page]

ASG.ASG_MDG_INDEXES does not reference any database object

ASG.ASG_MDG_INDEXES is referenced by following:

APPS
SYNONYM - 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
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
Index Type Tablespace Column
ASG_MDG_SNAPSHOTS_U1 UNIQUE APPS_TS_ARCHIVE MDG_SNAPSHOT_ID
ASG_MDG_SNAPSHOTS_N1 NONUNIQUE APPS_TS_ARCHIVE CATEGORY_ID
Columns
Name Datatype Length Mandatory Comments
MDG_SNAPSHOT_ID NUMBER
Y
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
OWNER VARCHAR2 (30) Y
NAME VARCHAR2 (30) Y
REFRESH_METHOD VARCHAR2 (1) Y
TYPE VARCHAR2 (30) Y
REFRESH_GROUP VARCHAR2 (30)
UPDATABLE VARCHAR2 (1) Y
PRIMARY_KEY VARCHAR2 (1024)
CATEGORY_ID NUMBER

QUERY1 VARCHAR2 (4000) Y
QUERY2 VARCHAR2 (4000)
STATUS VARCHAR2 (1)
LANGUAGE_CLAUSE VARCHAR2 (240)
SECURITY_GROUP_ID NUMBER

RELEASE_VERSION NUMBER

APPLICATION_TYPE VARCHAR2 (30)
PUBLICATION_ID NUMBER

Publication identifier
BASE_TABLE VARCHAR2 (30)
BASE_PUB_ID NUMBER

[top of page]

ASG.ASG_MDG_SNAPSHOTS does not reference any database object

ASG.ASG_MDG_SNAPSHOTS is referenced by following:

APPS
SYNONYM - ASG_MDG_SNAPSHOTS

[top of page]

Table: ASG_MOBILE_ACCESSES

Description:
Primary Key: ASG_MOBILE_ACCESSES_PK
  1. MOBILE_ACCESS_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
Index Type Tablespace Column
ASG_MOBILE_ACCESSES_U1 UNIQUE APPS_TS_ARCHIVE MOBILE_ACCESS_ID
ASG_MOBILE_ACCESSES_U2 UNIQUE APPS_TS_ARCHIVE MASTER_TABLE_NAME
MASTER_TABLE_PK_VALUE
SERVER_ID
Columns
Name Datatype Length Mandatory Comments
MOBILE_ACCESS_ID NUMBER
Y
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
MASTER_TABLE_NAME VARCHAR2 (30) Y
MASTER_TABLE_PK_VALUE NUMBER
Y
SERVER_ID NUMBER
Y
COUNTER NUMBER
Y

[top of page]

ASG.ASG_MOBILE_ACCESSES does not reference any database object

ASG.ASG_MOBILE_ACCESSES is referenced by following:

APPS
SYNONYM - 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
Comments

Parent hints for Publication items

Indexes
Index Type Tablespace Column
ASG_PARENT_HINT_U1 UNIQUE APPS_TS_ARCHIVE PARENT_HINT_ID
Columns
Name Datatype Length Mandatory Comments
PARENT_HINT_ID NUMBER
Y PK for table
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
ITEM_ID NUMBER
Y FK to ASG_PUBLICATION_ITEMS
OWNER_D VARCHAR2 (60) Y owner of base table
STORE_D VARCHAR2 (60) Y Base table
SECURITY_GROUP_ID NUMBER

Used in hosted environments
RELEASE_VERSION NUMBER

Release version

[top of page]

ASG.ASG_PARENT_HINT does not reference any database object

ASG.ASG_PARENT_HINT is referenced by following:

APPS
SYNONYM - 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
Comments

Stores information that indicates whether the gateway server can access a party.

Indexes
Index Type Tablespace Column
ASG_PARTY_ACC_U1 UNIQUE APPS_TS_ARCHIVE PARTY_ID
SERVER_ID
Columns
Name Datatype Length Mandatory Comments
PARTY_ID NUMBER
Y Party identifier.
SERVER_ID NUMBER
Y Gateway server identifier.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
COUNTER NUMBER

Number of mobile client can access the record.
SECURITY_GROUP_ID NUMBER

Used in hosted environments

[top of page]

ASG.ASG_PARTY_ACC does not reference any database object

ASG.ASG_PARTY_ACC is referenced by following:

APPS
SYNONYM - 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
Comments

Stores information that indicates whether the gateway server can access a party site.

Indexes
Index Type Tablespace Column
ASG_PARTY_SITE_ACC_U1 UNIQUE APPS_TS_ARCHIVE PARTY_SITE_ID
SERVER_ID
Columns
Name Datatype Length Mandatory Comments
PARTY_SITE_ID NUMBER
Y Party site identifier.
SERVER_ID NUMBER
Y Gateway server identifier.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
COUNTER NUMBER

Number of mobile client can access the record.
SECURITY_GROUP_ID NUMBER

Used in hosted environments

[top of page]

ASG.ASG_PARTY_SITE_ACC does not reference any database object

ASG.ASG_PARTY_SITE_ACC is referenced by following:

APPS
SYNONYM - 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
Comments

Stores the Primary Key hints for publication items

Indexes
Index Type Tablespace Column
ASG_PRIMARY_KEY_HINT_U1 UNIQUE APPS_TS_ARCHIVE PRIMARY_HINT_ID
ASG_PRIMARY_KEY_HINT_U2 UNIQUE APPS_TS_ARCHIVE ITEM_ID
KEY_COLUMN
Columns
Name Datatype Length Mandatory Comments
PRIMARY_HINT_ID NUMBER
Y Primary Key
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
ITEM_ID NUMBER
Y FK to ASG_PUBLICATION_ITEMS
KEY_COLUMN VARCHAR2 (60) Y Primary Key Column in publication item
B_OWNER VARCHAR2 (60) Y owner of base table
B_STORE VARCHAR2 (60) Y Base table
B_COLUMN VARCHAR2 (60) Y Base PK column
SECURITY_GROUP_ID NUMBER

Used in hosted environments
RELEASE_VERSION NUMBER

Release Version

[top of page]

ASG.ASG_PRIMARY_KEY_HINT does not reference any database object

ASG.ASG_PRIMARY_KEY_HINT is referenced by following:

APPS
SYNONYM - 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
Comments

Stores all I-Connect publication names

Indexes
Index Type Tablespace Column
ASG_PUBLICATIONS_U1 UNIQUE APPS_TS_ARCHIVE PUBLICATION_ID
ASG_PUBLICATIONS_U2 UNIQUE APPS_TS_ARCHIVE APPLICATION_ID
Columns
Name Datatype Length Mandatory Comments
PUBLICATION_ID NUMBER
Y Publication identifier.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
NAME VARCHAR2 (60) Y Publication Name
CLIENT_STORAGE_TYPE NUMBER (30) Y Integer specifying storage type
CLIENT_NAME_TEMPLATE VARCHAR2 (30) Y Olite Database name
ENFORCE_RI VARCHAR2 (1)
Reserved for duture use
STATUS VARCHAR2 (1)
Status flag. 'Y if publication item is valid
SECURITY_GROUP_ID NUMBER

Used in hosted environments
RELEASE_VERSION NUMBER

Release Version
COMPATIBLE_VERSION NUMBER

Compatiable version.
TXN_HANDLER_PKG VARCHAR2 (30)
Transaction hander package.
CORE_FLAG VARCHAR2 (1)
The flag indicates whether including the Pub as a part of Core MDG.
INSTANTIATION_FLAG VARCHAR2 (1)
The flag indicates whether create the publication.
SHARED_PUB_ID NUMBER

The pub id which is shared by this record.
APPLICATION_ID NUMBER

Application Identifier

[top of page]

ASG.ASG_PUBLICATIONS does not reference any database object

ASG.ASG_PUBLICATIONS is referenced by following:

APPS
SYNONYM - 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
Comments

Stores all I-Connect publication items.

Indexes
Index Type Tablespace Column
ASG_PUBLICATION_ITEMS_U1 UNIQUE APPS_TS_ARCHIVE ITEM_ID
Columns
Name Datatype Length Mandatory Comments
ITEM_ID NUMBER
Y Primary Key
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
NAME VARCHAR2 (60) Y Publication Item Name
OWNER VARCHAR2 (60)
Schema of publication item
BASE_OBJECT VARCHAR2 (60) Y Base object of publication item
BASE_OWNER VARCHAR2 (60) Y owner schema of base object
REFRESH_METHOD VARCHAR2 (1) Y Refresh Method.
SELECT1_TEXT VARCHAR2 (2048) Y Publication query
SELECT2_TEXT VARCHAR2 (2048)
Publication query
CBK_OWNER VARCHAR2 (60)
Call back schema
CBK_NAME VARCHAR2 (60)
Call back package name
STATUS VARCHAR2 (1)
Status flag. 'Y if publication item is valid
SECURITY_GROUP_ID NUMBER

Used in hosted environments
RELEASE_VERSION NUMBER

Release Version
WRAPPER_PREFIX VARCHAR2 (30)
Publication item call back wrapper package prefix.
WRAPPER_NAME VARCHAR2 (60)
Publication item call back wrapper package name.
SNAPSHOT_ID NUMBER

The corresponding snapshot id for the snapshot based publicaiton items.

[top of page]

ASG.ASG_PUBLICATION_ITEMS does not reference any database object

ASG.ASG_PUBLICATION_ITEMS is referenced by following:

APPS
SYNONYM - 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
Comments

Sequences on Mobile Device

Indexes
Index Type Tablespace Column
ASG_SEQUENCES_U1 UNIQUE APPS_TS_ARCHIVE SEQUENCE_ID
Columns
Name Datatype Length Mandatory Comments
SEQUENCE_ID NUMBER
Y Primary Key
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
SEQUENCE_NAME VARCHAR2 (60) Y Sequence name
PUBLICATION_ID NUMBER
Y FK to ASG_PUBLICATIONS
SECURITY_GROUP_ID NUMBER

Used in hosted environments
RELEASE_VERSION NUMBER

Release Version
B_SCHEMA VARCHAR2 (30) Y Base Schema
B_TABLE VARCHAR2 (30) Y Base Table
B_COLUMN VARCHAR2 (30) Y Base Column
MOBILE_VALUE VARCHAR2 (30)
Strarting sequence value

[top of page]

ASG.ASG_SEQUENCES does not reference any database object

ASG.ASG_SEQUENCES is referenced by following:

APPS
SYNONYM - 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
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
Name Datatype Length Mandatory Comments
SERVER_PUBS_ID NUMBER
Y
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
SERVER_ID NUMBER
Y
PUBLICATION_ID NUMBER
Y
SECURITY_GROUP_ID NUMBER

RELEASE_VERSION NUMBER

COMPATIBLE_VERSION NUMBER

STATUS VARCHAR2 (1)
APACHE_URL VARCHAR2 (4000)

[top of page]

ASG.ASG_SERVER_PUBS does not reference any database object

ASG.ASG_SERVER_PUBS is referenced by following:

APPS
SYNONYM - 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
Comments

Stores all users(resources) using a particular middle-tier

Indexes
Index Type Tablespace Column
ASG_SERVER_RESOURCES_U1 UNIQUE APPS_TS_ARCHIVE RESOURCE_ID
SERVER_ID
Columns
Name Datatype Length Mandatory Comments
SERVER_ID NUMBER
Y Primary Key
RESOURCE_ID NUMBER
Y Primary Key
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
SECURITY_GROUP_ID NUMBER

Used in hosted environments

[top of page]

ASG.ASG_SERVER_RESOURCES does not reference any database object

ASG.ASG_SERVER_RESOURCES is referenced by following:

APPS
SYNONYM - 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
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
Name Datatype Length Mandatory Comments
SNAPSHOT_LOG_ID NUMBER
Y
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
TABLE_NAME VARCHAR2 (50) Y
OWNER VARCHAR2 (10) Y
PRIMARY_KEY_FLAG VARCHAR2 (5) Y
PRIMARY_KEY_COLUMNS VARCHAR2 (4000)
FILTER_KEY_COLUMNS VARCHAR2 (240)
CREATE_PRIMARY_FLAG VARCHAR2 (5)
PCT_FREE NUMBER

PCT_USED NUMBER

REFRESH_GROUP VARCHAR2 (30)
APPLICATION_TYPE VARCHAR2 (30)
STATUS VARCHAR2 (5)
SECURITY_GROUP_ID NUMBER

RELEASE_VERSION NUMBER

PUBLICATION_ID NUMBER

BASE_PUB_ID NUMBER

[top of page]

ASG.ASG_SNAPSHOT_LOGS does not reference any database object

ASG.ASG_SNAPSHOT_LOGS is referenced by following:

APPS
SYNONYM - 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
Comments

subscription parametres

Indexes
Index Type Tablespace Column
ASG_SUBSCRIPTION_PARAMS_U1 UNIQUE APPS_TS_ARCHIVE SUBSCRIPTION_PARAMS_ID
Columns
Name Datatype Length Mandatory Comments
SUBSCRIPTION_PARAMS_ID NUMBER
Y Primary Key
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
PARAM_NAME VARCHAR2 (60) Y Name of Parameter
PUBLICATION_ID NUMBER
Y FK to ASG_PUBLICATIONS
SECURITY_GROUP_ID NUMBER

Used in hosted environments
RELEASE_VERSION NUMBER

Release Version

[top of page]

ASG.ASG_SUBSCRIPTION_PARAMS does not reference any database object

ASG.ASG_SUBSCRIPTION_PARAMS is referenced by following:

APPS
SYNONYM - 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
Comments

Informating about all the Mobile Device Gateway

Indexes
Index Type Tablespace Column
ASG_SYNCH_SERVER_U1 UNIQUE APPS_TS_ARCHIVE SERVER_ID
Columns
Name Datatype Length Mandatory Comments
SERVER_ID NUMBER
Y Gateway server identifier.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
SNAP_DATABASE VARCHAR2 (240) Y Snapshot database name
NETWORK_PROTOCOL VARCHAR2 (60)
Network protocol
HOST_NAME VARCHAR2 (60)
Machine host name or IP address.
PORT_NUMBER VARCHAR2 (60)
Port number
ORACLE_SID VARCHAR2 (60)
Oracle SID.
WIRELESS_FLAG VARCHAR2 (1)
Flag to indicate if the server supports wireless synchronization.
VERSION_ID VARCHAR2 (30)
Version ID for this Gateway Server
CONS_PASSWORD VARCHAR2 (60)
CONSOLIDATOR password of the gateway server
ADMIN_PASSWORD VARCHAR2 (60)
ADMIN password of the gateway server.
ENABLED VARCHAR2 (1)
Flag to indicates whether the gateway server is built-up.
DESCRIPTION VARCHAR2 (2000)
Description of the gateway server.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
LANGUAGE VARCHAR2 (4)
Language used.
MOBILE_SERVER_URL VARCHAR2 (2000)
Mobile Server URL.

[top of page]

ASG.ASG_SYNCH_SERVER does not reference any database object

ASG.ASG_SYNCH_SERVER is referenced by following:

APPS
SYNONYM - 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
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
Index Type Tablespace Column
ASG_SYSTEM_LOGS_U1 UNIQUE APPS_TS_ARCHIVE SYSTEM_LOG_ID
Columns
Name Datatype Length Mandatory Comments
SYSTEM_LOG_ID NUMBER (10) Y
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
ENTITY_ID NUMBER (10) Y
SYSTEM_LOG_TYPE VARCHAR2 (10) Y
SECURITY_GROUP_ID NUMBER (10)
DESCRIPTION VARCHAR2 (4000)
STATUS VARCHAR2 (1)

[top of page]

ASG.ASG_SYSTEM_LOGS does not reference any database object

ASG.ASG_SYSTEM_LOGS is referenced by following:

APPS
SYNONYM - 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
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
Index Type Tablespace Column
ASG_SYSTEM_LOG_TEXT_U1 UNIQUE APPS_TS_ARCHIVE SYSTEM_LOG_ID
LINE_NUMBER
Columns
Name Datatype Length Mandatory Comments
SYSTEM_LOG_ID NUMBER
Y
LINE_NUMBER NUMBER (10) Y
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (10) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (10) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
TEXT VARCHAR2 (240)
SECURITY_GROUP_ID NUMBER (10)

[top of page]

ASG.ASG_SYSTEM_LOG_TEXT does not reference any database object

ASG.ASG_SYSTEM_LOG_TEXT is referenced by following:

APPS
SYNONYM - ASG_SYSTEM_LOG_TEXT

[top of page]

Table: ASG_SYSTEM_PKGS

Description:
Primary Key: ASG_SYSTEM_PKGS_PK
  1. SYSTEM_PKG_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.

Columns
Name Datatype Length Mandatory Comments
SYSTEM_PKG_ID NUMBER (10) Y
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (10) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (10) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
NAME VARCHAR2 (60) Y
OWNER VARCHAR2 (60) Y
STORAGE_NAME VARCHAR2 (60) Y
STATUS VARCHAR2 (1)
SECURITY_GROUP_ID NUMBER (10)
RELEASE_VERSION NUMBER (10)

[top of page]

ASG.ASG_SYSTEM_PKGS does not reference any database object

ASG.ASG_SYSTEM_PKGS is referenced by following:

APPS
SYNONYM - ASG_SYSTEM_PKGS

[top of page]

Table: ASG_SYSTEM_QUEUES

Description:
Primary Key: ASG_SYSTEM_QUEUES_PK
  1. SYSTEM_QUEUE_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.

Columns
Name Datatype Length Mandatory Comments
SYSTEM_QUEUE_ID NUMBER (10) Y
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (10) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER (10) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
NAME VARCHAR2 (60) Y
OWNER VARCHAR2 (60) Y
STORAGE_NAME VARCHAR2 (60) Y
STATUS VARCHAR2 (1)
SECURITY_GROUP_ID NUMBER (10)
RELEASE_VERSION NUMBER (10)

[top of page]

ASG.ASG_SYSTEM_QUEUES does not reference any database object

ASG.ASG_SYSTEM_QUEUES is referenced by following:

APPS
SYNONYM - 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
Comments

Stores information that indicates whether the gateway server can access a task.

Indexes
Index Type Tablespace Column
ASG_TASK_ACC_U1 UNIQUE APPS_TS_ARCHIVE TASK_ID
SERVER_ID
Columns
Name Datatype Length Mandatory Comments
TASK_ID NUMBER
Y Task identifier.
SERVER_ID NUMBER
Y Gateway server identifier.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
COUNTER NUMBER

Number of mobile client can access the record.
SECURITY_GROUP_ID NUMBER

Used in hosted environments

[top of page]

ASG.ASG_TASK_ACC does not reference any database object

ASG.ASG_TASK_ACC is referenced by following:

APPS
SYNONYM - 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
Comments

profile values for wireless

Indexes
Index Type Tablespace Column
ASG_WIRELESS_PARAMETERS_U1 UNIQUE APPS_TS_ARCHIVE WIRELESS_PARAMETERS_ID
Columns
Name Datatype Length Mandatory Comments
WIRELESS_PARAMETERS_ID NUMBER
Y PK for table
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
SERVER_ID NUMBER
Y FK to ASG_SYNCH_SERVER
SERVER_REMOTE_FLAG VARCHAR2 (1)
Server/remote flag
SEND_INTERVAL NUMBER

Send Interval between tries
SEND_DELAY NUMBER

Record not ecited during the delay, the mid tier starts sending the record(60 to 300s)
NUM_OF_RETRIES NUMBER

Number of retries.
TIME_BETWEEN_RETRIES NUMBER

time between retries
TIME_TO_ACK NUMBER

time between acknowlegements
OUT_OF_COVERAGE NUMBER

used by device to decide whether to inform the MDG
REPLICATION_INTERVAL NUMBER

interval for replication
TRANSACTION_HISTORY NUMBER

transaction history
SECURITY_GROUP_ID NUMBER

Used in hosted environments

[top of page]

ASG.ASG_WIRELESS_PARAMETERS does not reference any database object

ASG.ASG_WIRELESS_PARAMETERS is referenced by following:

APPS
SYNONYM - ASG_WIRELESS_PARAMETERS

[top of page]

View: ASG_APPLICATION_VL

Comments
View Type

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

MultiLingual view based on ASG_APPLIATIONS_B table.

Columns
Name Datatype Length Mandatory Comments
MOBILE_APPLICATION_ID NUMBER
Y Mobile application identifier. Primary key
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
DEVICE_TYPE VARCHAR2 (30)
Mobile device type such as 'PALM' 'WINCE' LAPTOP'.
APP_VERSION VARCHAR2 (30)
Version of mobile application
STATUS VARCHAR2 (1)
Status flag
FLASH_MESSAGE_LENGTH NUMBER

If the application supports flash messages, the max length of messages
APPLICATION_CODE VARCHAR2 (60) Y application code
SYNCHRONIZATION_FLAG VARCHAR2 (1)
Synchronization flag. 'Y' if the application supports synchronization
SMS VARCHAR2 (1)
SMS flag. 'Y' if the application supports SMS
EMAIL VARCHAR2 (1)
Email flag. 'Y' if the application supports email
MOBILE_APPLICATION_NAME VARCHAR2 (240)
Name of mobile application in the language specified

[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

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

Mobile user information.

Columns
Name Datatype Length Mandatory Comments
DEVICE_USER_ID NUMBER
Y Mobile user identifier.
CLIENT_NAME VARCHAR2 (30) Y Mobile user name.
MOBILE_APPLICATION_ID NUMBER
Y Mobile user application identifier.
USER_ID NUMBER
Y User identifier.
RESOURCE_ID NUMBER
Y Resource identifier.
SERVER_ID NUMBER
Y Mobile Gateway Server identifier.
SNAP_DATABASE VARCHAR2 (240) Y The middler tier database global name.
RELEASE_VERSION NUMBER

Release version.
COMPATIBLE_VERSION NUMBER

Compatible version.

[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