[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MSC_BIS_INV_DETAIL |
|---|---|
| Object Type: | TABLE |
| Owner: | MSC |
| FND Design Data: |  MSC.MSC_BIS_INV_DETAIL
|
| Subobject Name: | |
| Status: | VALID |
MSC_BIS_INV_DETAIL contains Inventory balance details collected from source applications.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| MSC_BIS_INV_DETAIL_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
 PLAN_ID
SR_INSTANCE_ID
ORGANIZATION_ID
INVENTORY_ITEM_ID
|
| MSC_BIS_INV_DETAIL_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PLAN_ID
PERIOD_TYPE
DETAIL_LEVEL
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PLAN_ID | NUMBER | Yes | Plan ID | |
| ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
| SR_INSTANCE_ID | NUMBER | Yes | Source application instance identifier | |
| DETAIL_DATE | DATE | Yes | Detail date | |
| INVENTORY_ITEM_ID | NUMBER | Inventory item identifier | ||
| PROJECT_ID | NUMBER | Project identifier | ||
| TASK_ID | NUMBER | Task identifier | ||
| MDS_QUANTITY | NUMBER | Yes | Total MSD quantify of the plan | |
| INVENTORY_QUANTITY | NUMBER | Yes | Total inventory quantity of the plan | |
| INVENTORY_COST | NUMBER | Total inventory cost of the plan | ||
| MDS_COST | NUMBER | Tota MDS cost of the plan | ||
| MDS_PRICE | NUMBER | Total MDS price of the plan | ||
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| REQUEST_ID | NUMBER | Concurrent Who column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Concurrent Who column | ||
| PROGRAM_ID | NUMBER | Concurrent Who column | ||
| PROGRAM_UPDATE_DATE | DATE | Concurrent Who column | ||
| PRODUCTION_COST | NUMBER | Total production cost of the plan | ||
| PURCHASING_COST | NUMBER | Total purchasing cost for the plan | ||
| CARRYING_COST | NUMBER | Total carrying cost for the plan | ||
| SERVICE_LEVEL | NUMBER | Service level attained for the plan | ||
| DEMAND_PENALTY_COST | NUMBER | Penalty cost for the plan demand | ||
| INVENTORY_VALUE | NUMBER | Inventory value | ||
| SUPPLIER_OVERCAP_COST | NUMBER | Supplier Overcap Cost | ||
| INVENTORY_VALUE_NO_POST | NUMBER | Inventory Value No Post | ||
| INVENTORY_VALUE_POST | NUMBER | Inventory Value No Post | ||
| INVENTORY_COST_POST | NUMBER | Inventory Value No Post | ||
| INVENTORY_COST_NO_POST | NUMBER | Inventory Value No Post | ||
| DETAIL_LEVEL | NUMBER | Period type data or week type data | ||
| PERIOD_TYPE | NUMBER | bis data or mfg data | ||
| TRANSPORTATION_COST | NUMBER | transportation cost | ||
| PAB_VALUE | NUMBER | pab value | ||
| INT_REPAIR_COST | NUMBER | Internal Repair cost | ||
| EXT_REPAIR_COST | NUMBER | External Repair Cost | ||
| SUPPLIER_CAPACITY | NUMBER | Supplier Capacity | ||
| SUPPLIER_USAGE | NUMBER | Supplier Usage | ||
| SUPPLIER_ID | NUMBER | Supplier ID | ||
| SUPPLIER_SITE_ID | NUMBER | Supplier site ID | ||
| SHIP_METHOD | VARCHAR2 | (240) | Ship Method | |
| SERVICE_LEVEL_1 | NUMBER | Service level 1 | ||
| SERVICE_LEVEL_2 | NUMBER | Service Level 2 | ||
| TOTAL_COST | NUMBER | Total Cost | ||
| PAB | NUMBER | PAB | ||
| OTHER_COST | NUMBER | Other Cost | ||
| ZONE_ID | NUMBER | Zone ID | ||
| CUSTOMER_ID | NUMBER | Customer ID | ||
| CUSTOMER_SITE_ID | NUMBER | Customer site ID | ||
| ITEM_TRAVEL_DISTANCE | NUMBER | Item travel distance | ||
| SOURCE_ORGANIZATION_ID | NUMBER | Source organization ID | ||
| SOURCE_ORG_INSTANCE_ID | NUMBER | Source organization instance ID |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_ID
, ORGANIZATION_ID
, SR_INSTANCE_ID
, DETAIL_DATE
, INVENTORY_ITEM_ID
, PROJECT_ID
, TASK_ID
, MDS_QUANTITY
, INVENTORY_QUANTITY
, INVENTORY_COST
, MDS_COST
, MDS_PRICE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PRODUCTION_COST
, PURCHASING_COST
, CARRYING_COST
, SERVICE_LEVEL
, DEMAND_PENALTY_COST
, INVENTORY_VALUE
, SUPPLIER_OVERCAP_COST
, INVENTORY_VALUE_NO_POST
, INVENTORY_VALUE_POST
, INVENTORY_COST_POST
, INVENTORY_COST_NO_POST
, DETAIL_LEVEL
, PERIOD_TYPE
, TRANSPORTATION_COST
, PAB_VALUE
, INT_REPAIR_COST
, EXT_REPAIR_COST
, SUPPLIER_CAPACITY
, SUPPLIER_USAGE
, SUPPLIER_ID
, SUPPLIER_SITE_ID
, SHIP_METHOD
, SERVICE_LEVEL_1
, SERVICE_LEVEL_2
, TOTAL_COST
, PAB
, OTHER_COST
, ZONE_ID
, CUSTOMER_ID
, CUSTOMER_SITE_ID
, ITEM_TRAVEL_DISTANCE
, SOURCE_ORGANIZATION_ID
, SOURCE_ORG_INSTANCE_ID
FROM MSC.MSC_BIS_INV_DETAIL;
MSC.MSC_BIS_INV_DETAIL does not reference any database object
MSC.MSC_BIS_INV_DETAIL is referenced by following:
MSC
MSC_BIS_INV_DETAIL#
|
|
|
|