Skip to content

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

TABLE: MSC.MSC_ST_SUPPLIES_F

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

Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_ST_SUPPLIES_F_N1 NORMAL NONUNIQUE Tablespace ColumnST_TRANSACTION_ID
ColumnERROR_CODE
Columns
Name Datatype Length Mandatory Comments
ST_TRANSACTION_ID NUMBER
Yes
ERROR_CODE NUMBER

SR_INSTANCE_ID NUMBER

ORGANIZATION_ID NUMBER

INVENTORY_ITEM_ID NUMBER

SUPPLIER_ID NUMBER

SUPPLIER_SITE_ID NUMBER

REGION_ID NUMBER

PROJECT_ID NUMBER

TASK_ID NUMBER

ORGANIZATION_CODE VARCHAR2 (20)
ITEM_NAME VARCHAR2 (250)
SUPPLIER_NAME VARCHAR2 (255)
SUPPLIER_SITE_CODE VARCHAR2 (60)
ZONE VARCHAR2 (400)
PROJECT_NUMBER VARCHAR2 (25)
TASK_NUMBER VARCHAR2 (25)
SHIP_METHOD VARCHAR2 (30)
SUPPLY_TYPE NUMBER

PART_CONDITION NUMBER

VMI_FLAG NUMBER

SUPPLY_DATE DATE

SUPPLY_QTY NUMBER

PLANNED_ORDER_COUNT NUMBER

PLANNED_ORDER_ITF_COUNT NUMBER

PLANNED_ORDER_GMOD_COUNT NUMBER

PLANNED_ORDER_BWO_COUNT NUMBER

WORK_ORDER_LEADTIME NUMBER

WORK_ORDER_COUNT VARCHAR2 (240)
QTY_PEGGED_TO_EXCESS NUMBER

STOCKOUT_DAYS NUMBER

WORK_ORDER_QTY NUMBER

DRP_SUPPLY_AS_DEMAND NUMBER

RETURN_ORDER_QTY NUMBER

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

PROGRAM_ID NUMBER

PROGRAM_LOGIN_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

REQUEST_ID NUMBER

SUPPLY_VOLUME NUMBER

SOURCE_ORG_INSTANCE_ID NUMBER

SOURCE_ORGANIZATION_ID NUMBER

SOURCE_ORG_CODE VARCHAR2 (20)
RETURN_FCST NUMBER

OWNING_INST_ID NUMBER

OWNING_ORG_ID NUMBER

OWNING_ORG_CODE VARCHAR2 (20)
CUSTOMER_REGION_ID NUMBER

CUSTOMER_ZONE VARCHAR2 (400)
END_ITEM_INST_ID NUMBER

END_ITEM_ORG_ID NUMBER

END_ITEM_ID NUMBER

PARENT_MODEL_ITEM_ID NUMBER

END_ITEM_ORG_CODE VARCHAR2 (20)
END_ITEM_NAME VARCHAR2 (250)
PARENT_MODEL_ITEM_NAME VARCHAR2 (250)
SUBINVENTORY_CODE VARCHAR2 (10)
PO_RESCHEDULE_COUNT NUMBER

PO_COUNT NUMBER

PO_CANCEL_COUNT NUMBER

BUY_ORDER_VALUE NUMBER

BUY_ORDER_VALUE2 NUMBER

BUY_ORDER_COUNT NUMBER

Query Text

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


SELECT ST_TRANSACTION_ID
,      ERROR_CODE
,      SR_INSTANCE_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      REGION_ID
,      PROJECT_ID
,      TASK_ID
,      ORGANIZATION_CODE
,      ITEM_NAME
,      SUPPLIER_NAME
,      SUPPLIER_SITE_CODE
,      ZONE
,      PROJECT_NUMBER
,      TASK_NUMBER
,      SHIP_METHOD
,      SUPPLY_TYPE
,      PART_CONDITION
,      VMI_FLAG
,      SUPPLY_DATE
,      SUPPLY_QTY
,      PLANNED_ORDER_COUNT
,      PLANNED_ORDER_ITF_COUNT
,      PLANNED_ORDER_GMOD_COUNT
,      PLANNED_ORDER_BWO_COUNT
,      WORK_ORDER_LEADTIME
,      WORK_ORDER_COUNT
,      QTY_PEGGED_TO_EXCESS
,      STOCKOUT_DAYS
,      WORK_ORDER_QTY
,      DRP_SUPPLY_AS_DEMAND
,      RETURN_ORDER_QTY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
,      SUPPLY_VOLUME
,      SOURCE_ORG_INSTANCE_ID
,      SOURCE_ORGANIZATION_ID
,      SOURCE_ORG_CODE
,      RETURN_FCST
,      OWNING_INST_ID
,      OWNING_ORG_ID
,      OWNING_ORG_CODE
,      CUSTOMER_REGION_ID
,      CUSTOMER_ZONE
,      END_ITEM_INST_ID
,      END_ITEM_ORG_ID
,      END_ITEM_ID
,      PARENT_MODEL_ITEM_ID
,      END_ITEM_ORG_CODE
,      END_ITEM_NAME
,      PARENT_MODEL_ITEM_NAME
,      SUBINVENTORY_CODE
,      PO_RESCHEDULE_COUNT
,      PO_COUNT
,      PO_CANCEL_COUNT
,      BUY_ORDER_VALUE
,      BUY_ORDER_VALUE2
,      BUY_ORDER_COUNT
FROM MSC.MSC_ST_SUPPLIES_F;

Dependencies

[top of page]

MSC.MSC_ST_SUPPLIES_F does not reference any database object

MSC.MSC_ST_SUPPLIES_F is referenced by following:

SchemaMSC
ViewMSC_ST_SUPPLIES_F#