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

TABLE: MSC.MSC_RP_CTB_ORDER_COMPONENTS

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

Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_RP_CTB_ORDER_COMPONENTS_U1 NORMAL UNIQUE Tablespace ColumnPLAN_ID
ColumnMAKE_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
INVENTORY_ITEM_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
SR_INSTANCE_ID NUMBER
Yes
COMPONENT_QUANTITY NUMBER

PEGGED_ON_HAND_QUANTITY NUMBER

TOTAL_COMPONENT_ON_HAND NUMBER

PERCENT_PEGGED_BY_ON_HAND NUMBER

PERCENT_OF_ON_HAND NUMBER

MAXIMUM_CTB_PERCENT NUMBER

CTB_PRIORITY 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
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      COMPONENT_QUANTITY
,      PEGGED_ON_HAND_QUANTITY
,      TOTAL_COMPONENT_ON_HAND
,      PERCENT_PEGGED_BY_ON_HAND
,      PERCENT_OF_ON_HAND
,      MAXIMUM_CTB_PERCENT
,      CTB_PRIORITY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM MSC.MSC_RP_CTB_ORDER_COMPONENTS;

Dependencies

[top of page]

MSC.MSC_RP_CTB_ORDER_COMPONENTS does not reference any database object

MSC.MSC_RP_CTB_ORDER_COMPONENTS is referenced by following:

SchemaMSC
ViewMSC_RP_CTB_ORDER_COMPONENTS#