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

TABLE: MSC.MSC_RP_CTB_DONOR_COMPONENTS

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

Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_RP_CTB_DONOR_COMPONENTS_U1 NORMAL UNIQUE Tablespace ColumnPLAN_ID
ColumnMAKE_ORDER_TRANSACTION_ID
ColumnDONOR_ORDER_TRANSACTION_ID
ColumnINVENTORY_ITEM_ID
ColumnORGANIZATION_ID
ColumnSR_INSTANCE_ID
Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER
Yes
MAKE_ORDER_TRANSACTION_ID NUMBER
Yes
DONOR_ORDER_TRANSACTION_ID NUMBER
Yes
INVENTORY_ITEM_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
SR_INSTANCE_ID NUMBER
Yes
PEGGED_ON_HAND_QUANTITY NUMBER

COMPONENT_QUANTITY NUMBER

PERCENT_OF_ON_HAND NUMBER

POTENTIAL_ONHAND_INCREASE NUMBER

TOTAL_COMPONENT_ON_HAND NUMBER

PERCENT_PEGGED_BY_ON_HAND NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

Query Text

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


SELECT PLAN_ID
,      MAKE_ORDER_TRANSACTION_ID
,      DONOR_ORDER_TRANSACTION_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      PEGGED_ON_HAND_QUANTITY
,      COMPONENT_QUANTITY
,      PERCENT_OF_ON_HAND
,      POTENTIAL_ONHAND_INCREASE
,      TOTAL_COMPONENT_ON_HAND
,      PERCENT_PEGGED_BY_ON_HAND
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM MSC.MSC_RP_CTB_DONOR_COMPONENTS;

Dependencies

[top of page]

MSC.MSC_RP_CTB_DONOR_COMPONENTS does not reference any database object

MSC.MSC_RP_CTB_DONOR_COMPONENTS is referenced by following:

SchemaMSC
ViewMSC_RP_CTB_DONOR_COMPONENTS#