[Home] [Help] [Dependency Information]

TABLE: MSC.MSC_INT_WO_CMRO_CONFIG

Object Details

Object Name:	MSC_INT_WO_CMRO_CONFIG
Object Type:	TABLE
Owner:	MSC
FND Design Data:	MSC.MSC_INT_WO_CMRO_CONFIG
Subobject Name:
Status:	VALID

Temporary Table Details

MSC.MSC_INT_WO_CMRO_CONFIG is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Primary Key: MSC_WO_CMRO_CONFIG_PK

1. OI__WORK_ORDER_CODE
2. OI__BRANCH_CODE

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSC_WO_CMRO_CONFIG_PK	NORMAL	UNIQUE		OI__WORK_ORDER_CODE OI__BRANCH_CODE

Columns

Query Text

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

SELECT OI__WORK_ORDER_CODE
,      OI__BRANCH_CODE
,      OI__VISIT_CODE
,      OI__WORK_BREAKDOWN_LEVEL1
,      OI__WORK_BREAKDOWN_LEVEL2
,      OI__WORK_BREAKDOWN_LEVEL3
,      OI__WORK_BREAKDOWN_LEVEL4
,      OI__WORK_BREAKDOWN_LEVEL5
,      OI__WORK_BREAKDOWN_LEVEL6
,      OI__WORK_BREAKDOWN_LEVEL7
,      OI__WORK_BREAKDOWN_LEVEL8
,      OI__WORK_BREAKDOWN_LEVEL9
,      OI__PREVIOUS_MILESTONE_CODE
,      OI__NEXT_MILESTONE_CODE
FROM MSC.MSC_INT_WO_CMRO_CONFIG;

Dependencies

[top of page]

MSC.MSC_INT_WO_CMRO_CONFIG does not reference any database object

MSC.MSC_INT_WO_CMRO_CONFIG is referenced by following:

APPS

MSC_INT_WO_CMRO_CONFIG