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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: ASG.ASG_PUB_ITEM

Object Details

Object Name:	ASG_PUB_ITEM
Object Type:	TABLE
Owner:	ASG
Subobject Name:
Status:	VALID

Stores the publication items.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ASG_PUB_ITEM_U1	NORMAL	UNIQUE	APPS_TS_SEED	ITEM_ID ZD_EDITION_NAME
ASG_PUB_ITEM_U2	NORMAL	UNIQUE	APPS_TS_SEED	NAME ZD_EDITION_NAME
ASG_PUB_ITEM_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	PUB_NAME
ASG_PUB_ITEM_N3	NORMAL	NONUNIQUE	APPS_TS_SEED	HTML5_OFFLINE

Columns

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
HTML5_OFFLINE	VARCHAR2	(1)
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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;

Dependencies

[top of page]

ASG.ASG_PUB_ITEM does not reference any database object

ASG.ASG_PUB_ITEM is referenced by following:

ASG: ASG_PUB_ITEM#