MSC_AP_ITEM_SUBINV_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
ITEM_NUMBER INVENTORY_ITEM_ID ORGANIZATION_ID ORGANIZATION_CODE SECONDARY_INVENTORY MINIMUM_ORDER_QUANTITY MAXIMUM_ORDER_QUANTITY MIN_MINMAX_QUANTITY MAX_MINMAX_QUANTITY FIXED_LOT_MULTIPLIER PREPROCESSING_LEAD_TIME PROCESSING_LEAD_TIME POSTPROCESSING_LEAD_TIME SUBINV_PLANNING_ENABLED CONVERSION_RATE

Query

SQL_Statement

SELECT esiv.item_number , iisi.inventory_item_id , iisi.organization_id , iop.organization_code , iisi.secondary_inventory , iisi.minimum_order_quantity , iisi.maximum_order_quantity , iisi.min_minmax_quantity , iisi.max_minmax_quantity , iisi.fixed_lot_multiple fixed_lot_multiplier , iisi.preprocessing_lead_time , iisi.processing_lead_time , iisi.postprocessing_lead_time , mp.subinv_planning_enabled , CASE WHEN MSC_COLL_UTILS.IS_FEATURE_CHOICE_SELECTED('ORA_INV_UOM_USAGE') = 1 AND iisi.minmax_quantity_uom IS NOT NULL AND esiv.primary_uom_code IS NOT NULL AND iisi.minmax_quantity_uom != esiv.primary_uom_code THEN inv_convert.inv_um_convert(iisi.inventory_item_id, 10, NULL, iisi.minmax_quantity_uom, esiv.primary_uom_code, NULL, NULL) ELSE 1 END conversion_rate FROM inv_item_sub_inventories iisi , inv_secondary_inventories isi , egp_system_items_vl esiv , inv_org_parameters iop , msc_parameters mp WHERE ( isi.availability_type = 1 OR ( isi.availability_type = 2 AND nvl(isi.planning_level,2) = 1 AND nvl(mp.collect_nonnettable_par_subinv,2) = 1 ) ) AND iisi.organization_id = isi.organization_id AND iisi.secondary_inventory = isi.secondary_inventory_name AND TRUNC(NVL(isi.disable_date,SYSDATE)) >= TRUNC(SYSDATE) AND iisi.inventory_item_id = esiv.inventory_item_id AND iisi.organization_id = esiv.organization_id AND esiv.mrp_planning_code = 10 AND iop.organization_code = mp.organization_code AND mp.subinv_planning_enabled = 1 AND iisi.organization_id = iop.organization_id