[Home] [Help] [Dependency Information]
Object Name: | MSC_ITEM_SO_SR_LEVELS# |
---|---|
Object Type: | VIEW |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | |||
SR_INSTANCE_ID | NUMBER | |||
PLAN_ID | NUMBER | |||
ASSIGNMENT_TYPE | NUMBER | |||
ASSIGNMENT_SET_ID | NUMBER | |||
SOURCING_RULE_TYPE | NUMBER | |||
SOURCE_ORGANIZATION_ID | NUMBER | |||
SOURCE_ORG_INSTANCE_ID | NUMBER | |||
ALLOCATION_PERCENT | NUMBER | |||
RANK | NUMBER | |||
EFFECTIVE_DATE | DATE | |||
DISABLE_DATE | DATE | |||
SOURCING_LEVEL | NUMBER | |||
ASSIGNMENT_ID | NUMBER | |||
SOURCING_RULE_ID | NUMBER | |||
SOURCING_RULE_NAME | VARCHAR2 | (80) | ||
SOURCE_TYPE | NUMBER | |||
SR_DESCRIPTION | VARCHAR2 | (80) | ||
COMPILE_DESIGNATOR | VARCHAR2 | (10) | ||
OWNING_ORG_ID | NUMBER | |||
COMP_MRP_PLANNING_CODE | NUMBER | |||
COMP_BOM_ITEM_TYPE | NUMBER | |||
COMP_PLANNING_MAKE_BUY_CODE | NUMBER | |||
COMP_PRIMARY_UOM_CODE | VARCHAR2 | (3) | ||
CUSTOMER_ID | NUMBER | |||
CUSTOMER_SITE_ID | NUMBER | |||
REGION_ID | NUMBER | |||
COMP_DRP_PLANNED | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT 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
, ALLOCATION_PERCENT
, RANK
, EFFECTIVE_DATE
, DISABLE_DATE
, SOURCING_LEVEL
, ASSIGNMENT_ID
, SOURCING_RULE_ID
, SOURCING_RULE_NAME
, SOURCE_TYPE
, SR_DESCRIPTION
, COMPILE_DESIGNATOR
, OWNING_ORG_ID
, COMP_MRP_PLANNING_CODE
, COMP_BOM_ITEM_TYPE
, COMP_PLANNING_MAKE_BUY_CODE
, COMP_PRIMARY_UOM_CODE
, CUSTOMER_ID
, CUSTOMER_SITE_ID
, REGION_ID
, COMP_DRP_PLANNED
FROM MSC.MSC_ITEM_SO_SR_LEVELS#;
|
|
|