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_RES_INSTANCE_CHANGES

Object Details

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

Staging table for capacity changes for resource instances associated with simulation set

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
SR_INSTANCE_ID	NUMBER		Source instance Id
DEPARTMENT_ID	NUMBER		Department Id
RESOURCE_ID	NUMBER		Resource Id
ORGANIZATION_ID	NUMBER		Organization id
RES_INSTANCE_ID	NUMBER		Resource Instance id
SERIAL_NUMBER	VARCHAR2	(30)	Resource instance Serial Number
SHIFT_NUM	NUMBER		Resource instance Shift number
FROM_DATE	DATE		Capacity exception from date
FROM_TIME	NUMBER		Capacity exception from time
TO_DATE	DATE		Capacity exception to date
TO_TIME	NUMBER		Capacity exception to time
SIMULATION_SET	VARCHAR2	(10)	Simulation set associated with capacity change
CAPACITY_CHANGE	NUMBER		Capacity change
ORGAINZATION_CODE	VARCHAR2	(7)	Organization Code. For Legacy
RESOURCE_CODE	VARCHAR2	(10)	Resource code. For Legacy
RES_INSTANCE_CODE	VARCHAR2	(10)	Resource Instance Code
DEPARTMENT_CODE	VARCHAR2	(10)	Department code. For Legacy
ACTION_TYPE	NUMBER		Type of capacity modification
DELETED_FLAG	NUMBER		For marking record as delete
REFRESH_ID	NUMBER		Refresh Identifier
COMPANY_ID	NUMBER		For Legacy
COMPANY_NAME	VARCHAR2	(255)	For Legacy
SR_INSTANCE_CODE	VARCHAR2	(3)	For Legacy
MESSAGE_ID	NUMBER		For Legacy
PROCESS_FLAG	NUMBER		For Legacy
ERROR_TEXT	VARCHAR2	(2000)	For Legacy
ST_TRANSACTION_ID	NUMBER		For Legacy
BATCH_ID	NUMBER		For Legacy
DATA_SOURCE_TYPE	VARCHAR2	(15)	Source Type indicating the source of the records
LAST_UPDATE_DATE	DATE		Standard who column
LAST_UPDATED_BY	NUMBER		Standard who column
CREATION_DATE	DATE		Standard who column
CREATED_BY	NUMBER		Standard who column
LAST_UPDATE_LOGIN	NUMBER		Standard who column
REQUEST_ID	NUMBER		Standard who column
PROGRAM_APPLICATION_ID	NUMBER		Standard who column
PROGRAM_ID	NUMBER		Standard who column
PROGRAM_UPDATE_DATE	DATE		Standard who column

Query Text

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


SELECT SR_INSTANCE_ID
,      DEPARTMENT_ID
,      RESOURCE_ID
,      ORGANIZATION_ID
,      RES_INSTANCE_ID
,      SERIAL_NUMBER
,      SHIFT_NUM
,      FROM_DATE
,      FROM_TIME
,      TO_DATE
,      TO_TIME
,      SIMULATION_SET
,      CAPACITY_CHANGE
,      ORGAINZATION_CODE
,      RESOURCE_CODE
,      RES_INSTANCE_CODE
,      DEPARTMENT_CODE
,      ACTION_TYPE
,      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
FROM MSC.MSC_ST_RES_INSTANCE_CHANGES;

Dependencies

[top of page]

MSC.MSC_ST_RES_INSTANCE_CHANGES does not reference any database object

MSC.MSC_ST_RES_INSTANCE_CHANGES is referenced by following:

APPS: MSC_ST_RES_INSTANCE_CHANGES