[Home] [Help] [Dependency Information]
Object Name: | MSC_ITEM_FCST_SR_LEVELS |
---|---|
Object Type: | TABLE |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
This table stores hierarchy of sourcing for items that are part of Global Forecast.
This information is used internally to derive items to be included in plan.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSC_ITEM_FCST_SR_LEVELS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PLAN_ID
SR_INVENTORY_ITEM_ID SR_INSTANCE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | Inventory Item Id | ||
SR_INVENTORY_ITEM_ID | NUMBER | Source Inventory Item Id | ||
ORGANIZATION_ID | NUMBER | Organization Id | ||
SR_INSTANCE_ID | NUMBER | Source instance id | ||
PLAN_ID | NUMBER | Plan id | ||
ASSIGNMENT_TYPE | NUMBER | Assignment type | ||
ASSIGNMENT_SET_ID | NUMBER | Assignment set id | ||
SOURCING_RULE_TYPE | NUMBER | Sourcing rule type | ||
SOURCE_ORGANIZATION_ID | NUMBER | Source organization id | ||
SOURCE_ORG_INSTANCE_ID | NUMBER | Source organization instance id | ||
VENDOR_ID | NUMBER | Vendor id | ||
VENDOR_SITE_ID | NUMBER | Vendor site id | ||
ALLOCATION_PERCENT | NUMBER | Allocation percent | ||
RANK | NUMBER | Rank | ||
EFFECTIVE_DATE | DATE | Effective date | ||
DISABLE_DATE | DATE | Disable date | ||
CATEGORY_ID | NUMBER | Category id | ||
SOURCING_LEVEL | NUMBER | Internal number representing hierarchy of sourcing. | ||
ASSIGNMENT_ID | NUMBER | Assignment Id | ||
SOURCING_RULE_ID | NUMBER | Sourcing rule id | ||
SOURCING_RULE_NAME | VARCHAR2 | (80) | Sourcing rule name | |
SOURCE_TYPE | NUMBER | Source type | ||
SOURCE_ORG_CODE | VARCHAR2 | (6) | Source organization code | |
SR_DESCRIPTION | VARCHAR2 | (80) | Sourcing rule description | |
COMPILE_DESIGNATOR | VARCHAR2 | (10) | Plan name | |
OWNING_ORG_ID | NUMBER | Owning Organization id | ||
MRP_PLANNING_CODE | NUMBER | MRP planning code | ||
BOM_ITEM_TYPE | NUMBER | BOM Item type | ||
PLANNING_MAKE_BUY_CODE | NUMBER | Planning make/buy code | ||
PRIMARY_UOM_CODE | VARCHAR2 | (3) | Primary UOM code | |
COMP_MRP_PLANNING_CODE | NUMBER | Component MRP planning code | ||
CUSTOMER_ID | NUMBER | Customer id | ||
CUSTOMER_SITE_ID | NUMBER | Customer site id | ||
ZONE_ID | NUMBER | Zone id | ||
ASSY_DRP_PLANNED | NUMBER | Assembly item drp planned flag | ||
COMP_DRP_PLANNED | NUMBER | Component item drp planned flag |
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM_ID
, SR_INVENTORY_ITEM_ID
, ORGANIZATION_ID
, SR_INSTANCE_ID
, PLAN_ID
, ASSIGNMENT_TYPE
, ASSIGNMENT_SET_ID
, SOURCING_RULE_TYPE
, SOURCE_ORGANIZATION_ID
, SOURCE_ORG_INSTANCE_ID
, VENDOR_ID
, VENDOR_SITE_ID
, ALLOCATION_PERCENT
, RANK
, EFFECTIVE_DATE
, DISABLE_DATE
, CATEGORY_ID
, SOURCING_LEVEL
, ASSIGNMENT_ID
, SOURCING_RULE_ID
, SOURCING_RULE_NAME
, SOURCE_TYPE
, SOURCE_ORG_CODE
, SR_DESCRIPTION
, COMPILE_DESIGNATOR
, OWNING_ORG_ID
, MRP_PLANNING_CODE
, BOM_ITEM_TYPE
, PLANNING_MAKE_BUY_CODE
, PRIMARY_UOM_CODE
, COMP_MRP_PLANNING_CODE
, CUSTOMER_ID
, CUSTOMER_SITE_ID
, ZONE_ID
, ASSY_DRP_PLANNED
, COMP_DRP_PLANNED
FROM MSC.MSC_ITEM_FCST_SR_LEVELS;
MSC.MSC_ITEM_FCST_SR_LEVELS does not reference any database object
MSC.MSC_ITEM_FCST_SR_LEVELS is referenced by following:
|
|
|