APPS.WMS_ZONES_PVT dependencies on MTL_ITEM_LOCATIONS

Line 224: mtl_item_locations_kfv milk,

220: g_subinventory_types(1)
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

Line 364: l_fm_loc_name mtl_item_locations_kfv.concatenated_segments%TYPE;

360: l_jtf_message wms_zone_locators_temp.MESSAGE%TYPE;
361: l_jtf_message_id VARCHAR2(4) := 'NULL';
362:
363: -- bug 3659062
364: l_fm_loc_name mtl_item_locations_kfv.concatenated_segments%TYPE;
365: l_to_loc_name mtl_item_locations_kfv.concatenated_segments%TYPE;
366:
367: BEGIN
368:

Line 365: l_to_loc_name mtl_item_locations_kfv.concatenated_segments%TYPE;

361: l_jtf_message_id VARCHAR2(4) := 'NULL';
362:
363: -- bug 3659062
364: l_fm_loc_name mtl_item_locations_kfv.concatenated_segments%TYPE;
365: l_to_loc_name mtl_item_locations_kfv.concatenated_segments%TYPE;
366:
367: BEGIN
368:
369: DEBUG('In procedure :', l_module_name,0);

Line 451: FROM mtl_item_locations_kfv

447:
448: IF(p_fm_loc_id IS NOT NULL AND p_fm_loc_id <> -999) THEN
449: SELECT concatenated_segments
450: INTO l_fm_loc_name
451: FROM mtl_item_locations_kfv
452: WHERE inventory_location_id = p_fm_loc_id
453: AND organization_id = p_organization_id;
454: END IF;
455:

Line 459: FROM mtl_item_locations_kfv

455:
456: IF(p_to_loc_id IS NOT NULL AND p_to_loc_id <> -999) THEN
457: SELECT concatenated_segments
458: INTO l_to_loc_name
459: FROM mtl_item_locations_kfv
460: WHERE inventory_location_id = p_to_loc_id
461: AND organization_id = p_organization_id;
462: END IF;
463:

Line 783: ' from mtl_item_locations_kfv milk, mtl_secondary_inventories msi,

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);

Line 2597: FROM mtl_item_locations

2593: AND secondary_inventory_name = p_subinventory_code;
2594:
2595: CURSOR c_locator_id IS
2596: SELECT 1
2597: FROM mtl_item_locations
2598: WHERE inventory_location_id = p_locator_id
2599: AND organization_id = p_organization_id
2600: AND subinventory_code = p_subinventory_code;
2601:

Line 2700: * p_organization_id in MTL_ITEM_LOCATIONS

2696: * be null, this is validated above.
2697: *
2698: * However if p_entire_sub_flag is NULL or N then
2699: * p_locator_id must exist in the p_subinventory_code/
2700: * p_organization_id in MTL_ITEM_LOCATIONS
2701: */
2702: IF NVL(p_entire_sub_flag, 'N') = 'N' THEN
2703:
2704: OPEN c_locator_id;