eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: ASG.ASG_PUB_ITEM#

Source

View Text - Preformatted


select ITEM_ID ITEM_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, NAME NAME, PUB_NAME PUB_NAME, PUB_ID PUB_ID, BASE_OWNER BASE_OWNER, BASE_OBJECT_NAME BASE_OBJECT_NAME, PRIMARY_KEY_COLUMN PRIMARY_KEY_COLUMN, CONFLICT_RULE CONFLICT_RULE, RESTRICTING_PREDICATE RESTRICTING_PREDICATE, HIGH_PRIORITY HIGH_PRIORITY, TABLE_WEIGHT TABLE_WEIGHT, STATUS STATUS, ENABLED ENABLED, LAST_RELEASE_VERSION LAST_RELEASE_VERSION, CURRENT_RELEASE_VERSION CURRENT_RELEASE_VERSION, PARENT_TABLE PARENT_TABLE, PARENT_OWNER PARENT_OWNER, WHERE_CLAUSE WHERE_CLAUSE, UPDATABLE UPDATABLE, DISABLED_DML DISABLED_DML, SECURITY_GROUP_ID SECURITY_GROUP_ID, QUERY1 QUERY1, QUERY2 QUERY2, ONLINE_QUERY ONLINE_QUERY, INQ_OWNER INQ_OWNER, INQ_NAME INQ_NAME, FORCE_COMPLETE_REFRESH FORCE_COMPLETE_REFRESH, CALLOUT_PROCEDURE CALLOUT_PROCEDURE, ACCESS_OWNER ACCESS_OWNER, ACCESS_NAME ACCESS_NAME, ACC_LAST_RELEASE_VERSION ACC_LAST_RELEASE_VERSION, ACC_CURRENT_RELEASE_VERSION ACC_CURRENT_RELEASE_VERSION, APPLY_SYNCHRONOUS APPLY_SYNCHRONOUS, CALLOUT_PER_USER CALLOUT_PER_USER, COMPLETE_REFRESH_PUB_ITEMS COMPLETE_REFRESH_PUB_ITEMS, DETECT_CONFLICT DETECT_CONFLICT, CONFLICT_CALLOUT CONFLICT_CALLOUT, FORCE_RELEASE_VERSION FORCE_RELEASE_VERSION, ALTER_RELEASE_VERSION ALTER_RELEASE_VERSION, ACCESS_TABLE_PREDICATE_LIST ACCESS_TABLE_PREDICATE_LIST, QUERY_ACCESS_TABLE QUERY_ACCESS_TABLE, ENABLE_DOWNLOAD_EVENTS ENABLE_DOWNLOAD_EVENTS, HTML5_OFFLINE HTML5_OFFLINE, ZD_EDITION_NAME ZD_EDITION_NAME from "ASG"."ASG_PUB_ITEM"

View Text - HTML Formatted

SELECT ITEM_ID ITEM_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, NAME NAME
, PUB_NAME PUB_NAME
, PUB_ID PUB_ID
, BASE_OWNER BASE_OWNER
, BASE_OBJECT_NAME BASE_OBJECT_NAME
, PRIMARY_KEY_COLUMN PRIMARY_KEY_COLUMN
, CONFLICT_RULE CONFLICT_RULE
, RESTRICTING_PREDICATE RESTRICTING_PREDICATE
, HIGH_PRIORITY HIGH_PRIORITY
, TABLE_WEIGHT TABLE_WEIGHT
, STATUS STATUS
, ENABLED ENABLED
, LAST_RELEASE_VERSION LAST_RELEASE_VERSION
, CURRENT_RELEASE_VERSION CURRENT_RELEASE_VERSION
, PARENT_TABLE PARENT_TABLE
, PARENT_OWNER PARENT_OWNER
, WHERE_CLAUSE WHERE_CLAUSE
, UPDATABLE UPDATABLE
, DISABLED_DML DISABLED_DML
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, QUERY1 QUERY1
, QUERY2 QUERY2
, ONLINE_QUERY ONLINE_QUERY
, INQ_OWNER INQ_OWNER
, INQ_NAME INQ_NAME
, FORCE_COMPLETE_REFRESH FORCE_COMPLETE_REFRESH
, CALLOUT_PROCEDURE CALLOUT_PROCEDURE
, ACCESS_OWNER ACCESS_OWNER
, ACCESS_NAME ACCESS_NAME
, ACC_LAST_RELEASE_VERSION ACC_LAST_RELEASE_VERSION
, ACC_CURRENT_RELEASE_VERSION ACC_CURRENT_RELEASE_VERSION
, APPLY_SYNCHRONOUS APPLY_SYNCHRONOUS
, CALLOUT_PER_USER CALLOUT_PER_USER
, COMPLETE_REFRESH_PUB_ITEMS COMPLETE_REFRESH_PUB_ITEMS
, DETECT_CONFLICT DETECT_CONFLICT
, CONFLICT_CALLOUT CONFLICT_CALLOUT
, FORCE_RELEASE_VERSION FORCE_RELEASE_VERSION
, ALTER_RELEASE_VERSION ALTER_RELEASE_VERSION
, ACCESS_TABLE_PREDICATE_LIST ACCESS_TABLE_PREDICATE_LIST
, QUERY_ACCESS_TABLE QUERY_ACCESS_TABLE
, ENABLE_DOWNLOAD_EVENTS ENABLE_DOWNLOAD_EVENTS
, HTML5_OFFLINE HTML5_OFFLINE
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "ASG"."ASG_PUB_ITEM"