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_ST_RESOURCE_SETUPS

Object Details

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

Staging table for storing setups associated with a resource

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
SR_INSTANCE_ID	NUMBER		Collection Instance Id
RESOURCE_ID	NUMBER		Resource on which set up is performed
ORGANIZATION_ID	NUMBER		Organization Id
SETUP_ID	NUMBER		Setup Id
SETUP_CODE	VARCHAR2	(100)	Setup code
SETUP_DESCRIPTION	VARCHAR2	(240)	Set Up description
ORGANIZATION_CODE	VARCHAR2	(7)	Organization code.For Legacy
RESOURCE_CODE	VARCHAR2	(10)	Resource code. For Legacy
DELETED_FLAG	NUMBER		Mark for delete
REFRESH_ID	NUMBER		Refresh Id
COMPANY_ID	NUMBER		Company Id
COMPANY_NAME	VARCHAR2	(255)	Company Name
SR_INSTANCE_CODE	VARCHAR2	(3)	Source Instance code
MESSAGE_ID	NUMBER		Message id. For internal use.
PROCESS_FLAG	NUMBER		For internal use For Legacy collection
ERROR_TEXT	VARCHAR2	(2000)	For internal use For Legacy collection
ST_TRANSACTION_ID	NUMBER		For internal use For Legacy collection
BATCH_ID	NUMBER		For internal use For Legacy collection
DATA_SOURCE_TYPE	VARCHAR2	(15)	For marking record for delete
LAST_UPDATE_DATE	DATE		For internal use For Legacy collection
LAST_UPDATED_BY	NUMBER		Last update by
CREATION_DATE	DATE		Creation Date
CREATED_BY	NUMBER		Created By
LAST_UPDATE_LOGIN	NUMBER		Last Update login
REQUEST_ID	NUMBER		Request id of the concurrent program
PROGRAM_APPLICATION_ID	NUMBER		Program application Id
PROGRAM_ID	NUMBER		Program Id
PROGRAM_UPDATE_DATE	DATE		Standard who column
OPERATION_DESC	VARCHAR2	(240)	Operation Description
VERSION	NUMBER		Operation Version

Query Text

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


SELECT SR_INSTANCE_ID
,      RESOURCE_ID
,      ORGANIZATION_ID
,      SETUP_ID
,      SETUP_CODE
,      SETUP_DESCRIPTION
,      ORGANIZATION_CODE
,      RESOURCE_CODE
,      DELETED_FLAG
,      REFRESH_ID
,      COMPANY_ID
,      COMPANY_NAME
,      SR_INSTANCE_CODE
,      MESSAGE_ID
,      PROCESS_FLAG
,      ERROR_TEXT
,      ST_TRANSACTION_ID
,      BATCH_ID
,      DATA_SOURCE_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      OPERATION_DESC
,      VERSION
FROM MSC.MSC_ST_RESOURCE_SETUPS;

Dependencies

[top of page]

MSC.MSC_ST_RESOURCE_SETUPS does not reference any database object

MSC.MSC_ST_RESOURCE_SETUPS is referenced by following:

MSC: MSC_ST_RESOURCE_SETUPS#