[Home] [Help] [Dependency Information]
Object Name: | ASG_PUB_ITEM |
---|---|
Object Type: | TABLE |
Owner: | ASG |
Subobject Name: | |
Status: | VALID |
Stores the publication items.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ASG_PUB_ITEM_U1 | NORMAL | UNIQUE | APPS_TS_SEED | ITEM_ID |
ASG_PUB_ITEM_U2 | NORMAL | UNIQUE | APPS_TS_SEED | NAME |
ASG_PUB_ITEM_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED | PUB_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_ID | VARCHAR2 | (30) | Yes | Publication item id. |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
NAME | VARCHAR2 | (30) | Yes | Item name. |
PUB_NAME | VARCHAR2 | (30) | Yes | Publication name. |
PUB_ID | VARCHAR2 | (30) | Same as the Pub_name. | |
BASE_OWNER | VARCHAR2 | (30) | Base owner. | |
BASE_OBJECT_NAME | VARCHAR2 | (240) | Base object name. | |
PRIMARY_KEY_COLUMN | VARCHAR2 | (2000) | Primary key columns. | |
CONFLICT_RULE | VARCHAR2 | (1) | Conflict rules. | |
RESTRICTING_PREDICATE | VARCHAR2 | (2000) | Restricting predicate. | |
HIGH_PRIORITY | VARCHAR2 | (1) | High priority flag. | |
TABLE_WEIGHT | VARCHAR2 | (60) | Table weight. | |
STATUS | VARCHAR2 | (1) | Status flag. | |
ENABLED | VARCHAR2 | (1) | Enabled flag. | |
LAST_RELEASE_VERSION | NUMBER | Last release version. | ||
CURRENT_RELEASE_VERSION | NUMBER | Current release version. | ||
PARENT_TABLE | VARCHAR2 | (30) | Parent table. | |
PARENT_OWNER | VARCHAR2 | (30) | Parent owner. | |
WHERE_CLAUSE | VARCHAR2 | (2000) | Where clause. | |
UPDATABLE | VARCHAR2 | (1) | Updateable flag. | |
DISABLED_DML | VARCHAR2 | (30) | Disabled DML flag. | |
SECURITY_GROUP_ID | NUMBER | Security group id. | ||
QUERY1 | VARCHAR2 | (2000) | Query1. | |
QUERY2 | VARCHAR2 | (2000) | Query 2. | |
ONLINE_QUERY | VARCHAR2 | (1) | Online query flag. | |
INQ_OWNER | VARCHAR2 | (30) | INQ owner. | |
INQ_NAME | VARCHAR2 | (30) | INQ name. | |
FORCE_COMPLETE_REFRESH | VARCHAR2 | (1) | Force complete refresh. | |
CALLOUT_PROCEDURE | VARCHAR2 | (100) | Callout procedure name. | |
ACCESS_OWNER | VARCHAR2 | (30) | Acc owner. | |
ACCESS_NAME | VARCHAR2 | (30) | Acc name. | |
ACC_LAST_RELEASE_VERSION | NUMBER | Access table last release version. | ||
ACC_CURRENT_RELEASE_VERSION | NUMBER | Access table current release version. | ||
APPLY_SYNCHRONOUS | VARCHAR2 | (1) | Apply synchronous. | |
CALLOUT_PER_USER | VARCHAR2 | (1) | Callout per user. | |
COMPLETE_REFRESH_PUB_ITEMS | VARCHAR2 | (2000) | Complete refresh pub item. | |
DETECT_CONFLICT | VARCHAR2 | (1) | Detect conflict. | |
CONFLICT_CALLOUT | VARCHAR2 | (100) | Conflict callout. | |
FORCE_RELEASE_VERSION | NUMBER | Force release version | ||
ALTER_RELEASE_VERSION | NUMBER | Alter release version | ||
ACCESS_TABLE_PREDICATE_LIST | VARCHAR2 | (150) | Comma separated list of columns of access table | |
QUERY_ACCESS_TABLE | VARCHAR2 | (1) | Indicates whether access table can be queried directly | |
ENABLE_DOWNLOAD_EVENTS | VARCHAR2 | (1) | Enable the download events for pub_itm |
Cut, paste (and edit) the following text to query this object:
SELECT ITEM_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, NAME
, PUB_NAME
, PUB_ID
, BASE_OWNER
, BASE_OBJECT_NAME
, PRIMARY_KEY_COLUMN
, CONFLICT_RULE
, RESTRICTING_PREDICATE
, HIGH_PRIORITY
, TABLE_WEIGHT
, STATUS
, ENABLED
, LAST_RELEASE_VERSION
, CURRENT_RELEASE_VERSION
, PARENT_TABLE
, PARENT_OWNER
, WHERE_CLAUSE
, UPDATABLE
, DISABLED_DML
, SECURITY_GROUP_ID
, QUERY1
, QUERY2
, ONLINE_QUERY
, INQ_OWNER
, INQ_NAME
, FORCE_COMPLETE_REFRESH
, CALLOUT_PROCEDURE
, ACCESS_OWNER
, ACCESS_NAME
, ACC_LAST_RELEASE_VERSION
, ACC_CURRENT_RELEASE_VERSION
, APPLY_SYNCHRONOUS
, CALLOUT_PER_USER
, COMPLETE_REFRESH_PUB_ITEMS
, DETECT_CONFLICT
, CONFLICT_CALLOUT
, FORCE_RELEASE_VERSION
, ALTER_RELEASE_VERSION
, ACCESS_TABLE_PREDICATE_LIST
, QUERY_ACCESS_TABLE
, ENABLE_DOWNLOAD_EVENTS
FROM ASG.ASG_PUB_ITEM;
ASG.ASG_PUB_ITEM does not reference any database object
ASG.ASG_PUB_ITEM is referenced by following:
|
|
|