[Home] [Help] [Dependency Information]
Object Name: | AZ_CONTEXTS_SQL |
---|---|
Object Type: | TABLE |
Owner: | AZ |
FND Design Data: | AZ.AZ_CONTEXTS_SQL |
Subobject Name: | |
Status: | VALID |
Used for storing sql statements that are dynamically executed. The sql statements are used for populating, validating, deleting contexts
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AZ_CONTEXTS_SQL_U1 | NORMAL | UNIQUE | APPS_TS_ARCHIVE |
CONTEXT
PURPOSE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONTEXT | VARCHAR2 | (10) | Yes | Context type designated by a code like 'OPMCOM', 'SOB' |
SQL_STATEMENT | VARCHAR2 | (500) | The sql statement which is dynamically executed | |
PURPOSE | VARCHAR2 | (20) | Yes | A brief description of the sql statement |
DESCRIPTION | VARCHAR2 | (500) | A brief description of the sql statement |
Cut, paste (and edit) the following text to query this object:
SELECT CONTEXT
, SQL_STATEMENT
, PURPOSE
, DESCRIPTION
FROM AZ.AZ_CONTEXTS_SQL;
AZ.AZ_CONTEXTS_SQL does not reference any database object
AZ.AZ_CONTEXTS_SQL is referenced by following:
|
|
|