APPS.INV_MWB_TREE1 dependencies on MTL_ITEM_LOCATIONS_KFV

Line 8953: loc_id mtl_item_locations_kfv.inventory_location_id%TYPE;

8949: ) IS
8950: query_str VARCHAR2(10000);
8951: query_hdl NUMBER;
8952: rows_processed NUMBER;
8953: loc_id mtl_item_locations_kfv.inventory_location_id%TYPE;
8954: loc_code mtl_item_locations_kfv.concatenated_segments%TYPE;
8955: stock_loc_code mtl_parameters.stock_locator_control_code%TYPE;
8956: loc_type NUMBER;
8957: i NUMBER := x_tbl_index;

Line 8954: loc_code mtl_item_locations_kfv.concatenated_segments%TYPE;

8950: query_str VARCHAR2(10000);
8951: query_hdl NUMBER;
8952: rows_processed NUMBER;
8953: loc_id mtl_item_locations_kfv.inventory_location_id%TYPE;
8954: loc_code mtl_item_locations_kfv.concatenated_segments%TYPE;
8955: stock_loc_code mtl_parameters.stock_locator_control_code%TYPE;
8956: loc_type NUMBER;
8957: i NUMBER := x_tbl_index;
8958: j NUMBER := x_node_value;

Line 9048: query_str := query_str || 'FROM mtl_item_locations_kfv mil, wms_license_plate_numbers wlpn WHERE 1=1 ';

9044: --ER(3338592) Changes
9045: AND inv_mwb_globals.g_item_description IS NULL THEN
9046: --ER(3338592) Changes
9047: query_str := 'SELECT wlpn.locator_id, mil.concatenated_segments ';
9048: query_str := query_str || 'FROM mtl_item_locations_kfv mil, wms_license_plate_numbers wlpn WHERE 1=1 ';
9049: query_str := query_str || 'AND mil.inventory_location_id = wlpn.locator_id ';
9050: query_str := query_str || 'AND mil.organization_id = wlpn.organization_id ';
9051:
9052: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN