[Home] [Help]
650: l_stmt_id := 30;
651: -- Compute the weight/volume capacities for locators in warehouse
652: -- enabled organizations. No need to specifically filter out
653: -- process organizations since their locator setup is not
654: -- stored in MTL_ITEM_LOCATIONS.
655: --
656: -- The locator weight capacity, volume_capacity, weight_uom_code
657: -- and volume_uom_code are stored in the MTL_ITEM_LOCATIONS table.
658: --
653: -- process organizations since their locator setup is not
654: -- stored in MTL_ITEM_LOCATIONS.
655: --
656: -- The locator weight capacity, volume_capacity, weight_uom_code
657: -- and volume_uom_code are stored in the MTL_ITEM_LOCATIONS table.
658: --
659: -- All possible conversions to the reporting UOMs are stored in
660: -- the standard conversion rates table, OPI_DBI_REP_UOM_STD_CONV_F.
661: -- The extraction program will join twice to this table, once
670: -- 2. Locator Volume capacity (value or UOM) might be missing.
671: -- Either of the two above are not cause for error, and the corresponding
672: -- capacity should be stored as NULL.
673: -- The above conditions are detectable as the value of max_weight
674: -- and max_cubic_area in MTL_ITEM_LOCATIONS will be NULL if the setup
675: -- is missing.
676: --
677: -- If both capacities are NULL, then for conciseness don't store a
678: -- row for that locator.
804: C_DUMMY_UOM_CODE) weight_uom_code,
805: l_wt_rep_uom_code wt_rep_uom_code,
806: nvl (mil.volume_uom_code, C_DUMMY_UOM_CODE) volume_uom_code,
807: l_vol_rep_uom_code vol_rep_uom_code
808: FROM mtl_item_locations mil,
809: mtl_parameters mp
810: WHERE mp.wms_enabled_flag = 'Y'
811: AND mil.organization_id = mp.organization_id
812: -- filter out locators with neither capacity defined