[Home] [Help] [Dependency Information]
Object Name: | ASG_PUB_ITEM# |
---|---|
Object Type: | VIEW |
Owner: | ASG |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_ID | VARCHAR2 | (30) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
NAME | VARCHAR2 | (30) | Yes | |
PUB_NAME | VARCHAR2 | (30) | Yes | |
PUB_ID | VARCHAR2 | (30) | ||
BASE_OWNER | VARCHAR2 | (30) | ||
BASE_OBJECT_NAME | VARCHAR2 | (240) | ||
PRIMARY_KEY_COLUMN | VARCHAR2 | (2000) | ||
CONFLICT_RULE | VARCHAR2 | (1) | ||
RESTRICTING_PREDICATE | VARCHAR2 | (2000) | ||
HIGH_PRIORITY | VARCHAR2 | (1) | ||
TABLE_WEIGHT | VARCHAR2 | (60) | ||
STATUS | VARCHAR2 | (1) | ||
ENABLED | VARCHAR2 | (1) | ||
LAST_RELEASE_VERSION | NUMBER | |||
CURRENT_RELEASE_VERSION | NUMBER | |||
PARENT_TABLE | VARCHAR2 | (30) | ||
PARENT_OWNER | VARCHAR2 | (30) | ||
WHERE_CLAUSE | VARCHAR2 | (2000) | ||
UPDATABLE | VARCHAR2 | (1) | ||
DISABLED_DML | VARCHAR2 | (30) | ||
SECURITY_GROUP_ID | NUMBER | |||
QUERY1 | VARCHAR2 | (2000) | ||
QUERY2 | VARCHAR2 | (2000) | ||
ONLINE_QUERY | VARCHAR2 | (1) | ||
INQ_OWNER | VARCHAR2 | (30) | ||
INQ_NAME | VARCHAR2 | (30) | ||
FORCE_COMPLETE_REFRESH | VARCHAR2 | (1) | ||
CALLOUT_PROCEDURE | VARCHAR2 | (100) | ||
ACCESS_OWNER | VARCHAR2 | (30) | ||
ACCESS_NAME | VARCHAR2 | (30) | ||
ACC_LAST_RELEASE_VERSION | NUMBER | |||
ACC_CURRENT_RELEASE_VERSION | NUMBER | |||
APPLY_SYNCHRONOUS | VARCHAR2 | (1) | ||
CALLOUT_PER_USER | VARCHAR2 | (1) | ||
COMPLETE_REFRESH_PUB_ITEMS | VARCHAR2 | (2000) | ||
DETECT_CONFLICT | VARCHAR2 | (1) | ||
CONFLICT_CALLOUT | VARCHAR2 | (100) | ||
FORCE_RELEASE_VERSION | NUMBER | |||
ALTER_RELEASE_VERSION | NUMBER | |||
ACCESS_TABLE_PREDICATE_LIST | VARCHAR2 | (150) | ||
QUERY_ACCESS_TABLE | VARCHAR2 | (1) | ||
ENABLE_DOWNLOAD_EVENTS | VARCHAR2 | (1) | ||
HTML5_OFFLINE | VARCHAR2 | (1) | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
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
, HTML5_OFFLINE
, ZD_EDITION_NAME
FROM ASG.ASG_PUB_ITEM#;
|
|
|