APPS.INV_MWB_TREE1 dependencies on MTL_ITEM_LOCATIONS_KFV

Line 7518: loc_id mtl_item_locations_kfv.inventory_location_id%TYPE;

7514: ) IS
7515: query_str VARCHAR2(10000);
7516: query_hdl NUMBER;
7517: rows_processed NUMBER;
7518: loc_id mtl_item_locations_kfv.inventory_location_id%TYPE;
7519: loc_code mtl_item_locations_kfv.concatenated_segments%TYPE;
7520: stock_loc_code mtl_parameters.stock_locator_control_code%TYPE;
7521: loc_type NUMBER;
7522: i NUMBER := x_tbl_index;

Line 7519: loc_code mtl_item_locations_kfv.concatenated_segments%TYPE;

7515: query_str VARCHAR2(10000);
7516: query_hdl NUMBER;
7517: rows_processed NUMBER;
7518: loc_id mtl_item_locations_kfv.inventory_location_id%TYPE;
7519: loc_code mtl_item_locations_kfv.concatenated_segments%TYPE;
7520: stock_loc_code mtl_parameters.stock_locator_control_code%TYPE;
7521: loc_type NUMBER;
7522: i NUMBER := x_tbl_index;
7523: j NUMBER := x_node_value;

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

7604: --ER(3338592) Changes
7605: AND inv_mwb_globals.g_item_description IS NULL THEN
7606: --ER(3338592) Changes
7607: query_str := 'SELECT wlpn.locator_id, mil.concatenated_segments ';
7608: query_str := query_str || 'FROM mtl_item_locations_kfv mil, wms_license_plate_numbers wlpn WHERE 1=1 ';
7609: query_str := query_str || 'AND mil.inventory_location_id = wlpn.locator_id ';
7610: query_str := query_str || 'AND mil.organization_id = wlpn.organization_id ';
7611:
7612: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN