DBA Data[Home] [Help] [Dependency Information]

TABLE: MSC.MSC_ST_DEMAND_CLASSES

Object Details
Object Name: MSC_ST_DEMAND_CLASSES
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_ST_DEMAND_CLASSES
Subobject Name:
Status: VALID


The staging table used by the collection program to validate and process
data for demand classes.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
DEMAND_CLASS VARCHAR2 (30) Yes Demand class code
MEANING VARCHAR2 (80) Yes Damand class meaning
DESCRIPTION VARCHAR2 (250)
Describe the demand class
FROM_DATE DATE

Start date
TO_DATE DATE

End date
ENABLED_FLAG NUMBER

Enabled flag
SR_INSTANCE_ID NUMBER
Yes Source application instance identifer
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

Concurrent Who Column
PROGRAM_APPLICATION_ID NUMBER

Concurrent Who Column
PROGRAM_ID NUMBER

Concurrent Who Column
PROGRAM_UPDATE_DATE DATE

Concurrent Who Column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
DELETED_FLAG NUMBER

Deleted flag
REFRESH_ID NUMBER

Refresh identifier
SR_INSTANCE_CODE VARCHAR2 (3)
Instance Code
MESSAGE_ID NUMBER

This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML
PROCESS_FLAG NUMBER

Processing flag indicating the status of records during pre-processing. 1-New Record, 2- In-Process, 3- Error, 4-Propagated Error, 5- Successfully Processed
DATA_SOURCE_TYPE VARCHAR2 (15)
Source Type indicating the source of records
ST_TRANSACTION_ID NUMBER

Transaction ID generated during pre-processing to uniquely identify a record in the staging table
ERROR_TEXT VARCHAR2 (2000)
If PROCESS_FLAG is equals to 3 for a record then it will describe the reason for the error
BATCH_ID NUMBER

Batch Identifier generated during pre-processing
COMPANY_NAME VARCHAR2 (255)
Company name
Query Text

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


SELECT DEMAND_CLASS
,      MEANING
,      DESCRIPTION
,      FROM_DATE
,      TO_DATE
,      ENABLED_FLAG
,      SR_INSTANCE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      DELETED_FLAG
,      REFRESH_ID
,      SR_INSTANCE_CODE
,      MESSAGE_ID
,      PROCESS_FLAG
,      DATA_SOURCE_TYPE
,      ST_TRANSACTION_ID
,      ERROR_TEXT
,      BATCH_ID
,      COMPANY_NAME
FROM MSC.MSC_ST_DEMAND_CLASSES;

Dependencies

[top of page]

MSC.MSC_ST_DEMAND_CLASSES does not reference any database object

MSC.MSC_ST_DEMAND_CLASSES is referenced by following:

SchemaMSC
ViewMSC_ST_DEMAND_CLASSES#