[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'
780: || ''') , '||p_organization_id;
781: DEBUG ('40 l_select_str is ' || l_select_str, ' add_locators_grid',
782: 9);
783: l_from_str :=
784: ' from mtl_item_locations_kfv milk, mtl_secondary_inventories msi,
785: mtl_material_statuses mms1,mtl_material_statuses mms2 ';
786: DEBUG ('10 l_from_str is ' || l_from_str, ' add_locators_grid', 9);
787: l_where_str := ' where 1=1 ';
788: DEBUG ('10 l_where_str is ' || l_where_str, ' add_locators_grid', 9);
2614: WHERE zone_id = p_zone_id;
2615:
2616: CURSOR c_subinventory_code IS
2617: SELECT 1
2618: FROM mtl_secondary_inventories
2619: WHERE organization_id = p_organization_id
2620: AND secondary_inventory_name = p_subinventory_code;
2621:
2622: CURSOR c_locator_id IS
2706: l_progress_indicator := '50';
2707:
2708: /**
2709: * p_subinventory_code must exist in for that
2710: * p_organization_id in MTL_SECONDARY_INVENTORIES
2711: */
2712: OPEN c_subinventory_code;
2713: FETCH c_subinventory_code INTO l_id;
2714: IF c_subinventory_code%NOTFOUND THEN