DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_LOV dependencies on MTL_ITEM_LOCATIONS_KFV

Line 1121: from mtl_item_locations_kfv k

1117: else
1118: if p_wms_task_type in (1,4,5) then
1119: begin
1120: select concatenated_segments into v_concatenated_segments
1121: from mtl_item_locations_kfv k
1122: where k.inventory_location_id = p_transfer_to_location_id
1123: and k.organization_id = p_organization_id;
1124: EXCEPTION
1125: WHEN no_data_found THEN

Line 1133: from mtl_item_locations_kfv k

1129: END;
1130: elsif p_wms_task_type = 2 then
1131: begin
1132: select concatenated_segments into v_concatenated_segments
1133: from mtl_item_locations_kfv k
1134: where k.inventory_location_id = p_locator_id
1135: and k.organization_id = p_organization_id;
1136: EXCEPTION
1137: WHEN no_data_found THEN