APPS.INV_MWB_TREE dependencies on MTL_ITEM_LOCATIONS_KFV

Line 3693: loc_id mtl_item_locations_kfv.inventory_location_id%TYPE;

3689: ) IS
3690: query_str VARCHAR2(10000);
3691: query_hdl NUMBER;
3692: rows_processed NUMBER;
3693: loc_id mtl_item_locations_kfv.inventory_location_id%TYPE;
3694: loc_code mtl_item_locations_kfv.concatenated_segments%TYPE;
3695: stock_loc_code mtl_parameters.stock_locator_control_code%TYPE;
3696: loc_type NUMBER;
3697: i NUMBER := x_tbl_index;

Line 3694: loc_code mtl_item_locations_kfv.concatenated_segments%TYPE;

3690: query_str VARCHAR2(10000);
3691: query_hdl NUMBER;
3692: rows_processed NUMBER;
3693: loc_id mtl_item_locations_kfv.inventory_location_id%TYPE;
3694: loc_code mtl_item_locations_kfv.concatenated_segments%TYPE;
3695: stock_loc_code mtl_parameters.stock_locator_control_code%TYPE;
3696: loc_type NUMBER;
3697: i NUMBER := x_tbl_index;
3698: j NUMBER := x_node_value;

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

3752: --ER(3338592) Changes
3753: AND p_item_description IS NULL THEN
3754: --ER(3338592) Changes
3755: query_str := 'SELECT wlpn.locator_id, mil.concatenated_segments ';
3756: query_str := query_str || 'FROM mtl_item_locations_kfv mil, wms_license_plate_numbers wlpn WHERE 1=1 ';
3757: query_str := query_str || 'AND mil.inventory_location_id = wlpn.locator_id ';
3758: query_str := query_str || 'AND mil.organization_id = wlpn.organization_id ';
3759:
3760: IF p_sub_type = 2 THEN