[Home] [Help] [Dependency Information]
Object Name: | MRP_SYSTEM_ITEMS# |
---|---|
Object Type: | VIEW |
Owner: | MRP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | Yes | ||
ORGANIZATION_ID | NUMBER | Yes | ||
COMPILE_DESIGNATOR | VARCHAR2 | (10) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
IN_SOURCE_PLAN | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | |||
INVENTORY_TYPE | NUMBER | Yes | ||
MRP_PLANNING_CODE | NUMBER | Yes | ||
INVENTORY_PLANNING_CODE | NUMBER | Yes | ||
LOW_LEVEL_CODE | NUMBER | Yes | ||
PREPROCESSING_LEAD_TIME | NUMBER | |||
POSTPROCESSING_LEAD_TIME | NUMBER | |||
FULL_LEAD_TIME | NUMBER | Yes | ||
CUMULATIVE_TOTAL_LEAD_TIME | NUMBER | |||
CUM_MANUFACTURING_LEAD_TIME | NUMBER | |||
FIXED_LEAD_TIME | NUMBER | |||
VARIABLE_LEAD_TIME | NUMBER | |||
UOM_CODE | VARCHAR2 | (3) | Yes | |
BUILD_IN_WIP_FLAG | NUMBER | Yes | ||
PURCHASING_ENABLED_FLAG | NUMBER | Yes | ||
PLANNING_MAKE_BUY_CODE | NUMBER | Yes | ||
REPETITIVE_TYPE | NUMBER | Yes | ||
STANDARD_COST | NUMBER | |||
LOT_CONTROL_CODE | NUMBER | Yes | ||
ROUNDING_CONTROL_TYPE | NUMBER | Yes | ||
CALCULATE_ATP | NUMBER | Yes | ||
END_ASSEMBLY_PEGGING | NUMBER | Yes | ||
NETTABLE_INVENTORY_QUANTITY | NUMBER | Yes | ||
NONNETTABLE_INVENTORY_QUANTITY | NUMBER | Yes | ||
ENGINEERING_ITEM_FLAG | NUMBER | Yes | ||
WIP_SUPPLY_TYPE | NUMBER | |||
OVERRUN_PERCENTAGE | NUMBER | |||
ACCEPTABLE_RATE_INCREASE | NUMBER | |||
ACCEPTABLE_RATE_DECREASE | NUMBER | |||
SAFETY_STOCK_CODE | NUMBER | Yes | ||
SAFETY_STOCK_PERCENT | NUMBER | |||
SAFETY_STOCK_BUCKET_DAYS | NUMBER | |||
SAFETY_STOCK_QUANTITY | NUMBER | |||
PLAN_LAST_REVISION_DATE | DATE | |||
DESCRIPTION | VARCHAR2 | (240) | ||
CATEGORY_ID | NUMBER | |||
BUYER_ID | NUMBER | (9) | ||
BUYER_NAME | VARCHAR2 | (240) | ||
PLANNER_CODE | VARCHAR2 | (10) | ||
ABC_CLASS | NUMBER | |||
REVISION | VARCHAR2 | (3) | ||
FIXED_DAYS_SUPPLY | NUMBER | |||
FIXED_ORDER_QUANTITY | NUMBER | |||
FIXED_LOT_MULTIPLIER | NUMBER | |||
MINIMUM_ORDER_QUANTITY | NUMBER | |||
MAXIMUM_ORDER_QUANTITY | NUMBER | |||
PLANNING_TIME_FENCE_DAYS | NUMBER | |||
PLANNING_TIME_FENCE_DATE | DATE | |||
DEMAND_TIME_FENCE_DAYS | NUMBER | |||
INVENTORY_USE_UP_DATE | DATE | |||
ACCEPTABLE_EARLY_DELIVERY | NUMBER | |||
PLANNER_BATCH_NUMBER | NUMBER | |||
PLANNER_STATUS_CODE | NUMBER | |||
PLAN_START_DATE | DATE | |||
PLAN_COMPLETION_DATE | DATE | |||
SHRINKAGE_RATE | NUMBER | |||
PLANNING_EXCEPTION_SET | VARCHAR2 | (10) | ||
EXCESS_QUANTITY | NUMBER | |||
REPETITIVE_VARIANCE | NUMBER | |||
EXCEPTION_SHORTAGE_DAYS | NUMBER | |||
EXCEPTION_EXCESS_DAYS | NUMBER | |||
EXCEPTION_REP_VARIANCE_DAYS | NUMBER | |||
EXCEPTION_OVERPROMISED_DAYS | NUMBER | |||
BASE_ITEM_ID | NUMBER | |||
BOM_ITEM_TYPE | NUMBER | |||
ATO_FORECAST_CONTROL | NUMBER | |||
EXCEPTION_CODE | VARCHAR2 | (5) | ||
PROGRAM_UPDATE_DATE | DATE | |||
PRIMARY_VENDOR_ID | NUMBER | |||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
DEMAND_TIME_FENCE_DATE | DATE | |||
FULL_PEGGING | NUMBER | |||
ORGANIZATION_CODE | VARCHAR2 | (3) | ||
EFFECTIVITY_CONTROL | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM_ID
, ORGANIZATION_ID
, COMPILE_DESIGNATOR
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, IN_SOURCE_PLAN
, LAST_UPDATE_LOGIN
, INVENTORY_TYPE
, MRP_PLANNING_CODE
, INVENTORY_PLANNING_CODE
, LOW_LEVEL_CODE
, PREPROCESSING_LEAD_TIME
, POSTPROCESSING_LEAD_TIME
, FULL_LEAD_TIME
, CUMULATIVE_TOTAL_LEAD_TIME
, CUM_MANUFACTURING_LEAD_TIME
, FIXED_LEAD_TIME
, VARIABLE_LEAD_TIME
, UOM_CODE
, BUILD_IN_WIP_FLAG
, PURCHASING_ENABLED_FLAG
, PLANNING_MAKE_BUY_CODE
, REPETITIVE_TYPE
, STANDARD_COST
, LOT_CONTROL_CODE
, ROUNDING_CONTROL_TYPE
, CALCULATE_ATP
, END_ASSEMBLY_PEGGING
, NETTABLE_INVENTORY_QUANTITY
, NONNETTABLE_INVENTORY_QUANTITY
, ENGINEERING_ITEM_FLAG
, WIP_SUPPLY_TYPE
, OVERRUN_PERCENTAGE
, ACCEPTABLE_RATE_INCREASE
, ACCEPTABLE_RATE_DECREASE
, SAFETY_STOCK_CODE
, SAFETY_STOCK_PERCENT
, SAFETY_STOCK_BUCKET_DAYS
, SAFETY_STOCK_QUANTITY
, PLAN_LAST_REVISION_DATE
, DESCRIPTION
, CATEGORY_ID
, BUYER_ID
, BUYER_NAME
, PLANNER_CODE
, ABC_CLASS
, REVISION
, FIXED_DAYS_SUPPLY
, FIXED_ORDER_QUANTITY
, FIXED_LOT_MULTIPLIER
, MINIMUM_ORDER_QUANTITY
, MAXIMUM_ORDER_QUANTITY
, PLANNING_TIME_FENCE_DAYS
, PLANNING_TIME_FENCE_DATE
, DEMAND_TIME_FENCE_DAYS
, INVENTORY_USE_UP_DATE
, ACCEPTABLE_EARLY_DELIVERY
, PLANNER_BATCH_NUMBER
, PLANNER_STATUS_CODE
, PLAN_START_DATE
, PLAN_COMPLETION_DATE
, SHRINKAGE_RATE
, PLANNING_EXCEPTION_SET
, EXCESS_QUANTITY
, REPETITIVE_VARIANCE
, EXCEPTION_SHORTAGE_DAYS
, EXCEPTION_EXCESS_DAYS
, EXCEPTION_REP_VARIANCE_DAYS
, EXCEPTION_OVERPROMISED_DAYS
, BASE_ITEM_ID
, BOM_ITEM_TYPE
, ATO_FORECAST_CONTROL
, EXCEPTION_CODE
, PROGRAM_UPDATE_DATE
, PRIMARY_VENDOR_ID
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, DEMAND_TIME_FENCE_DATE
, FULL_PEGGING
, ORGANIZATION_CODE
, EFFECTIVITY_CONTROL
FROM MRP.MRP_SYSTEM_ITEMS#;
|
|
|