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


TABLE: MSC.MSC_RP_RELEASED_ORDERS

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

Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_RP_RELEASED_ORDERS_N1 NORMAL NONUNIQUE Tablespace ColumnPLAN_ID
ColumnPLAN_VERSION
Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER
Yes
TRANSACTION_ID NUMBER
Yes
IMPLEMENTED_QUANITY NUMBER

IMPLEMENTED_DATE DATE

PLAN_VERSION NUMBER

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

RELEASE_STATUS NUMBER

Query Text

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


SELECT PLAN_ID
,      TRANSACTION_ID
,      IMPLEMENTED_QUANITY
,      IMPLEMENTED_DATE
,      PLAN_VERSION
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      RELEASE_STATUS
FROM MSC.MSC_RP_RELEASED_ORDERS;

Dependencies

[top of page]

MSC.MSC_RP_RELEASED_ORDERS does not reference any database object

MSC.MSC_RP_RELEASED_ORDERS is referenced by following:

SchemaMSC
ViewMSC_RP_RELEASED_ORDERS#