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: MSC.MSC_INT_PUBLISH_DATA

Object Details

Object Name:	MSC_INT_PUBLISH_DATA
Object Type:	TABLE
Owner:	MSC
Subobject Name:
Status:	VALID

PS/SNO Integration table that stores the published data as BLOB objects in this table when the profile "MSC: PS/SNO Use DB for Integration" is set to YES

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000445851C00005$$	LOB	UNIQUE	APPS_TS_TX_DATA
MSC_INT_PUBLISH_DATA_PK	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	API_ID REQ_ID PLAN_ID PACKAGE_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
API_ID	VARCHAR2	(30)	Yes	API ID of the packages
REQ_ID	VARCHAR2	(50)	Yes	Request ID of the publish process
PLAN_ID	VARCHAR2	(50)	Yes	Plan ID of the published PS/SNO plan
PACKAGE_NAME	VARCHAR2	(100)	Yes	Name of the package that together makes the XML files
XMLDATA	BLOB	(4000)		The Published XML files from PS/SNO will be stored as BLOB objects in this column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT API_ID
,      REQ_ID
,      PLAN_ID
,      PACKAGE_NAME
,      XMLDATA
FROM MSC.MSC_INT_PUBLISH_DATA;

Dependencies

[top of page]

MSC.MSC_INT_PUBLISH_DATA does not reference any database object

MSC.MSC_INT_PUBLISH_DATA is referenced by following:

MSC: MSC_INT_PUBLISH_DATA#