[Home] [Help] [Dependency Information]
Object Name: | MSC_VMI_TEMP |
---|---|
Object Type: | TABLE |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
Temp table for VMI processing
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSC_VMI_TEMP_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
PLAN_ID
INVENTORY_ITEM_ID ORGANIZATION_ID SR_INSTANCE_ID VMI_TYPE SUPPLIER_ID SUPPLIER_SITE_ID USING_ORGANIZATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_ID | NUMBER | Plan identifier | ||
INVENTORY_ITEM_ID | NUMBER | Inventory item identifier | ||
ORGANIZATION_ID | NUMBER | Organization identifier | ||
SR_INSTANCE_ID | NUMBER | Source instance identifier | ||
SUPPLIER_ID | NUMBER | Supplier identifier | ||
SUPPLIER_SITE_ID | NUMBER | Supplier site identifier | ||
USING_ORGANIZATION_ID | NUMBER | Using organization identfier | ||
VMI_TYPE | NUMBER | Flag to identify VMI type | ||
AVERAGE_DAILY_DEMAND | NUMBER | Average daily demand quantity |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_ID
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, SR_INSTANCE_ID
, SUPPLIER_ID
, SUPPLIER_SITE_ID
, USING_ORGANIZATION_ID
, VMI_TYPE
, AVERAGE_DAILY_DEMAND
FROM MSC.MSC_VMI_TEMP;
MSC.MSC_VMI_TEMP does not reference any database object
MSC.MSC_VMI_TEMP is referenced by following:
|
|
|