[Home] [Help]
[Dependency Information]
Object Name: | MSC_ST_ABC_CLASSES |
---|---|
Object Type: | TABLE |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
The staging table used by collections program to validate and process data for table MSC_ABC_CLASSES.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SR_ASSIGNMENT_GROUP_ID | NUMBER | SR ASSIGNMENT GROUP ID | ||
ORGANIZATION_ID | NUMBER | Organization Identifier | ||
SR_INSTANCE_ID | NUMBER | Source Application Instance Identifier | ||
ABC_CLASS_ID | NUMBER | ABC Class ID | ||
ABC_CLASS_NAME | VARCHAR2 | (40) | ABC Class Name |
Cut, paste (and edit) the following text to query this object:
SELECT SR_ASSIGNMENT_GROUP_ID
, ORGANIZATION_ID
, SR_INSTANCE_ID
, ABC_CLASS_ID
, ABC_CLASS_NAME
FROM MSC.MSC_ST_ABC_CLASSES;
MSC.MSC_ST_ABC_CLASSES does not reference any database object
MSC.MSC_ST_ABC_CLASSES is referenced by following:
|
|
|