[Home] [Help] [Dependency Information]
Object Name: | MSC_COLL_ITEM_ATTRIBUTES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SOURCE_ROW_ID | ROWID | (10) | Source Row Id | |
PLAN_ID | NUMBER | Yes | Plan Id | |
SR_INSTANCE_ID | NUMBER | Yes | Sr Instance Id | |
ORGANIZATION_ID | NUMBER | Yes | Organization Id | |
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory Item Id | |
ITEM_SEGMENTS | VARCHAR2 | (250) | Item Segments | |
ORGANIZATION_CODE | VARCHAR2 | (7) | Organization Code | |
ORI_PLANNER_CODE | VARCHAR2 | (10) | Planner Code | |
SR_CATEGORY_ID | NUMBER | Yes | Sr Category Id | |
CATEGORY_SET_ID | NUMBER | Yes | Category Set Id | |
CATEGORY | VARCHAR2 | (250) | Yes | Category |
DESCRIPTION | VARCHAR2 | (240) | Description | |
ORI_CRITICAL_COMPONENT_FLAG | VARCHAR2 | (80) | Ori Critical Component Flag | |
ORI_FULL_LEAD_TIME | NUMBER | Ori Full Lead Time | ||
ORI_PREPROCESSING_LEAD_TIME | NUMBER | Ori Preprocessing Lead Time | ||
ORI_POSTPROCESSING_LEAD_TIME | NUMBER | Ori Postprocessing Lead Time | ||
ORI_FIXED_LEAD_TIME | NUMBER | Ori Fixed Lead Time | ||
ORI_VARIABLE_LEAD_TIME | NUMBER | Ori Variable Lead Time | ||
ORI_FIXED_ORDER_QUANTITY | NUMBER | Ori Fixed Order Quantity | ||
ORI_FIXED_DAYS_SUPPLY | NUMBER | Ori Fixed Days Supply | ||
ORI_SHRINKAGE_RATE | NUMBER | Ori Shrinkage Rate | ||
ORI_FIXED_LOT_MULTIPLIER | NUMBER | Ori Fixed Lot Multiplier | ||
ORI_MINIMUM_ORDER_QUANTITY | NUMBER | Ori Minimum Order Quantity | ||
ORI_MAXIMUM_ORDER_QUANTITY | NUMBER | Ori Maximum Order Quantity | ||
ORI_SERVICE_LEVEL | VARCHAR2 | (0) | Ori Service Level | |
ORI_CARRYING_COST | NUMBER | Ori Carrying Cost | ||
ORI_DEMAND_TIME_FENCE_DAYS | NUMBER | Ori Demand Time Fence Days | ||
ORI_ATO_FORECAST_CONTROL | VARCHAR2 | (80) | Ori Ato Forecast Control | |
ORI_PLANNING_TIME_FENCE_DAYS | NUMBER | Ori Planning Time Fence Days | ||
ORI_STANDARD_COST | NUMBER | Ori Standard Cost | ||
ORI_NET_SELLING_PRICE | NUMBER | Ori Net Selling Price | ||
ORI_PIP_FLAG | VARCHAR2 | (80) | Ori Pip Flag | |
ORI_LIST_PRICE | NUMBER | Ori List Price | ||
ORI_SUBSTITUTION_WINDOW | NUMBER | Ori Substitution Window | ||
ORI_SAFETY_STOCK_BUCKET_DAYS | NUMBER | Ori Safety Stock Bucket Days | ||
ORI_UNIT_WEIGHT | NUMBER | Ori Unit Weight | ||
ORI_UNIT_VOLUME | NUMBER | Ori Unit Volume | ||
ORI_SAFETY_STOCK_CODE | VARCHAR2 | (80) | Ori Safety Stock Code | |
ORI_SAFETY_STOCK_PERCENT | NUMBER | Ori Safety Stock Percent | ||
ORI_ABC_CLASS_NAME | VARCHAR2 | (40) | Ori Abc Class Name | |
ORI_MRP_PLANNING_CODE | VARCHAR2 | (80) | Ori Mrp Planning Code | |
ORI_DRP_PLANNED | VARCHAR2 | (80) | Ori Drp Planned | |
ORI_DAYS_MAX_INV_SUPPLY | NUMBER | Ori Days Max Inv Supply | ||
ORI_DAYS_MAX_INV_WINDOW | NUMBER | Ori Days Max Inv Window | ||
ORI_DAYS_TGT_INV_SUPPLY | NUMBER | Ori Days Tgt Inv Supply | ||
ORI_DAYS_TGT_INV_WINDOW | NUMBER | Ori Days Tgt Inv Window | ||
ORI_CONTINOUS_TRANSFER | VARCHAR2 | (80) | Ori Continous Transfer | |
ORI_CONVERGENCE | VARCHAR2 | (80) | Ori Convergence | |
ORI_CREATE_SUPPLY_FLAG | VARCHAR2 | (80) | Ori Create Supply Flag | |
ORI_DIVERGENCE | VARCHAR2 | (80) | Ori Divergence | |
ORI_PLANNING_EXCEPTION_SET | VARCHAR2 | (10) | Ori Planning Exception Set | |
ORI_INVENTORY_USE_UP_DATE | DATE | Ori Inventory Use Up Date | ||
ORI_PLANNING_MAKE_BUY_CODE | VARCHAR2 | (80) | Ori Planning Make Buy Code | |
ORI_MARGIN | NUMBER | Ori Margin | ||
ORI_WEIGHT_UOM | VARCHAR2 | (3) | Ori Weight Uom | |
ORI_VOLUME_UOM | VARCHAR2 | (3) | Ori Volume Uom | |
ORI_ROUNDING_CONTROL_TYPE | VARCHAR2 | (80) | Ori Rounding Control Type | |
ORI_ATP_FLAG | VARCHAR2 | (80) | Ori Atp Flag | |
ORI_ATP_COMPONENTS_FLAG | VARCHAR2 | (80) | Ori Atp Components Flag | |
ORI_DEMAND_FULFILLMENT_LT | VARCHAR2 | (0) | Ori Demand Fulfillment Lt | |
ORI_LOTS_EXPIRATION | NUMBER | Ori Lots Expiration | ||
ORI_VMI_MINIMUM_UNITS | NUMBER | Ori Vmi Minimum Units | ||
ORI_VMI_MINIMUM_DAYS | NUMBER | Ori Vmi Minimum Days | ||
ORI_VMI_MAXIMUM_UNITS | NUMBER | Ori Vmi Maximum Units | ||
ORI_VMI_MAXIMUM_DAYS | NUMBER | Ori Vmi Maximum Days | ||
ORI_VMI_FIXED_ORDER_QUANTITY | NUMBER | Ori Vmi Fixed Order Quantity | ||
ORI_CONSIGNED_FLAG | VARCHAR2 | (80) | Ori Consigned Flag | |
ORI_LEADTIME_VARIABILITY | VARCHAR2 | (0) | Ori Leadtime Variability | |
DESTINATION_ROW_ID | VARCHAR2 | (0) | Destination Row Id | |
SIMULATION_SET_ID | VARCHAR2 | (0) | Simulation Set Id | |
CRITICAL_COMPONENT_FLAG | VARCHAR2 | (0) | Critical Component Flag | |
FULL_LEAD_TIME | VARCHAR2 | (0) | Full Lead Time | |
PREPROCESSING_LEAD_TIME | VARCHAR2 | (0) | Preprocessing Lead Time | |
POSTPROCESSING_LEAD_TIME | VARCHAR2 | (0) | Postprocessing Lead Time | |
FIXED_LEAD_TIME | VARCHAR2 | (0) | Fixed Lead Time | |
VARIABLE_LEAD_TIME | VARCHAR2 | (0) | Variable Lead Time | |
FIXED_ORDER_QUANTITY | VARCHAR2 | (0) | Fixed Order Quantity | |
FIXED_DAYS_SUPPLY | VARCHAR2 | (0) | Fixed Days Supply | |
SHRINKAGE_RATE | VARCHAR2 | (0) | Shrinkage Rate | |
FIXED_LOT_MULTIPLIER | VARCHAR2 | (0) | Fixed Lot Multiplier | |
MINIMUM_ORDER_QUANTITY | VARCHAR2 | (0) | Minimum Order Quantity | |
MAXIMUM_ORDER_QUANTITY | VARCHAR2 | (0) | Maximum Order Quantity | |
SERVICE_LEVEL | VARCHAR2 | (0) | Service Level | |
CARRYING_COST | VARCHAR2 | (0) | Carrying Cost | |
DEMAND_TIME_FENCE_DAYS | VARCHAR2 | (0) | Demand Time Fence Days | |
ATO_FORECAST_CONTROL | VARCHAR2 | (0) | Ato Forecast Control | |
PLANNING_TIME_FENCE_DAYS | VARCHAR2 | (0) | Planning Time Fence Days | |
STANDARD_COST | VARCHAR2 | (0) | Standard Cost | |
NET_SELLING_PRICE | VARCHAR2 | (0) | Net Selling Price | |
PIP_FLAG | VARCHAR2 | (0) | Pip Flag | |
LIST_PRICE | VARCHAR2 | (0) | List Price | |
SUBSTITUTION_WINDOW | VARCHAR2 | (0) | Substitution Window | |
SAFETY_STOCK_BUCKET_DAYS | VARCHAR2 | (0) | Safety Stock Bucket Days | |
UNIT_WEIGHT | VARCHAR2 | (0) | Unit Weight | |
UNIT_VOLUME | VARCHAR2 | (0) | Unit Volume | |
SAFETY_STOCK_CODE | VARCHAR2 | (0) | Safety Stock Code | |
SAFETY_STOCK_PERCENT | VARCHAR2 | (0) | Safety Stock Percent | |
ABC_CLASS_NAME | VARCHAR2 | (0) | Abc Class Name | |
MRP_PLANNING_CODE | VARCHAR2 | (0) | Mrp Planning Code | |
DRP_PLANNED | VARCHAR2 | (0) | Drp Planned | |
DAYS_MAX_INV_SUPPLY | VARCHAR2 | (0) | Days Max Inv Supply | |
DAYS_MAX_INV_WINDOW | VARCHAR2 | (0) | Days Max Inv Window | |
DAYS_TGT_INV_SUPPLY | VARCHAR2 | (0) | Days Tgt Inv Supply | |
DAYS_TGT_INV_WINDOW | VARCHAR2 | (0) | Days Tgt Inv Window | |
CONTINOUS_TRANSFER | VARCHAR2 | (0) | Continous Transfer | |
CONVERGENCE | VARCHAR2 | (0) | Convergence | |
CREATE_SUPPLY_FLAG | VARCHAR2 | (0) | Create Supply Flag | |
DIVERGENCE | VARCHAR2 | (0) | Divergence | |
PLANNING_EXCEPTION_SET | VARCHAR2 | (0) | Planning Exception Set | |
INVENTORY_USE_UP_DATE | VARCHAR2 | (0) | Inventory Use Up Date | |
PLANNING_MAKE_BUY_CODE | VARCHAR2 | (0) | Planning Make Buy Code | |
MARGIN | VARCHAR2 | (0) | Margin | |
WEIGHT_UOM | VARCHAR2 | (0) | Weight Uom | |
VOLUME_UOM | VARCHAR2 | (0) | Volume Uom | |
ROUNDING_CONTROL_TYPE | VARCHAR2 | (0) | Rounding Control Type | |
ATP_FLAG | VARCHAR2 | (0) | Atp Flag | |
ATP_COMPONENTS_FLAG | VARCHAR2 | (0) | Atp Components Flag | |
DEMAND_FULFILLMENT_LT | VARCHAR2 | (0) | Demand Fulfillment Lt | |
LOTS_EXPIRATION | VARCHAR2 | (0) | Lots Expiration | |
VMI_MINIMUM_UNITS | VARCHAR2 | (0) | Vmi Minimum Units | |
VMI_MINIMUM_DAYS | VARCHAR2 | (0) | Vmi Minimum Days | |
VMI_MAXIMUM_UNITS | VARCHAR2 | (0) | Vmi Maximum Units | |
VMI_MAXIMUM_DAYS | VARCHAR2 | (0) | Vmi Maximum Days | |
VMI_FIXED_ORDER_QUANTITY | VARCHAR2 | (0) | Vmi Fixed Order Quantity | |
PLANNER_CODE | VARCHAR2 | (0) | ||
CONSIGNED_FLAG | VARCHAR2 | (0) | Consigned Flag | |
LEADTIME_VARIABILITY | VARCHAR2 | (0) | Leadtime Variability | |
UPDATED_COLUMNS_COUNT | VARCHAR2 | (0) | Updated Columns Count | |
UPDATED | CHAR | (2) | Updated |
Cut, paste (and edit) the following text to query this object:
SELECT SOURCE_ROW_ID
, PLAN_ID
, SR_INSTANCE_ID
, ORGANIZATION_ID
, INVENTORY_ITEM_ID
, ITEM_SEGMENTS
, ORGANIZATION_CODE
, ORI_PLANNER_CODE
, SR_CATEGORY_ID
, CATEGORY_SET_ID
, CATEGORY
, DESCRIPTION
, ORI_CRITICAL_COMPONENT_FLAG
, ORI_FULL_LEAD_TIME
, ORI_PREPROCESSING_LEAD_TIME
, ORI_POSTPROCESSING_LEAD_TIME
, ORI_FIXED_LEAD_TIME
, ORI_VARIABLE_LEAD_TIME
, ORI_FIXED_ORDER_QUANTITY
, ORI_FIXED_DAYS_SUPPLY
, ORI_SHRINKAGE_RATE
, ORI_FIXED_LOT_MULTIPLIER
, ORI_MINIMUM_ORDER_QUANTITY
, ORI_MAXIMUM_ORDER_QUANTITY
, ORI_SERVICE_LEVEL
, ORI_CARRYING_COST
, ORI_DEMAND_TIME_FENCE_DAYS
, ORI_ATO_FORECAST_CONTROL
, ORI_PLANNING_TIME_FENCE_DAYS
, ORI_STANDARD_COST
, ORI_NET_SELLING_PRICE
, ORI_PIP_FLAG
, ORI_LIST_PRICE
, ORI_SUBSTITUTION_WINDOW
, ORI_SAFETY_STOCK_BUCKET_DAYS
, ORI_UNIT_WEIGHT
, ORI_UNIT_VOLUME
, ORI_SAFETY_STOCK_CODE
, ORI_SAFETY_STOCK_PERCENT
, ORI_ABC_CLASS_NAME
, ORI_MRP_PLANNING_CODE
, ORI_DRP_PLANNED
, ORI_DAYS_MAX_INV_SUPPLY
, ORI_DAYS_MAX_INV_WINDOW
, ORI_DAYS_TGT_INV_SUPPLY
, ORI_DAYS_TGT_INV_WINDOW
, ORI_CONTINOUS_TRANSFER
, ORI_CONVERGENCE
, ORI_CREATE_SUPPLY_FLAG
, ORI_DIVERGENCE
, ORI_PLANNING_EXCEPTION_SET
, ORI_INVENTORY_USE_UP_DATE
, ORI_PLANNING_MAKE_BUY_CODE
, ORI_MARGIN
, ORI_WEIGHT_UOM
, ORI_VOLUME_UOM
, ORI_ROUNDING_CONTROL_TYPE
, ORI_ATP_FLAG
, ORI_ATP_COMPONENTS_FLAG
, ORI_DEMAND_FULFILLMENT_LT
, ORI_LOTS_EXPIRATION
, ORI_VMI_MINIMUM_UNITS
, ORI_VMI_MINIMUM_DAYS
, ORI_VMI_MAXIMUM_UNITS
, ORI_VMI_MAXIMUM_DAYS
, ORI_VMI_FIXED_ORDER_QUANTITY
, ORI_CONSIGNED_FLAG
, ORI_LEADTIME_VARIABILITY
, DESTINATION_ROW_ID
, SIMULATION_SET_ID
, CRITICAL_COMPONENT_FLAG
, FULL_LEAD_TIME
, PREPROCESSING_LEAD_TIME
, POSTPROCESSING_LEAD_TIME
, FIXED_LEAD_TIME
, VARIABLE_LEAD_TIME
, FIXED_ORDER_QUANTITY
, FIXED_DAYS_SUPPLY
, SHRINKAGE_RATE
, FIXED_LOT_MULTIPLIER
, MINIMUM_ORDER_QUANTITY
, MAXIMUM_ORDER_QUANTITY
, SERVICE_LEVEL
, CARRYING_COST
, DEMAND_TIME_FENCE_DAYS
, ATO_FORECAST_CONTROL
, PLANNING_TIME_FENCE_DAYS
, STANDARD_COST
, NET_SELLING_PRICE
, PIP_FLAG
, LIST_PRICE
, SUBSTITUTION_WINDOW
, SAFETY_STOCK_BUCKET_DAYS
, UNIT_WEIGHT
, UNIT_VOLUME
, SAFETY_STOCK_CODE
, SAFETY_STOCK_PERCENT
, ABC_CLASS_NAME
, MRP_PLANNING_CODE
, DRP_PLANNED
, DAYS_MAX_INV_SUPPLY
, DAYS_MAX_INV_WINDOW
, DAYS_TGT_INV_SUPPLY
, DAYS_TGT_INV_WINDOW
, CONTINOUS_TRANSFER
, CONVERGENCE
, CREATE_SUPPLY_FLAG
, DIVERGENCE
, PLANNING_EXCEPTION_SET
, INVENTORY_USE_UP_DATE
, PLANNING_MAKE_BUY_CODE
, MARGIN
, WEIGHT_UOM
, VOLUME_UOM
, ROUNDING_CONTROL_TYPE
, ATP_FLAG
, ATP_COMPONENTS_FLAG
, DEMAND_FULFILLMENT_LT
, LOTS_EXPIRATION
, VMI_MINIMUM_UNITS
, VMI_MINIMUM_DAYS
, VMI_MAXIMUM_UNITS
, VMI_MAXIMUM_DAYS
, VMI_FIXED_ORDER_QUANTITY
, PLANNER_CODE
, CONSIGNED_FLAG
, LEADTIME_VARIABILITY
, UPDATED_COLUMNS_COUNT
, UPDATED
FROM APPS.MSC_COLL_ITEM_ATTRIBUTES_V;
APPS.MSC_COLL_ITEM_ATTRIBUTES_V is not referenced by any database object
|
|
|