[Home] [Help]
221: )
222: , p_org_id
223: FROM wms_zone_locators wzl,
224: mtl_item_locations_kfv milk,
225: mtl_secondary_inventories msi,
226: mtl_material_statuses mms1,
227: mtl_material_statuses mms2
228: WHERE wzl.zone_id = p_zone_id
229: AND wzl.organization_id = p_org_id
257: g_subinventory_types (1)
258: )
259: , p_org_id
260: FROM wms_zone_locators wzl,
261: mtl_secondary_inventories msi,
262: mtl_material_statuses mms
263: WHERE wzl.zone_id = p_zone_id
264: AND wzl.organization_id = p_org_id
265: AND NVL(wzl.entire_sub_flag,'N') = 'Y'
779: || ''') , '||p_organization_id;
780: DEBUG ('40 l_select_str is ' || l_select_str, ' add_locators_grid',
781: 9);
782: l_from_str :=
783: ' from mtl_item_locations_kfv milk, mtl_secondary_inventories msi,
784: mtl_material_statuses mms1,mtl_material_statuses mms2 ';
785: DEBUG ('10 l_from_str is ' || l_from_str, ' add_locators_grid', 9);
786: l_where_str := ' where 1=1 ';
787: DEBUG ('10 l_where_str is ' || l_where_str, ' add_locators_grid', 9);
2587: WHERE zone_id = p_zone_id;
2588:
2589: CURSOR c_subinventory_code IS
2590: SELECT 1
2591: FROM mtl_secondary_inventories
2592: WHERE organization_id = p_organization_id
2593: AND secondary_inventory_name = p_subinventory_code;
2594:
2595: CURSOR c_locator_id IS
2679: l_progress_indicator := '50';
2680:
2681: /**
2682: * p_subinventory_code must exist in for that
2683: * p_organization_id in MTL_SECONDARY_INVENTORIES
2684: */
2685: OPEN c_subinventory_code;
2686: FETCH c_subinventory_code INTO l_id;
2687: IF c_subinventory_code%NOTFOUND THEN